MarCat

Dead stock in a supermarket: how to find it and what to do with it

Dead stock is money stuck on your shelf. How a supermarket finds lines that stopped selling, puts a rupee figure on them, and clears them within MRP rules.

By Swarbhanu Gupta, who has run Banjara supermarket in Ahmedabad since January 2025 (billing on MarCat since April 2026) · 13 November 2026

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

  1. Export your item list with stock. Every item where stock is above zero.
  2. Add the last sold date for each item.
  3. Add quantity sold in the last 90 days.
  4. Work out days of stock: stock on hand ÷ (quantity sold in 90 days ÷ 90). If nothing sold, the days of stock is "never".
  5. Add cost per unit, and multiply by stock on hand. This is the money locked in that line.
  6. 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:

  1. Move it. Put it at eye level or near the billing counter for two weeks. Sometimes the item was simply not seen.
  2. 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.
  3. Bundle it. Pair it with a fast seller: a slow tea with a popular biscuit.
  4. 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.
  5. 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.

Questions

What is dead stock in a supermarket?
Dead stock is an item that is in stock but has not sold for a long time. Each store sets its own cut-off. For packaged grocery, many owners use something like 60 to 90 days with no sale.
How do I find dead stock?
List every item with stock above zero, then add two columns: the date it last sold and the quantity sold in the last 90 days. Items with stock but no sale in that period are dead. Count them on the shelf before you act, because the stock figure itself may be wrong.
Can I sell dead stock below MRP?
Yes. The MRP printed on a pack is the maximum price, inclusive of all taxes. You may sell below it. You cannot sell above it.
Can I return dead stock to the distributor?
Often, if the distributor agrees. Under the GST law the supplier may issue a credit note when goods are returned. Ask about returns when you start buying from a distributor, not when the stock is already dead.
How do I stop dead stock from coming back?
Buy new items in small first quantities, think twice about schemes that need large orders, and stop reordering an item the moment it shows up on your dead stock list.