E-commerce
Multi-Country Marketplace Sync
Order, product, stock and finance sync between online marketplaces in six countries, a seller order-management system and a cloud data warehouse.
The problem
An e-commerce enabler ran brand stores on several regional marketplaces across six countries. Orders, products, stock and payouts had to reach its order-management system and data warehouse continuously, country by country, without duplicates.
What I built
- Country-parameterised producers that pull orders, products and finance data from marketplace APIs, with delta, full-base and fast modes.
- Scheduled syncs running from every minute to daily, plus serverless functions for brand-specific feeds.
- Contributions to the multi-country order-management system: per-country Celery workers, marketplace token refresh, bulk B2B uploads, billing and data-warehouse exports.
- Brand middleware for sales orders and returns with third-party logistics, covering return-to-warehouse and return-to-merchant flows, demand reports and status validation.
Technical highlights
- Nearly 4,000 commits over four years of continuous operation.
- Duplicate-order clean-up and submission tracking, so retries never post twice.
- Centralised logging, with data landed in a cloud data warehouse for reporting.