Seven years. That’s how long a box of oversized rubber gaskets had been sitting on the top shelf of a safety-equipment distributor I once worked with. The company was doing around 12 million in annual revenue, but its warehouse held an estimated 340 thousand dollars in inventory that had not moved in eighteen months.
The owner knew the stock was there. He’d walk past it every day on the way to his office. But nobody had ever taken the time to sort the slow movers from the dead inventory, and every season the purchasing team reordered the same fast-moving items while the warehouse filled up with the same slow-moving ones.
When the team partnered with ERPNext Consulting, the first task wasn’t installing anything. It was getting a customer sales history report that ranked every single product by the last time it was sold.
Why “just sell it cheaper” is the wrong first move
Most managers look at dead stock and immediately think of discounting. That’s backwards. Discounting the slowest items first just burns margin on products that nobody wants even at a lower price. The right order is to classify first, then decide.
- Items with no sales in 24 months: write them off, donate what you can, and list the salvageable material for scrap. The tax deduction comes from dealing with them, not from storing them.
- Items with a few sales but clear quarterly demand: move them to a smaller “slow lane” area, cut their order quantity by half, and reorder only after an actual order comes in.
- Items that sell steadily but always run short: set a simple reorder point equal to 45 days of average demand, so you stop running out of the products that actually pay the rent.
It sounds simple, but the discipline of actually applying it matters more than the classification itself. In one quarter, the distributor cut its dead inventory from 340 thousand to 95 thousand, and freed up enough warehouse space to rent out one bay to a neighboring company. ERPNext Consulting was the catalyst, but the owner’s willingness to accept that some purchases were a mistake, and to stop repeating them, was the real engine.
The habit that keeps the shelves honest
The real lesson was in the routine that came after the cleanup. A monthly report that lists every item with no movement in the past six months, reviewed for ten minutes by the owner and the purchasing manager, became the standard meeting. They agreed on a hard rule: no reorder on any item that has no recorded sale in the prior 90 days, no matter how cheap or how “obviously useful” the supplier claims it is.
If you have shelves full of quiet stock, set yourself a two-hour task: run a sales-by-item report covering the last 18 months, and ask every item that sold fewer than three times why it’s still there. You will find that most of those items are haunting the warehouse because somebody once ordered them “just in case”. Cut that habit first, and the space you’ll recover will pay for the whole exercise.