Multi-Warehouse Stock Without the Phone-Call Circus
Overstocked at branch A, sold out at branch B. How to run transfers, allocation, and real-time visibility once your business spans several locations.
The moment a second branch opens, a new habit appears in almost every business: calling the other store to ask about stock. “Do you still have the black size 42 over there?” Someone across town walks to the shelf, counts, walks back to the phone. With three, four, five branches, a real chunk of your payroll is spent being a human stock-lookup service.
And that is the mildest symptom.
The classic multi-location diseases
The expensive symptoms look like this. The same product piles up at one branch while another sells out — so one location loses sales while the other ends up discounting to clear space. Double purchasing: two branches independently order from the supplier because neither knows the other just received a shipment. Goods get “borrowed” between stores via a courier with no paperwork, and two months later both stocktakes are a mess and nobody remembers when the items moved.
One root cause underneath all of it: each location’s stock lives in its own private record. A spreadsheet per branch — or worse, the store manager’s memory.
The foundation: one system, stock per location
Rule one of multi-warehouse inventory: a product has one master record (SKU, name, price), but its quantity is tracked per location. Not “80 in total” but “50 at central warehouse, 20 at branch A, 10 at branch B”. Every transaction — a sale at a branch register, a goods receipt, a return — moves the stock of the location where it happened.
It sounds obvious, but this is precisely what separates a real inventory system from a spreadsheet with extra columns. Once this foundation exists, “where do we still have size 42” is answered by a screen in two seconds, by anyone, from anywhere. The inter-branch phone calls simply stop.
Transfers need a status, not just good intentions
Moving goods between locations is the most fragile moment. The principle: goods in transit are still your goods, and they must be visible in the system.
A healthy flow uses a transfer document with states. Branch B requests stock, the central warehouse picks and ships — at that moment central stock decreases and the goods show as in transit. When branch B receives and confirms the quantity, its stock increases. If 10 were shipped and 9 arrived, the gap surfaces that same day, not at a stocktake three months later.
Compare that to the old way: goods handed to a courier, mentioned in a group chat if someone remembers, both branches’ stock corrected manually eventually. Every undocumented transfer is a future stock discrepancy in two places at once.
In Tenavora, inter-location transfers follow exactly this ship-and-receive flow, with a trail of who sent and who received — it works the same for a central warehouse feeding several stores.
Allocation: which branch gets how much
If you purchase centrally and distribute to branches, do not split evenly. Split by how fast each location sells. A store next to a university and a store in a quiet suburb can have wildly different velocity for the same product.
The simplest workable method: use each location’s last 30 days of sales as the allocation key. A hundred units arrive; branch A drives 60% of that item’s sales, branch A gets 60. Then set a reorder point per location — the busy branch’s trigger is obviously different from the quiet one’s, and the central warehouse needs its own threshold for raising POs to suppliers.
One decision to make deliberately: whether negative stock is ever allowed, and who may adjust stock at each location. The more branches you have, the more access should be scoped per location — a store manager sees and manages their own stock, nothing else.
Where to start if everything is still manual
Do not overhaul every branch at once, but do switch them on together. The sequence that usually goes smoothly: consolidate products into one clean master list first (the perfect moment to kill duplicate SKUs), count opening stock at every location on the same day, then go live everywhere simultaneously. Opening balances counted on different days inherit discrepancies from day one.
After go-live, the discipline fits in one sentence: no goods change location without a transfer document. Tape it to the stockroom wall if you have to.
Multiple locations mean your business is growing — do not let stock management stay stuck in the single-store era. A system that knows where every unit sits at every location is not corporate luxury; it is the minimum requirement for branch three and four to add profit instead of headaches.