With a single shop, stock can be managed with a notebook and the owner's memory. Once a second branch opens, or the shop starts selling through an online store and marketplaces as well, the numbers stop matching. The system says an item is in stock but the shelf is empty. A customer pays online, and it turns out the last unit was sold at the till an hour earlier.
Managing stock across multiple branches and channels is mostly about recording discipline. Software makes it easier, but the rules have to be clear first. Below is the approach retailers, distributors and F&B businesses commonly use to keep stock figures they can rely on.
One source of truth for multi-branch stock
The most common problem is that stock is recorded in several places. Branch A uses a spreadsheet, branch B uses a POS app, and the online admin updates marketplace stock by hand every afternoon. Each record may be correct on its own, yet none of them is complete.
The first step is to choose one system as the source of truth for stock. Every sale, whether from the till, the online store or a WhatsApp order keyed in by an admin, reduces stock in that system. Every delivery from a supplier is recorded there too. Other channels simply read their figures from the main system.
For this to work, product data has to be consistent across locations. One product gets one code or SKU, one name and one unit. If one branch records sugar in kilograms and another in sacks, combined reports will never add up. Clean up the product master before moving stock into a new system.
For online channels, consider a stock buffer. If you have 20 units, list 18 online and keep two in reserve to cover sync delays or a unit that turns out to be faulty at packing. Visible stock drops slightly, which is better than cancelling a customer's order.
Transfers between branches
Transfers are a frequent source of discrepancies because the goods move but the records do not. The warehouse sends five boxes, the receiving branch gets four, and nobody writes down the difference.
Treat a transfer as a transaction with two sides. The sending branch creates a transfer document listing the items and quantities, and its stock goes down when the goods leave. The receiving branch checks the physical goods and confirms the quantity that actually arrived. Any gap is recorded as a transfer discrepancy, so it can be investigated before anyone writes it off as lost.
This keeps goods in transit visible and gives every discrepancy a trail. Limit who can create and confirm transfers, too. A branch head or a designated warehouse staff member is usually enough. For distributors with regular deliveries, schedule transfers on fixed days so the warehouse is not constantly handling last-minute requests.
Regular stock counts
However good the system, physical stock and recorded stock drift apart over time. Items get damaged, miscounted, scanned under the wrong code or lost. A stock count, which Indonesian businesses call stock opname, corrects that drift before it grows.
Many businesses count everything once a year before closing the books. By then the discrepancies have piled up and their causes are hard to trace. A lighter approach is cycle counting, where you count part of the inventory on a rotating basis. Fast-moving or high-value items are counted weekly, everything else monthly.
A practical routine for each branch:
- Set a schedule and the list of items to count, and tell the branch staff in advance.
- Pause transactions for those items during the count, or count outside opening hours.
- Have two people count, ideally one from the branch and one from outside it.
- Compare the count with the system figure and note each discrepancy with its likely cause.
- Get a supervisor's approval before adjusting stock in the system.
- Review discrepancy patterns monthly. Repeated gaps on the same items or at the same branch usually point to a process problem.
Setting reorder points
Too much stock ties up cash. Too little sends customers elsewhere. A reorder point tells you when to place the next order with a supplier.
The basic formula is simple. Multiply average daily sales by the supplier's lead time, then add safety stock. Say a baking supplies shop sells an average of 8 sacks of flour a day, the supplier takes 3 days to deliver, and the owner wants a buffer of 10 sacks. The reorder point is 8 times 3 plus 10, which is 34 sacks. When stock reaches that level, a new order goes out.
Calculate reorder points per branch, because sales patterns can differ a lot by location. A branch near a university may be busy at the start of each semester, while one in a residential area is steadier. Review the figures every few months, especially ahead of Ramadan, Lebaran and the year-end holidays, when demand shifts.
Bringing online and in-store stock together
If you sell through a POS and an online store at the same time, running both from one system removes a lot of manual syncing. Etalasse combines an online store and a POS cashier app, so products, stock, customers and orders stay in sync across every sales channel, with a back-office dashboard for suppliers and stock-in. You can find out more on the Etalasse page.
