How do I identify dead stock?

A common method is to flag SKUs with no sales in the last 90 days, then review current on-hand units and unit cost to calculate the value trapped in those products.

What is the dead stock formula?

There is no single universal formula. A practical approach is: Dead Stock Value = On-Hand Units × Unit Cost for SKUs that meet your no-sales aging threshold.

What is the difference between dead stock and slow-moving inventory?

Slow-moving inventory still sells, just more slowly than target. Dead stock typically refers to products with no meaningful sales activity over a defined period.

What threshold should I use for dead stock?

Many merchants start with 90 days without sales, but the right threshold depends on category, seasonality, and product lifecycle.

How do I calculate dead stock in Shopify?

Pull last sale date, current inventory, and unit cost by SKU, then flag items with no sales beyond your threshold and multiply remaining units by unit cost.

Dead Stock Calculator for Shopify Brands

Q: What is dead stock?

Dead stock is inventory that has not sold within a defined period and is unlikely to sell at full price without intervention such as markdowns, bundling, or liquidation.

Definition: Dead stock is inventory that has not sold within a defined threshold period and is unlikely to sell at full price without intervention.

Dead stock is one of the clearest signs of inventory inefficiency because it ties up cash without generating sales. The goal is not just to flag products with zero recent sales, but to quantify their value, identify which SKUs are slowing down, and decide whether to markdown, bundle, liquidate, or stop reordering them.

Dead Stock Calculator formulas

Dead stock units

Use when: Use when you want a simple operational definition of dead stock based on no recent sales.

Dead Stock Units = On-Hand Units for SKUs with No Sales in Threshold Period

Dead Stock Units = On-hand units for products with zero sales during the threshold period

Symbol	Variable	Description
On Hand	Inventory on hand(units)	Current sellable units remaining for the flagged SKU.
Threshold	No-sales threshold period(days)	The number of days without sales used to classify a SKU as dead stock, often 60, 90, or 120 days.

Limitation: A zero-sales rule can misclassify highly seasonal or intentionally dormant products as dead stock.

Dead stock value

Use when: Use to quantify how much working capital is trapped in inventory that is not moving.

Dead Stock Value = On-Hand Units × Unit Cost

Dead Stock Value = On-hand units multiplied by unit cost

Symbol	Variable	Description
On Hand	Inventory on hand(units)	Units remaining for the SKU.
Unit Cost	Unit cost(currency / unit)	Your landed or purchase cost per unit.

Limitation: This shows cost value, not likely recovery value after markdowns or liquidation.

Dead stock rate

Use when: Use to track whether dead stock is becoming a material business problem over time.

Dead Stock Rate = Dead Stock Value / Total Inventory Value × 100

Dead Stock Rate = Dead Stock Value divided by Total Inventory Value multiplied by 100

Symbol	Variable	Description
Dead Value	Dead stock value(currency)	Total cost value of flagged dead stock SKUs.
Total Inventory	Total inventory value(currency)	Total cost value of all inventory on hand.

Limitation: A low dead stock rate can still hide a serious issue if the affected SKUs are strategically important or highly seasonal.

Step-by-step examples

Scenario: “A merchant flags any SKU with no sales in the last 90 days as dead stock. One SKU still has 180 units on hand at a cost of 12 per unit.”

No-sales threshold: 90 days

Units on hand: 180 units

Unit cost: 12 per unit

1SKU had zero sales in the last 90 days, so it is flagged as dead stock
2Dead stock value = 180 × 12
3Dead stock value = 2,160

2,160 of dead stock value

Interpretation: This SKU is trapping 2,160 in working capital and should be reviewed for markdown, bundling, liquidation, or discontinuation.

Scenario: “A Shopify brand has total inventory at cost of 240,000. Dead stock identified across all flagged SKUs totals 18,000 at cost.”

Dead stock value: 18,000

Total inventory value: 240,000

1Dead Stock Rate = 18,000 / 240,000 × 100
2Dead Stock Rate = 7.5%

Dead stock rate = 7.5%

Interpretation: A meaningful share of inventory is not moving. The next step is to segment by SKU age, margin, and seasonality to decide what to clear first.

Dead stock reference points

Category	Benchmark	Note
Slow-moving review threshold	30–60 days without sales	Useful early warning range for many SKUs.
Common dead stock threshold	90+ days without sales	Often used as the operational definition for ecommerce merchants.
High-risk dead stock rate	5%+ of inventory value	Worth active intervention, especially in seasonal categories.
Fashion / seasonal products	Shorter tolerance	Inventory can become obsolete faster than evergreen categories.
Evergreen replacement parts or long-tail catalog	Longer tolerance	Zero recent sales does not always mean true dead stock.

Dead stock thresholds should reflect category behavior, seasonality, and sales frequency. A fixed 90-day rule is useful, but not universally correct.

Critical pitfalls to avoid

Using one threshold for every SKU

A 90-day no-sales rule may work for fast-moving consumer products but can mislabel long-tail or seasonal items.

Fix: Set thresholds by category, product type, or seasonality pattern.

Ignoring unit cost

Counting dead stock only in units hides the financial impact. Ten unsold cheap units and ten unsold premium units are not the same problem.

Fix: Track both dead stock units and dead stock value at cost.

Confusing slow movers with dead stock

A product selling occasionally is not the same as a SKU with no realistic chance of selling without intervention.

Fix: Use an aging ladder such as 30, 60, 90, and 120+ days since last sale.

Not excluding intentionally held inventory

Spare parts, bundles, launch reserves, and channel-specific stock can appear dead even when they are strategically kept.

Fix: Tag special-purpose inventory separately before running dead stock analysis.

Measuring only once

Dead stock grows gradually. A one-time cleanup does not solve the structural problem if buying rules stay unchanged.

Fix: Review dead stock monthly and connect the output to markdown and reorder decisions.

Shopify-specific tips

Use Shopify product sales reports to find the last sale date per SKU, then compare it against your aging threshold.
Join last-sale data with current on-hand inventory and unit cost to estimate dead stock value.
For merchants using bundles or multi-location inventory, reconcile variant-level stock carefully before flagging dead stock.
Seasonal products should be reviewed against their normal season, not just trailing 90-day sales.
Dead stock analysis becomes much more actionable when combined with sell-through, turnover, and inventory aging views.

Dead Stock Calculator