Jim ChangSoftware Engineer ยท System Integration
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.

Need something built or connected?

Send me a few lines on what you need and when you need it by.