High-scale inventory synchronization
Connecting offline POS with online Shopify store in real-time.
Tech Stack Used
Service Type
End-to-End DevelopmentThe Challenge
RetailKing, a fashion brand with 20 physical stores, kept overselling products online that were already sold out in physical stores. Their previous inventory sync solution only ran once every night. During peak sale events like 12.12, this latency caused hundreds of order cancellations and angry customers.
The Solution
We architected a custom middleware service using Go (Golang) for high concurrency. We used Redis as a caching layer to handle the high read throughput. The system listens to webhooks from their offline POS system and updates the Shopify inventory API in near real-time (sub-second latency). We also built a conflict resolution queue to handle edge cases where an item is sold simultaneously online and offline.