How to manage stock in more than one branch or warehouse
To manage stock across branches, give each location its own stock count, record every transfer as stock out of one and stock in at the other, and review all locations together before ordering.
What changes with a second location
With one shop you can see everything. With two, you cannot be in both places, and stock problems appear: one branch is out while the other has too much.
Core rules
Each location has its own count
Never keep one combined number. Track each shop or store separately, then add them up for the total.
Record every transfer
When goods move from the warehouse to a shop:
Record stock out from the warehouse.
Record stock in at the shop.
Have the receiving branch confirm the quantity.
An unconfirmed transfer is where stock vanishes.
Order centrally
Look at all locations together before placing a supplier order, so you do not buy more for one branch while another has surplus.
Same product names everywhere
Use the same names and variants across branches, or you cannot compare them.
Controls that work
A named person responsible for each location's stock
Weekly counts of fast sellers at each location
A written transfer slip, signed by sender and receiver
A monthly comparison of recorded and counted stock per branch
Warning signs
One branch repeatedly runs out while another sits on the same item
Transfers with no receiving record
Different prices for the same item with no reason
Tools
Spreadsheets get messy fast with several locations. Whatever software you choose, check that it can handle more than one location before you open a second branch. Our inventory tracking guide covers the basics that apply to each location.