Dead stock inventory: how to find it and clear it

Dead stock is inventory sitting on your shelves that has stopped selling, tying up your cash and your space while it gathers dust. Sneaker collectors use "deadstock" to mean a pair of Jordans that never touched pavement, and they will pay a premium for it, but a supply store's version works the other way around: the longer it sits, the less it is worth, and nobody is bidding on that discontinued faucet finish in the back room.

Every supply store has a museum. There is the paint line the manufacturer retired two years ago, the special order the customer never came back for, and the second pallet of a preseason buy that a dry spring cancelled. None of that is a character flaw, since dead stock is what happens when a deep assortment meets ordering by the case pack and by the season, so the cure is a routine rather than a resolution: define it, size it in dollars, confirm it is there, check who buys it, pick the cheapest exit, and change the buying habit that made it.

Slow-moving, dead, and obsolete inventory: know which pile you are looking at

The trade has no universal cutoff, but a sensible starting rule defines each bucket by days since the last sale. Slow-moving inventory is anything whose last sale was 91 to 180 days ago, or that sells far less than you stock of it. Dead stock is anything with no sale in 181 days or more, and once you pass a full year (or the item has never sold since it arrived) the debate is over. Obsolete inventory is a different animal, because it cannot sell as-is once something has replaced it, whether that is a new model, a retired color deck, a discontinued finish, a code change, new packaging, or your distributor dropping the item from its catalog.

The big caveat is seasonality, so judge a seasonal item against its season rather than the calendar. A snow shovel with no sale since March is not dead in August, and you should measure it against last winter instead. Lawn fertilizer, grass seed, ice melt, holiday lights, canning supplies, and bird seed all have a season, and an aging report that ignores that will have you marking down perfectly healthy stock every fall.

What dead stock costs you

The obvious cost is cash, because every dollar sitting in a dead SKU is a dollar that is not sitting in a fast one, and in a business where inventory is usually the biggest thing your cash is spent on, that pile is real money before you count anything else. It also drags down your inventory turns and GMROI, since it sits in the denominator of both while contributing nothing to the numerator.

Then there is space, since the back room and the top shelf are finite and every bay of dead product is a bay that cannot hold what turns. Shrink and damage pile on too, because the longer something sits, the more chances it has to get dented, faded, frozen, or walked out the door. And here is the insult on top of the injury: you keep paying for dead stock after it dies, because someone counts it at every inventory count, it sits in the value you insure, and somebody dusts it, or at least feels guilty about not dusting it. Dead stock stops selling long before it stops charging rent.

How to find dead stock

Start with a report that buckets your inventory by days since the last sale, with units and dollars at cost. Here is what that looks like at an illustrative hardware store.

Read it like this: the bottom two buckets, everything with no sale in six months or more, come to $58,000 plus $52,000, or $110,000 at cost. That is 17% of the store's inventory dollars spread across 3,200 SKUs, and it is the pile to work.

Where you start inside the pile matters as much as the pile itself. Sort the two oldest buckets by dollars at cost rather than by SKU count and work from the top, because a few hundred expensive lines tend to hold most of the money while the long tail is bins of fittings worth $40 all together. Clearing the top of the list frees cash, and clearing the bottom of it frees shelf space and not much else.

Before you mark anything down or send anything back, run two checks.

Confirm the stock is there

An item showing no sales and 12 on hand might have zero on the shelf, because it was stolen, damaged, or sold under the wrong SKU at the counter. Count the dead list before you act on it, and if your counts are unreliable across the board, that is a counting problem with its own fix, which our guide to cycle counting walks through.

Check who buys it

An item with one big buyer is not dead, it is a special-order relationship wearing a disguise. In our piece on breaking sales out by customer before you discount, one account had bought 151 of the 199 units a year of an item that looked like eighteen months of supply, and a blanket discount would have handed a markdown to a customer who was already paying full price. While you are at it, make sure the item is not a seasonal line sitting out of season.

Clearing dead stock at a supply store

Work the exits roughly in order of what they cost you.

