On a Monday morning, an owner of eight clothing stores sat down with three reports: the stores’ end-of-day sales, the website’s inventory file, and the buying team’s stock sheet. The three documents disagreed on more than 600 items. One said they had 26 units of a popular jacket; the website said 14; the main store said the jacket had been discontinued in March. The buying team had already reordered 40 more.
When the stock count and the customer’s reality collide
The breaking point came during an online promotion. The website confirmed an order for a denim jacket that, according to the system, existed in Store 5. It didn’t. The store manager later discovered that the only sample jacket had been sold weeks earlier and nobody marked it. Customer service spent two days calling stores, refunding orders, and handing out apology vouchers.
This chain had 4,000 SKUs, so the problem wasn’t the size of the business. The problem was that every location treated its records as private. The stores updated their books at different times, the web warehouse reserved items that were never set aside, and display samples were still legally “available” for sale online.
The rules that fixed the mess — without adding headcount
ERPNext Consulting walked through one full day at each type of location before making a single recommendation. Then they set three operating rules:
- Online orders can only be filled from the central stock pool. Store shelves are not part of the website’s inventory, ever.
- Every display sample must be counted in a “not for sale” status. A sample on the shop floor is no longer sellable stock, full stop.
- Store teams count their 60 best-selling items every morning during the opening routine. The full count happens quarterly, not monthly.
These look like common sense, but they require a system that can separate stock pools without demanding that staff become IT experts. The ERPNext Consulting configuration created separate counting areas for the online warehouse and each physical store, so the owner could see at a glance which channel was eating the margin.
The result: a shorter count and a calmer team
Monthly reconciliation time across all eight stores dropped from three full days to roughly six hours. Failed online orders fell from 9% of orders to under 2% in two months, and the customer service team stopped dreading Monday mornings. The hardest part was not the technology — it was convincing store managers that logging a sample as “not for sale” wouldn’t be treated as a theft accusation.
If you run multiple stores plus a website, do one thing this week: check how many display units are still marked as sellable. Those free “virtual” units are the ones that quietly destroy your online reputation. ERPNext Consulting calls them the hidden out-of-stocks, and every retailer has a drawer full of them.