Every supermarket has a few shelves where nothing moves. A jam in a flavour nobody asked for. A shampoo size that never caught on. A festival item from last year. Each one is small. Together they are money you paid to a distributor that is now sitting on your shelf, taking space that a fast seller could use.
Dead stock is easy to miss without a report. Stock and inventory management software can show which lines have stopped moving.
This guide explains how to find dead stock in a supermarket, how to put a rupee figure on it, and what to do with each line. All the numbers are made up.
What counts as dead stock
Dead stock is an item that is in stock but has not sold for a long time. Slow stock still sells, just so slowly that what you hold will last for months.
There is no fixed rule for the cut-off. For packaged grocery, many owners use something like this:
| Label | Simple test |
|---|---|
| Dead | Stock above zero, no sale in the last 90 days |
| Slow | Sells, but stock on hand will last more than 90 days at the current pace |
| Healthy | Everything else |
Pick your own numbers and keep them the same every month, so the list is comparable.
How to find it, step by step
- Export your item list with stock. Every item where stock is above zero.
- Add the last sold date for each item.
- Add quantity sold in the last 90 days.
- Work out days of stock: stock on hand ÷ (quantity sold in 90 days ÷ 90). If nothing sold, the days of stock is "never".
- Add cost per unit, and multiply by stock on hand. This is the money locked in that line.
- Sort by money locked, largest first. Start at the top.
A made-up example:
| Item | Stock | Sold in 90 days | Last sold | Days of stock | Cost per unit | Money locked |
|---|---|---|---|---|---|---|
| Jam 500 g, mixed fruit | 18 | 0 | 5 months ago | never | ₹95 | ₹1,710 |
| Shampoo 650 ml | 9 | 1 | 2 months ago | 810 | ₹310 | ₹2,790 |
| Hair oil 100 ml | 40 | 30 | yesterday | 120 | ₹45 | ₹1,800 |
| Atta 5 kg | 25 | 300 | today | 8 | ₹210 | ₹5,250 |
The jam is dead. The shampoo is slow and has the most money stuck in it. The hair oil is slow because too much was bought. The atta is fine, even though it has the most money in it.
Check the shelf before you act
Before you do anything with a "dead" line, count it on the shelf and in the store room. In many stores a part of the dead stock list is not real:
- Duplicate items. The same product entered twice in the item list. Sales go to one entry, and the other shows stock that never moves.
- Billed under the wrong item. The cashier rang it up as a similar item, so the real line never shows a sale.
- Stock that was never there. A purchase entered twice, or a damaged pack thrown away without being written off.
Fix these in the item list first. What is left is real dead stock.
Why stock goes dead
Knowing the reason tells you whether it will happen again:
- A big first order of a new item, before you knew if it would sell.
- A scheme that needed a large quantity to get the extra discount.
- Leftovers after an MRP change, sitting behind the new packs.
- Seasonal items that missed their season.
- Wrong place on the shelf, too high, too low or behind something else.
What to do with each line
Go down the list, largest money first, and decide one of these:
- Move it. Put it at eye level or near the billing counter for two weeks. Sometimes the item was simply not seen.
- Return it or exchange it. Ask the distributor. Under GST, a supplier may issue a credit note when goods are returned, but returns are their decision, not your right, so ask about return terms when you start buying.
- Bundle it. Pair it with a fast seller: a slow tea with a popular biscuit.
- Sell it below MRP. The MRP is the maximum price, including all taxes. Selling below it is allowed. Selling above it is not. Check that a lower price still beats the cost of holding it.
- Stop reordering it. Mark it so nobody orders it again by habit. Clear what is left and do not refill the gap.
For items with an expiry date, decide early. A markdown two months before expiry works far better than one two weeks before.
From our counter
We have run Banjara, our own supermarket in Ahmedabad, since January 2025. A few opinions from running one:
- Dead stock is a buying problem that shows up on the shelf. Most of it was decided at the moment of ordering, not at the moment of selling.
- A good scheme on the wrong item is a bad deal. An extra discount on stock that sits for six months is not a discount.
- Look every month, not every year. A monthly list is short and easy to act on. A yearly list is long and depressing, and by then the dates have run out.
- The item list hides more dead stock than the shelf does. Clean duplicates first, and the real problem gets smaller.
Where software helps
The steps above need the last sold date and sales in a period for every item. In a store with thousands of items, nobody can work that out by hand each month. Software that already moves stock on every sale and every purchase can show you which lines stopped moving, so the monthly list takes minutes, and the decisions stay with you.
How MarCat handles it
We have run Banjara, our own supermarket in Ahmedabad, since January 2025, and it has billed on MarCat since April 2026. This is what MarCat does here:
- Dead stock in view. Stock movement reports surface lines that stopped moving.
- Stock that is up to date. Every sale and every purchase moves stock automatically, with batch, MRP and cost tracking.
- Reorder suggestions based on what has actually sold.
- Purchase and margin reports, to see what each line cost you and what it earned.
If you want to see a stock movement report on your own items, message us on WhatsApp at +91 96787 65518.
