Projects / Inventory & Order Sync Service
Inventory & Order Sync Service
Backend Developer // May 2020 - Jul 2020
Highlights
- Nightly sync processing 3,000+ SKUs across 3 supplier APIs
- Order routing engine selecting optimal supplier by cost and proximity
- Redis retry queue with exponential backoff for fault tolerance
- Unified data schema normalizing REST and SOAP supplier responses
- Eliminated hours of daily manual data entry
- Internal monitoring endpoints for queue health and sync logs
About This Project
A backend middleware service built for a wholesale distributor to automate inventory synchronization and order routing across multiple supplier APIs and their internal ERP system. The service replaced a manual process where staff copied data between systems daily.
The Node.js service runs scheduled jobs that pull inventory levels from 3 supplier APIs (REST and SOAP), normalize the data into a unified schema, and push updates to the client's ERP database. Discrepancies are flagged and logged for manual review. Order routing logic determines the optimal supplier based on stock availability, pricing tiers, and shipping proximity.
A retry queue built on Redis handles transient API failures with exponential backoff, ensuring no orders or inventory updates are lost. The service exposes internal REST endpoints for the client's operations team to trigger manual syncs, view processing logs, and monitor queue health.