Skip to main content
Distribution · National

Real-time stock across 12 warehouses, visible in under a second.

A national distributor couldn't see true stock without an overnight batch. We put live, sub-second inventory in front of every branch.

12 Warehouses, one source
99.9% Monitored uptime
0.4 s Stock query latency
The challenge

Yesterday's stock, today's decisions.

Twelve warehouses fed a nightly batch job. By the time branches saw "current" stock each morning, it was already a day old — so they oversold fast-movers and hoarded safety stock on everything else.

Customer service couldn't promise availability with confidence, and procurement was buying against numbers it didn't trust.

The distributor needed live stock visibility across all twelve sites, fast enough to answer a customer on the phone.

Our approach

Live inventory, tuned to stay fast.

We consolidated all twelve warehouses into one Odoo Inventory configuration and replaced the nightly batch with real-time stock moves. Then we tuned the database and queries so that checking availability stays sub-second even at peak.

  • Twelve warehouses unified under one stock model
  • Real-time moves replacing the overnight batch
  • Query + index tuning for sub-second availability
  • Monitoring + alerting on the managed environment
The results

One number, trusted everywhere.

Every branch now sees the same live stock figure, returned in under a second. Overselling on fast-movers dropped, safety stock came down, and customer service can promise availability on the call. The platform runs on managed, monitored infrastructure at 99.9% uptime.

For the first time, every branch is looking at the same stock number — and it's right. That changed how we sell.
Supply Chain Lead
National distributor — full reference on request
Tech stack
Odoo 17InventoryPostgreSQL tuningDockerMonitoringManaged hosting

Making decisions on yesterday's stock?

Book a 30-minute audit. We'll find where your inventory truth is lagging.