Two sisters ran a seven-store clothing retail chain and still argued about stock levels every Monday morning. One sister would say, “We have 40 of those jackets in the warehouse.” The other would respond, “No, we sold 30 last weekend, so we have ten.”
Both were wrong. The truth was somewhere in the back of a store room.
The Monday Morning Truth Test
They had a point-of-sale system, but it only tracked sales, not the stock on shelves. Nobody counted what was actually in each store. Transferring stock between stores was done by group chat messages and hope.
ERPNext Consulting started with one question: what is the minimum information you need to run this chain without constantly being wrong? The answer was basic, but it changed everything. Every store needed a live count that matched what the shelves said.
Keeping Stock Honest in 7 Different Locations
- Start with a full count at every store on the same weekend, so all seven databases begin from the same reality
- Set a fixed schedule, one store per week does a partial count of its top 50 selling items
- Treat any mismatch above 2 percent as a bigger investigation, not just a quick fix
The sisters were skeptical about the counting discipline. Their old habit was to count the best sellers only when things felt wrong. The change was committing to the schedule even when sales were busy. It felt like slowing down, but it actually sped everything up.
Transfers That Used to Take Days
The real payoff came from inter-store transfers. A jacket that sat unsold in the downtown store for three weeks sold out in one weekend at the airport location. The system showed the difference instantly, so the transfer became a routine decision instead of a neighborhood drama.
After four months, the chain’s stock turnover went from 3.1 turns a year to 4.4 turns, and the Monday morning arguments disappeared because both sisters looked at the same screen. The lesson I pass along from this one: a retailer’s worst enemy is not low stock, it is stock in the wrong place. ERPNext Consulting gave them one version of the truth, and that alone was worth the effort.