Dead stock in e-commerce: how to find products that freeze cash?

What is dead stock?

In an online store, dead stock means products that do not move for a long time or move too slowly compared with available stock. These can be poor purchasing decisions, end-of-line items, seasonal products after the season or size and color variants that never found demand.

The issue is bigger than warehouse space. Every unit of slow-moving inventory is cash that cannot be used for better stock, campaigns, site improvements or faster deliveries.

What data helps identify slow-moving products?

Key inventory and turnover metrics

Dead stock is best detected by combining several metrics. Stock quantity alone is not enough: 100 units of a bestseller may be healthy stock, while 10 units of an expensive product with no sales may freeze meaningful cash.

You do not need every metric at the start. If you only have a CSV with stock, sales, revenue and cost, begin with sell-through, days without sales and inventory value.

30, 60 and 90 day thresholds

Many stores benefit from simple aging labels. Thresholds should fit the vertical, but 30/60/90 days is a useful starting point.

Do not use these thresholds mechanically. In seasonal fashion, 90 days may be too late, while expensive electronics or specialist products can have naturally slower cycles.

A simple way to classify products

Start by dividing the catalog into a few groups. The model does not have to be complex. Combine stock level, sales, views, margin and category.

Decision matrix: visibility, price and stock

The most common mistake is treating every slow-moving product the same way. Better decisions start by separating three questions: is there demand, is there visibility and does the product make economic sense?

Not every slow-moving product needs a discount

A discount is the simplest reaction, but not always the best one. If a product has many views, the problem may be price, image, description, missing variant, shipping cost or low trust in the offer. If a product has almost no views, a discount may change little because customers do not see it.

First decide whether the problem is demand, visibility, pricing, offer quality or seasonality. Then choose the action.

What can you do with dead stock?

• Improve visibility: when the product has margin and potential but low exposure.
• Improve the product page: when it receives traffic but does not convert.
• Create a bundle: when it fits bestsellers or complementary products.
• Run a controlled discount: when you need to release cash without destroying category margin.
• Limit reorders: when rotation is weak and there is no clear improvement plan.
• Move it into a seasonal campaign: when the issue is timing, not product quality.

How to prevent dead stock

The cheapest actions start before buying inventory. Dead stock often comes from optimistic purchase orders, weak variant control, promotions without a stock plan or reordering products that performed well only briefly.

• Compare planned orders with real sales velocity, not only buyer intuition.
• Separate true bestsellers from products that spiked once because of a campaign or discount.
• Analyze variants separately, because one color or size may sell well while another stalls.
• Set a minimum review rhythm, for example weekly for seasonal categories.
• Do not reorder only because revenue is high if margin and turnover are weak.
• For new products, start with smaller quantities and measure conversion before larger orders.

Example: analyzing one product

Assume a product has 80 units in stock, sold 4 units in the analyzed period, received 900 views and has low margin. Stock quantity alone tells you little. The combined data shows the problem: at the current sales velocity, stock may last a long time, while high views suggest the product is visible but not persuasive.

In that situation, the first step does not have to be a large discount. Check competitor price, images, variants, shipping cost and reviews. If conversion does not improve after corrections, then the product can move into clearance, a bundle or an outlet channel.

How to measure whether actions worked

After every change, monitor whether the product actually started moving. A discount is not a success if sales increased but margin collapsed too much.

• lower stock quantity,
• higher product conversion,
• higher gross profit or acceptable clearance cost,
• lower share of slow-moving inventory in the category,
• shorter time since last sale,
• no repeat reorders for products with no movement.

How to start from a CSV export

The simplest dead stock report can be prepared from a CSV file with SKU, product name, category, stock level, units sold, revenue, cost, views and last sale date. If you do not have every field, start with what is available.

Combining sales, stock, margin and conversion helps show which products freeze cash, which products need improvement and which products deserve more visibility instead of immediate discounting.

Dead stock report data checklist

• SKU or product ID is the same in sales, inventory and cost exports.
• Variants have separate rows when they have separate stock.
• Sales and stock are analyzed for the same point in time or period.
• Cost of goods lets you calculate inventory value and margin.
• Last sale date or sales from the last 30/60/90 days are available.
• Seasonal products are marked by category, tag or season date.
• The CSV file uses UTF-8 and keeps product names readable.