The warehouse manager of a 60-person industrial parts distributor called me at 3 a.m. because a customer’s maintenance crew was standing idle next to a machine that needed a $400 valve. Our record said 26 on the shelf. The shelf said zero. That call ended an $180,000-a-year contract.
Two weeks later I began an ERPNext Consulting review, and the owner told me something he thought was good news. He had run three full stock counts that year, and every one came back clean. Every one was wrong again within a month.
Counting your stock is not the same as knowing your stock
A full physical count is a photograph taken once a year. What you need is a video that runs every day. This distributor’s problem was never theft or damage — it was about forty small decisions a day that nobody wrote down.
A picker grabs 11 instead of 10 because the box was already open. A returned part goes back on the shelf before anyone checks whether it works. Multiply that across 12,000 product lines and a year, and the difference between the record and the shelf becomes a guessing game.
We measured it. On the ten fastest-moving parts, the gap drifted by 4 to 7 percent every 30 days. Across the whole warehouse, that worked out to roughly half a million dollars of inventory that existed only on paper.
Count less, count smarter, count on a schedule
Here is the counting routine the ERPNext Consulting team set up, and it took a warehouse supervisor about 40 minutes a day to run.
- Sort every item into three groups by how much money it moves each year. The top 300 get counted every four weeks, the next 1,500 every quarter, the rest once a year.
- When a picker’s count doesn’t match the record, stop the order and recount that one item on the spot. Twenty seconds, before the box leaves the building.
- Track one number every morning: how many open orders cannot ship complete today. Not the monthly fill rate. The raw list, every day, on one page.
- Give returns their own shelf and a 24-hour clock. Nothing goes back into sellable stock until someone inspects and scans it.
What the first 90 days looked like
The order of operations mattered more than any single fix. We did it in three stages, and the third stage is where the money showed up.
- Weeks 1–2: label and map every storage location, including the overflow racks behind the loading dock that had never appeared on a map.
- Weeks 3–6: run the three-tier count and log every mismatch with a reason — wrong pick, return, damage, receiving error.
- Weeks 7–12: review the reasons weekly and fix the biggest one. Ours was receiving errors at the dock, which fell 70 percent once that area got its own scanner and its own person.
Fill rate moved from 71 percent to 94 percent in three months. Emergency air freight, which had been running $9,000 a month, dropped below $1,200. The owner put it plainly: the counting was never the problem, the timing was.
Tonight, before you leave, walk out to the shelf and hand-count your ten most expensive items. If two or more are wrong, you have just found next quarter’s project.