Home/Case Studies/Retail & Commerce
Retail & Commerce

One source of truth for stock across channels

An integration layer that reconciles inventory across stores, warehouse and online storefront in near real time.

The challenge

Stock levels were maintained separately in the point-of-sale system, the warehouse system and the online store, synchronised by an overnight batch job. Overselling was a daily occurrence, and staff had quietly built their own spreadsheets to compensate.

What we did

  • Change-data-capture from each source system into a single event stream, rather than another point-to-point integration.
  • A reconciliation service with explicit conflict-resolution rules agreed with operations, so disagreements resolve predictably.
  • Reservation logic so items in an active cart are held rather than double-sold.
  • An operations dashboard that surfaces sync failures immediately instead of the next morning.

What changed

  • Overselling incidents dropped to a small, explainable number.
  • The overnight batch window disappeared entirely.
  • The shadow spreadsheets went away on their own.

Stack: Go · Kafka · PostgreSQL · Redis · GCP · Terraform

Let's scope your next build.

Tell us what you're trying to ship. We'll come back with an honest view of scope, sequence and the fastest credible path to production.

Chat with us