• Return to vendor. Many vendors and distributors run return or stock-adjustment programs, sometimes limited to certain windows, sometimes with restocking fees, and sometimes requiring the item to still be current in their catalog. Check your vendor's current program and deadlines before anything else, because getting your cost back beats any markdown you will ever run, and since discontinued items tend to have the shortest windows, send those first.
• Transfer between locations. If you run more than one store, move the item to the store that sells it, because dead in one town can be perfectly healthy in the next one over.
• Re-merchandise. Move it from the top shelf to eye level, an endcap, or near the register. An item nobody can find is not dead so much as lost, and some of what shows up on the aging report is stock your own staff forgot you carried.
• Bundle it. Pair a slow item with a fast one in a project kit, such as the slow caulk colors with a paint project, the slow sprinkler head with hose and fittings, or spare fittings with a water heater install, so the fast mover carries the slow one out the door.
• Offer it to contractors. Offer the lot to a pro account at a price close to cost, since the painter who runs that primer or the plumber who still installs that valve will take quantity off your hands, and tell your counter staff which items to suggest to the contractors who would use them. You recover most of your money and do a good account a favor at the same time.
• Run a clearance ladder. Set a planned markdown schedule, for example 25% off for 30 days, then 50% off for 30 days, then the clearance bin, so price drops are a policy rather than a mood, and keep clearance in one clearly marked spot so regulars learn to check it.
• Sell to liquidators or other retailers. If nothing above works, sell the lot for cents on the dollar, which costs you on paper but gets you the space back, and space has value too.
• Donate it. Local Habitat for Humanity ReStores and similar nonprofits accept building materials, so ask your accountant how to record the donation on your books.
• Write it off. When it cannot be sold or returned, get it off the books and off the shelf with your accountant's guidance, so it stops distorting your inventory value and your counts. The dumpster is a last resort, but it is still a resort.

Preventing the next batch of dead stock

Clearing dead stock treats the symptom, and a handful of buying habits treat the cause.

Take a deposit and set a pickup deadline on every special order, so an unclaimed one is a known exception you follow up on rather than shelf clutter you discover in three years. Buy slow items in the smallest pack your vendor will ship, even at a slightly higher unit cost, because paying a little more per piece beats owning a case of pieces forever. On preseason and early-order buys, commit to the quantity last season's sales support rather than the one the discount rewards, and decide what you will do with leftovers before you book the order.

Give every new item a 90-day review, so an item that has not sold by then gets a decision instead of an audition for the museum, and watch discontinuation notices from your distributor so you stop reordering items on their way out. Keep your min and max levels current, because a reorder point set for last year's demand keeps ordering stock nobody buys, and our piece on the reorder point and safety stock formula walks through setting them. Finally, run the aging report on a monthly schedule rather than once a year, because catching a slow mover at day 100 costs a fraction of what it takes to clear a dead one at day 400.

How Rundoo handles it

Rundoo's custom reports include an Inventory dataset with fields like last sale date, annual units sold, annual turns, and on-hand value, so you can build the report from this article (products with no sales in a date range, grouped by department or vendor), save it, rerun it every month, and download it as a CSV when you want it in a spreadsheet. When you switch to Rundoo, a product's last sale date can be imported from your old system, so the aging clock does not reset at go-live and your 300-day items do not arrive looking brand new.

Dooey, the AI on every screen, answers plain-language questions from your own numbers, like "Where is cash tied up in dead stock?" or "What is my inventory value by department?", and it can break an item's sales out by customer so you spot the one-buyer items before you discount them. It also flags slow movers before they go stale, which means the museum gets audited whether or not you remembered to walk it.

On the clearing side, a vendor return in Rundoo is a purchase order with negative quantities, which moves through the normal flow (ordered, received, vouchered) in reverse, reducing your inventory and recording the vendor credit, and with EDI or email ordering set up, the return details go to the vendor from the same screen. Transfers between locations are built in, and promotions let you discount by dollar or by percentage, across a whole department if you want, right where you check out a customer.