Guides · Guide
Multi-location inventory management for 2 to 5 shops: one catalogue, transfers, counts per location
By Mourad Chama, founder of InventoryFlo · · 7 min read
Multi-location inventory management rests on one rule: one item catalogue shared by every site, with quantity, counts and reorder points held per location, and every movement between sites recorded as a transfer that leaves one place and arrives in the other. For two to five shops that means four decisions made once: which site holds what, who may transfer, how often each site counts, and which location reorders from suppliers.
Why does the second location break the spreadsheet?
With one shop, a quantity is a quantity. With two, the same SKU has two quantities, and three questions appear that the spreadsheet cannot answer: how much do we have in total, how much here, and where did the box go that left shop A on Tuesday? The usual fix, one tab per shop, works until someone updates shop B's tab from shop A, or forgets the van.
The fix is structural, not more discipline. Items are defined once (name, SKU, unit, cost); stock is held per location; and moving stock is an operation with two sides that must both be recorded. Once that is in place, the questions above are reports, not phone calls.
Step 1: one catalogue, stock per location
Start by cleaning the item list before you add a location: duplicates ("Oat milk 1L" and "Oatmilk 1 L") become two quantities in two places and never reconcile. One SKU per sellable or countable thing, one unit per SKU, variants (size, colour, roast) under one parent so reports can roll up. The items and variants help article shows how InventoryFlo structures that.
Then decide which locations exist. Keep it physical: a shop, a storeroom behind it, a van if it holds stock overnight, a warehouse. A location that is only a label ("online") is a reporting dimension, not a place; do not create it unless stock really sits there. Each location gets its own opening count; that count is your day-zero truth, and everything after is a movement.
Step 2: transfers recorded on both ends
A transfer is an outbound from one location and an inbound at the other, with the stock in between visible as "in transit" if the trip takes more than a few hours. The person sending records what left; the person receiving confirms what arrived. The difference, if any, is written down on the day, not discovered at the next count. The transfers and locations article describes the flow in the app.
Two rules keep this honest. Only named people may transfer (the manager at each site, not everyone with the app), and nothing moves without a transfer, including the "I'll just grab two boxes" at closing time. The second rule is the hard one; it is also the one that makes every other number true.
Step 3: counts per site, on a rhythm each site can keep
Each location counts its own stock, on its own schedule, with its own list in shelf order. A small shop may count everything weekly in 30 minutes; the warehouse may cycle-count a section a day. What matters is that each count is per location, dated, and compared with the previous one, so variance is attributed to a place and a period. The count flow on a phone is described in scan, count, receive.
Compare variance across sites monthly. A site that is always short on the same items has a process problem (transfers not recorded, breakage not logged) before it has a theft problem; the numbers tell you where to go and look.
Step 4: reorder points per location, one buyer per supplier
Reorder points are per location, because usage is: the airport café runs through cups three times faster than the neighbourhood one. Set each site's reorder point from its own weekly usage and the supplier's lead time, and decide who buys. For most 2 to 5 site businesses, one person orders from each supplier for every location and ships internally, or each site orders its own fast-moving perishables and the central buyer handles the rest. Either works; mixing both without saying so is how two sites order the same pallet. The purchasing and suppliers article covers purchase orders per location.
On plans: InventoryFlo's Free plan is one location; Starter allows 2, Pro 5 and Business 15, as listed on the pricing page, so a second shop is the point where the plan changes. The multi-location inventory page shows the per-location views, transfers and counts together.
A worked example: two shops and a storeroom
A roastery café with a second shop across town and a storeroom behind the first. Catalogue: 180 SKUs, roasted coffee under one parent per origin with 250 g and 1 kg variants. Locations: Shop A, Shop B, Storeroom. Deliveries from importers land at the Storeroom; the manager transfers to each shop twice a week in the van; each shop counts on Sunday night, the Storeroom on Monday morning. Reorder points: cups and lids per shop from their own usage; green coffee at the Storeroom only. After a month the owner can say, per shop, what was used, what was transferred in, what was counted, and where the 4 kg went. That last sentence is what multi-location inventory management is for.
Frequently asked questions
Should each location have its own item list?
No. One catalogue, shared by all locations, with stock quantities per location. Separate lists drift (different names, units and costs for the same thing) and totals become impossible. If a site never stocks an item, its quantity there is simply zero.
How do I handle stock in the van between shops?
Record a transfer when the stock leaves and confirm it when it arrives; in between it is in transit. If the van holds stock overnight regularly, make the van a location. Never move stock without a transfer, however small.
How often should each location count?
Small shops: everything weekly, same time, in shelf order. Warehouses or storerooms: cycle counts, a section a day. What matters is that counts are per location, dated, and compared with the previous count so variance can be attributed to a place and a period.
Who should place supplier orders with several locations?
Decide per supplier: either one central buyer orders for all sites and ships internally, or each site orders its own fast-moving perishables and the centre handles the rest. Write it down; mixed rules are how two sites order the same pallet.
How many locations does InventoryFlo allow?
1 on Free, 2 on Starter, 5 on Pro, 15 on Business, as listed on the pricing page. Transfers, per-location counts and per-location reorder points are available as soon as a plan has more than one location.
Sources: InventoryFlo — pricing and plan limits · ASCM / APICS — supply chain and inventory management body of knowledge (cycle counting, reorder points)