← Back to Work

Backend · 2024 · European Outdoors

European Outdoors

Real-time warehouse sync across Shopify, Amazon Seller and Vendor Central

Role: Software Engineer

Node.jsMongoDBShopify APIAmazon Seller Central

+40%

Processing Speed

Average improvement

0

Oversell Incidents

Since launch

3

Channels Synced

Shopify + 2 Amazon

Auto

Reconciliation

No manual effort

The Challenge

  • —Real-time inventory sync across Shopify, Amazon Seller Central and Vendor Central simultaneously
  • —Each platform had different data formats and update frequencies requiring normalization
  • —Processing delays were causing inventory inaccuracies and operational bottlenecks in warehouse workflows

Process

  • 01Built unified warehouse management backend in Node.js with adapters for each platform
  • 02Implemented real-time webhooks and polling mechanisms for Shopify and Amazon data sync
  • 03Designed MongoDB pipelines to normalize and merge data from all three platforms into a single inventory view
  • 04Built automated daily reporting pipelines for performance insights across all marketplaces

The Solution

  • ✓Real-time data sync across Shopify, Amazon Seller Central and Vendor Central
  • ✓Unified inventory view reducing discrepancies and improving warehouse accuracy
  • ✓Processing time reduced by 30 to 50% through parallel sync and normalized pipelines
  • ✓Daily automated reports providing multi-marketplace performance insights

Architecture

1

Unified Inventory Layer

MongoDB stores authoritative stock levels with per-channel allocation rules. Any stock change triggers sync events to all connected channels with optimistic locking to prevent race conditions.

2

Multi-Channel Sync Engine

Shopify webhooks and Amazon SP API polling feed into a queue-based processor. Each channel adapter handles its own rate limits, retries, and error reporting independently.

3

Reconciliation Jobs

Scheduled jobs compare channel stock levels against the MongoDB source of truth and flag or auto-correct discrepancies. Provides a safety net on top of real-time sync.

Takeaways

  • →Learned multi-platform API integration patterns and data normalization at scale
  • →Understood the complexity of keeping distributed inventory systems in sync in real time