Need a full-stack developer with experience working with Amazon API to implement Stage 1 of the internal PPC dashboard.
The project is real, the data is live, everything is ready to start.
Frontend prototype (5 pages, React + TypeScript):
WHAT IS ALREADY READY
— Frontend prototype on React 18 + TypeScript + Vite + Tailwind, deployed on Cloudflare Workers
— Backend FastAPI (Python 3.11) — basic structure
— 32 MariaDB tables — 3 SQL files with migrations written, need to apply
— Amazon Ads API: 5 profiles (DE, FR, ES, IT, NL), OAuth2 LWA configured, credentials ready
— Server 195.201.26.26 — Linux, MariaDB running
— Complete technical specification in DOCX — provided after bid acceptance
WHAT NEEDS TO BE DONE (7 tasks, 7 days)
1. General template (Layout)
Sidebar with 11 navigation items, Dark/Light theme switch, language switch DE/RU/EN. AppContext with settings saved in localStorage. Light theme by default.
2. Synchronization page (/sync)
4 sections: Amazon Ads, SP API, Stock Feed, file upload. Drag-and-drop area (.xlsx, .csv, .json). Synchronization progress via polling every 2 seconds. History of the last 20 operations.
3. Database
Apply 3 SQL migrations — 32 tables. Connect connection pool in backend. GET /health → {"db": "ok"}.
4. Amazon Advertising API
Create ads_sync.py. Daily sync at 03:00: profiles, campaigns, ad groups, keywords, product ads. Reports of 6 types (spCampaigns, spKeywords, spSearchTerm, spAdvertisedProduct, spTargeting, spPlacement). UPSERT pattern. API access is available.
5. Amazon SP API
Create sp_sync.py. Daily at 05:00: product catalog, FBA inventory, prices/Buy Box, orders for the day. 5 marketplace_id (DE/FR/ES/IT/NL). API access is available.
6. CSV upload via UI
Create csv_parser.py. Auto-detect report type by headers. POST /api/reports/upload, maximum 50 MB.
7. Stock Feed (auto-upload CSV)
Source: https://www.edelind.de/media/feed/DE_qty.csv
Daily at 06:00. Logic: qty=0 → pause campaigns, qty≥4 → resume.
STACK
Frontend: React 18 + TypeScript + Vite + Tailwind CSS
Backend: FastAPI, Python 3.11
DB: MariaDB 10.6
Scheduler: APScheduler
Deploy: Cloudflare Workers (frontend) + Linux VPS (backend)
REQUIREMENTS
— Degree in the field (programming, CS, IT)
— Real experience with Amazon Advertising API or Amazon SP API — mandatory, without it not considered
— Experience with FastAPI + React/TypeScript
— AI tools in daily work: Claude Code, GitHub Copilot, Cursor or similar — this is not an option, it's a condition
— Knowledge of MySQL/MariaDB, UPSERT pattern
ACCEPTANCE CONDITIONS
After submission we check:
— 32 tables in the DB (SHOW TABLES)
— Layout: 11 items, theme and language work
— /sync corresponds to the prototype
— Amazon Ads sync: data appears in amz_ppc_campaigns
— SP API sync: data in sp_inventory
— CSV upload via UI works
— Stock feed runs on schedule
— All operations are logged
WHAT TO WRITE IN THE BID
1. Links to projects with Amazon API (Ads or SP — any)
2. What AI tools you use in your work
3. Fixed price for all 7 tasks
4. Which task is the most difficult — and why
Bids without real experience with Amazon API will not be considered.