Dead Stock Management on Shopify: How to Find, Clear and Prevent It
Dead stock is inventory that has stopped selling and is unlikely to start again at its current price. It ties up cash, takes up space and gets harder to clear the longer it sits. This guide covers how to find it, what it costs to hold, how to clear it and how to stop buying more of it.
What is dead stock?
Dead stock (also called dead inventory or obsolete stock) is stock with no meaningful sales over a defined window and no good reason to expect that to change. The window is your call. As an illustration, you might start with 90 to 180 days, but a product that normally sells a few units a quarter needs a longer window than one that sells daily.
It helps to separate three situations, because each needs a different response:
| Situation | What it looks like | Usual response |
|---|---|---|
| Slow-moving stock | Still sells, but slowly | Watch it, promote lightly, order less next time |
| Excess stock | Sells at a steady rate, but you hold far more than that rate can absorb soon | Promote, discount moderately, cut future orders |
| Dead stock | No sales in your window, with no clear reason to expect any | Clear it, write it down, learn from the buy |
Excess stock turns into dead stock if the trend keeps declining and nobody acts. Catching it at the excess stage preserves more value.
What dead stock costs to hold
The purchase price is only the start. Every month the units sit, you also pay (or give up) the following:
- Storage: shelf or pallet space, or fees from a warehouse or fulfillment provider.
- Insurance and handling: premiums tied to stock value, plus the labor of counting and moving it.
- Cost of capital: cash that could have bought stock that sells, or paid down debt.
- Loss of value: products that go out of style, expire or get superseded are worth less each month.
Use dollars per year for every term, and value the inventory at cost, not retail price. The inventory carrying cost formula breaks each component down further.
Hypothetical example. You hold $10,000 (at cost) of dead stock. Assume storage of $1,200 a year, insurance of $100 and handling of $300. Assume your cost of capital is 10%, so tied-up cash costs $10,000 × 0.10 = $1,000. Assume the stock loses 20% of its value over the year, which is $2,000.
Total: $1,200 + $100 + $300 + $1,000 + $2,000 = $4,600, or 46% of cost. Every input is an assumption. Replace them with your own numbers.
How to identify dead stock
1. List every SKU by last sale date
Export your orders and your current inventory to CSV, then match them by SKU or variant. Sort by the date each item last sold. Anything past your window with units on hand is a candidate. Last-sold date is more reliable than stock age when you restock the same SKU repeatedly, because the age of the oldest units is hard to know.
2. Check inventory age where you can
If you record receiving dates on purchase orders, compare the age of what is on the shelf against how fast the item normally sells. Old and slow is the combination to flag. Aged stock that is still selling steadily is a different case.
3. Compare traffic with sales
A product with page views and add-to-carts but no sales may have a price, trust or listing problem, which is fixable. A product with no sales and almost no traffic has a demand or visibility problem. Test visibility first by featuring it in email or on your homepage. If it still draws no interest, that is a stronger sign the stock is truly dead.
4. Rule out seasonality
Holiday items in March are waiting for their season, not dead. Compare the item's sales against the same weeks last year before you label it. If it also failed to sell during last year's season, treat it as dead. See seasonal inventory planning for how to read seasonal patterns.
Measure your exposure
For example, $6,000 of dead stock in a $40,000 inventory gives 6,000 ÷ 40,000 × 100 = 15%. There is no universal "good" figure. Track yours monthly and watch the direction. A rising ratio means a growing share of your inventory value is sitting in stock that is not selling.
To catch excess stock earlier, compare days of supply with the coverage you actually need:
Hypothetical example. You hold 600 units and sell 2 a day, so days of supply = 600 ÷ 2 = 300 days. Lead time is 21 days, you order every 14 days and you want 5 safety days, so target coverage = 21 + 14 + 5 = 40 days. Units needed to cover that = 40 × 2 = 80, so the excess is 600 − 80 = 520 units. At a unit cost of $12, that is 520 × $12 = $6,240 sitting in excess.
Sell-through rate gives a launch-level view: units sold ÷ units received × 100. If you received 400 units and sold 300 in the first 60 days, sell-through is 75%. A low figure early in a product's life is a warning to stop reordering. See the inventory KPIs guide for how these metrics fit together.
How to clear dead stock
Set a floor price before you start. Compare any discount with the cost of continuing to hold the item. Selling a unit near cost may beat paying another year of storage, capital and value loss. But discounting an item that still sells at full price gives up margin you did not need to give up.
Hypothetical markdown math. A unit costs $30 and sells for $60, so you earn $30 a unit. Discounted to $35, you earn $5, which is $25 less per unit, an 83% drop in margin per unit. The discount can still be the right call, but make it a deliberate one.
Options to work through, roughly from least to most costly to you:
- Promote at full price first. Feature the item in email and on social channels. Some stock is only stuck because few people have seen it.
- Bundle with a best seller. Pair a dead item with something that sells and offer a small discount on the pair.
- Use it as a free gift. Offer it as a choice above a spend threshold. You write off the item's cost but may lift order value.
- Run a clearance collection. Group the items, state that they will not be restocked and set an end date.
- Ask the supplier. Some suppliers accept returns, exchanges or credit toward a future order, so it is worth asking.
- Sell other places. A different marketplace or a wholesale buyer may reach people your store does not.
- Sell in bulk to a liquidator. You may recover only part of the cost, since the buyer sets the price, but you get cash and space back sooner.
- Donate. Donating can have tax benefits depending on where you are. Confirm the treatment with your accountant first.
A simple ladder works well: allow a set period at each step, say four weeks, and move down the list when an item has not cleared. Whatever remains at the bottom gets written down in your books so your inventory value reflects reality. Ask your accountant how to treat the write-down. Once units are donated, discarded or sold off, remove them from your counts so they are no longer recorded as sellable stock. The inventory shrinkage guide covers recording stock adjustments with a reason code.
How to prevent it
Clearing stock is damage control. The cheapest place to prevent dead stock is the purchase decision.
Know why you over-order
- Fear of stockouts: a missed sale feels worse than extra units, so buffers creep up on every SKU.
- Recency bias: one strong month triggers a large reorder even if it was a one-off.
- Minimum order quantities: a supplier minimum forces you to buy more than the item justifies. Price the leftover units into the decision before you accept it.
- Lead-time mistakes: covering demand over the wrong period leads to systematic over- or under-buying.
- Ignoring lifecycle: a product in decline needs the opposite stocking policy from one that is growing.
Read the trend, not the total
A month with 200 units sold looks like a reason to reorder 200. But if weekly sales were 80, 60, 40 and 20, the total hides a steep decline. The right quantity depends on where weekly sales are heading, not where they have been. Tracking sales velocity over a rolling window shows this early.
Buy from a forecast and a reorder point
Base quantities on expected demand over lead time rather than on feel. See demand forecasting, the reorder point formula and the safety stock formula. Safety stock that is too generous becomes excess stock.
Start small on new products
For an untested product, buy the smallest quantity that lets you learn something, then reorder on real sales. The per-unit price may be higher, but the downside is limited.
Give slow sellers the most attention
Low-revenue SKUs are a sensible place to look first for dead stock. ABC analysis ranks products by revenue contribution so you can review the bottom group more often and markdown earlier.
Set a trigger, then act on it
Pick a velocity or age threshold that matches your catalog, for example "no sale in 45 days" for a fast category. When an item crosses it, decide on a markdown, a bundle or a pause on reorders, rather than waiting for the next review.
Key takeaways
- Dead stock is defined by a window you choose, based on how fast the product normally sells.
- Holding cost includes storage, insurance, handling, cost of capital and loss in value, not just the purchase price.
- Find it with last-sold dates, traffic data and a seasonality check, then track the dead stock ratio monthly.
- Set a floor price, work down a ladder of options and write down what remains.
- Prevent it at purchase time: read trends, respect lead time, start small and watch your low-revenue SKUs.
Related reading: inventory turnover ratio shows how quickly stock converts to sales overall.