Contact person: Business Client

Phone:Show

Email:Show

Location: Zarqa, Jordan

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Title: [login to view URL] Developer for CJ Dropshipping API — Admin Bulk Import (Any Category), SKU-Based Updates, 24h Checker

I own a general-purpose e-commerce store. I need a developer proficient in robust API integrations to implement an admin-controlled CJ Dropshipping workflow across ALL categories (e.g., Women, Men, Kids, Beauty, Home, Electronics, Accessories, Sports, Pets, Automotive, etc.). The admin must be able to enable/disable all operations, bulk-request products by category/keywords and quantity (e.g., “Women > Clothing > Blouses, 500”), review candidates with SKUs, approve selections, then auto-import with final pricing, variants (colors/sizes), inventory, and logistics. A 24h checker must monitor each SKU for changes and create proposals the admin can Approve or Modify.

Contact:
- WhatsApp: 00962781637033
- Telegram: @Teem_Shopixo

Scope of Work
- Admin Master Controls
- Global Kill Switch to enable/disable write/import operations.
- Admin-only access guard for all CJ endpoints and admin UI.
- CJ credentials managed via admin settings (no redeploy needed).

- Admin Bulk Finder (N items, any category)
- Admin selects category path from taxonomy, sets quantity target (e.g., 500), adds keywords and optional filters:
- Price range, ships-to Saudi Arabia, max processing time, rating, stock thresholds, video/images availability.
- Tool queries CJ and returns the “best” candidates with:
- CJ SKU and product PID (+ CJ detail path like /product/query?pid=...).
- Supplier price, estimated shipping to SA, landed cost.
- Variants summary (colors/sizes), stock, processing/delivery time.
- Title, description, images, and video (if available).
- Admin can deselect any items; nothing is published until Approve.

- Approval → Auto-Import Pipeline
- On Approve:
- Create product records with unique slug.
- Create variant records mapped by CJ SKU (SKU is the authoritative key).
- Import/attach images and video.
- Compute final SAR retail price (USD→SAR) including:
- Supplier cost + shipping to SA + payment fees + VAT (if applicable) + margin.
- Smart rounding to attractive price points (e.g., 49/79/99/149).
- Persist processing time and expected delivery time.
- Save notes and description as provided by CJ.
- Strict deduplication by CJ product id (no duplicates on re-import).

- 24h Checker + Notifications (SKU-based)
- Scheduled job (every 24h) scans all stored SKUs against CJ:
- Detects changes in supplier cost, shipping, stock, images/video, processing/delivery.
- Creates “proposals” with diffs and recommended actions (e.g., reprice).
- Admin dashboard notifications:
- OK → auto-apply proposed changes.
- Modify → open an edit form prefilled with proposed values.
- Optional: email/Slack alerts.

- Sync Tools, Reliability, Security
- On-demand sync endpoint for price/media/stock refresh.
- Resilient timeouts/retries; handle CJ’s variable response shapes; respect rate limits.
- Admin-only routes; no client-side exposure of secrets.
- Logging + audit trail for all write operations.

Deliverables
- Admin UI:
- Bulk Finder page (category/keywords/quantity/filters → candidates → approve).
- Proposal Review page (24h checker) with Approve/Modify actions.
- API Endpoints:
- Search/fetch candidates (by category/keywords/filters/limit).
- Batch approve/import → products, variants (by SKU), images, pricing.
- Sync endpoints for price/media/stock.
- Proposal endpoints (create/list/approve/modify).
- Data & Jobs:
- Data model for products, variants (with cj_sku), CJ product id, pricing metadata.
- Proposals (diffs), audit logs, runtime settings (kill switch, CJ creds).
- Scheduled job (24h) for SKU diffs (e.g., Vercel Cron) + optional queue for rate limits.
- Pricing Engine:
- USD→SAR conversion (configurable).
- Margin/fees/VAT settings.
- Rounding strategy for attractive retail prices.
- Docs & Tests:
- Setup notes, environment variables, admin usage guide.
- Acceptance tests and a short end-to-end test script.

Acceptance Criteria
- Admin Control: Kill Switch disables write/import instantly.
- Bulk Finder (Any Category): Admin can request “Category Path, N items (e.g., 500)” and see SKU/PID/cost/shipping/variants/stock/processing/delivery/media, deselect, then Approve.
- Import: Approved items appear as products with variants mapped by SKU; SAR prices include all cost components and rounding; no duplicates; clean slug generation.
- 24h Checker: Creates proposals per SKU changes; admin can OK/Modify each.
- Sync: Manual sync updates price/media/stock without admin review.
- Reliability: Timeouts/retries, rate limits respected, errors logged.

Tech Preferences
- [login to view URL] (App Router) + TypeScript, Vercel hosting.
- Supabase (Postgres) for data.
- CJ Dropshipping API for product/variant/stock/shipping data.
- Optional: Upstash Redis for rate-limiting; Cloudinary for media.
- Notifications: in-app; optional email/Slack.

What I Provide
- Access to repo and hosting (Vercel/Supabase).
- CJ account (email + API key), configured server-side via admin settings.
- Category taxonomy and pricing policy details.

What to Include in Your Proposal
- Relevant experience with CJ or similar marketplaces (AliExpress/Shopify, etc.).
- A concise plan covering:
- Token management, rate limits, resilient fetch.
- Ranking criteria for “best N” candidates (multi-signal scoring).
- SKU-centric variant mapping and import pipeline.
- Pricing formula for KSA (conversion, fees, VAT, margin, rounding).
- 24h checker design (diffing by SKU) and notifications.
- Estimated timeline and budget.
- Links to previous similar work.

Contact:
- WhatsApp: 00962781637033
- Telegram: @Teem_Shopixo" (client-provided description)