How to control stock across three outlets without losing your mind

Phantom stock is a location problem

When your system says 60 pieces and the Mirpur shelf has 4, nothing was necessarily stolen. The other 56 are in the warehouse, and the number on screen was never location-specific in the first place.

This is the moment most businesses buy a second spreadsheet instead of fixing the model. The spreadsheet then disagrees with the first one within a week.

Give every pile of goods a name

Before any software helps, write down the places stock physically sits. Be honest and specific-the back room counts, the display floor counts, and the godown two streets away definitely counts.

• Warehouse or godown where bulk deliveries land
• Each retail outlet, as its own location
• Any shelf or back room you would count separately during a stocktake
• Goods in transit between two of the above

Tie each register to the stock it sells

This is the single change that stops most overselling. A counter should sell from its own outlet's quantity, not from the company total. In Workcel, each POS station is bound to a stock location, so a sale in Uttara draws down Uttara.

Without this, your best-selling item will be sold twice on a busy Friday-once at the counter and once online-because both were reading the same optimistic total.

Make movements documents, not edits

Every change in quantity should have a reason attached to it. Goods came in on a receipt. Goods went out on a sale or delivery. Goods moved on a transfer. Goods were corrected by a count.

The value shows up three months later when a number looks wrong and you can actually trace how it got that way. If quantity can be typed over directly, you lose that permanently.

• Receipt - stock arriving from a supplier, into a specific location
• Delivery or POS sale - stock leaving against a customer
• Transfer - stock moving between two of your own locations
• Count - a physical recount that corrects the record on purpose

Count in slices, not once a year

The annual stocktake where everyone stays until midnight is the worst version of this job. It is slow, it is inaccurate because people are tired, and it only tells you the truth one day out of 365.

Count a category at a time on a quiet morning. Apply the count so the record is corrected properly, and keep that correction as a permissioned action so adjustments stay with the people you trust.

Watch the gap, not the number

Once counts are regular, the useful metric is not how much stock you have. It is how far the record drifted from reality since the last count, and in which location.

A single outlet with a consistently large gap is telling you something specific-a process problem, a training problem, or occasionally a people problem. A number that is always right everywhere except one shelf is a much easier conversation than a vague suspicion.