How to reduce excess inventory and dead stock in retail

By Elie Dufeu, CTO & Co-Founder, Metreecs. Published 16 October 2026.

To reduce excess inventory and dead stock in retail, work in this order: stop the inflow of stock you do not need, move the stock you already have to the stores and channels where it can still sell, and only then discount what is left in planned steps. Discounting first is the most common mistake, because it clears shelves while the buying and allocation habits that filled them stay the same.

Marta buys for a sporting goods retailer with 25 stores. In September she found that a line of trail running shoes had 14 months of cover in the stockroom, even though the same shoes had sold out in two city stores in July. The original order had been sized on the category forecast and split evenly across stores, so the shoes sat where demand was thin. (Marta is an illustrative example with round numbers, but most buyers have lived a version of it.)

If you recognize that picture, the fix starts with finding the stock, not discounting it. This guide covers how to define excess and dead stock, why they build up, how to measure them with weeks of cover, and how to sequence clearance so you protect margin. If you would rather see where your own excess sits, you can see a product-level view of your excess stock built from your sales history.

Key Takeaways

• IHL Group estimates that overstocks and out-of-stocks together cost global retail about $1.7 trillion in 2026, equal to 6.2% of retail sales.
• Retail Insight Network reports that retailers lengthened their purchasing lead times by an average of three months during 2025 because of tariff uncertainty, and longer lead times raise the risk of ordering too much.
• McKinsey found that early adopters of AI-enabled supply-chain management improved inventory levels by 35% and service levels by 65%.
• A product with 600 units on hand and a forecast of 12 units a week has 50 weeks of cover. If lead time plus review plus safety buffer needs 10 weeks, 480 units are excess.
• Three levers work in a fixed order: reduce inflow, rebalance across locations, then mark down in steps.

What is excess inventory and dead stock?

Excess inventory is stock above what forecast demand needs over the replenishment lead time plus the review period and a safety buffer. Dead stock is the extreme case: a product or variant with no sales over a set window, often six to twelve months, with no planned demand ahead. Slow movers sit between the two.

The three states call for different actions, so it helps to separate them before you decide anything.

StateHow to spot itTypical causeFirst actionExcessWeeks of cover well above target, still sellingBuy sized above forecast, or demand droppedCancel or defer open orders, rebalanceSlow moverLow sell-through for a full season, sales in a few locationsWrong location, wrong variant mixTransfer to stores that sell it, promoteDead stockNo sales for your set window, nothing plannedDiscontinued, mis-bought variant, missed trendClear in steps, then liquidate or write off

Pick the window for dead stock by category, not by habit. A winter coat that sat from March to September is seasonal stock, and a phone case for a discontinued model is dead after two months.

Why excess and dead stock build up

Excess stock is rarely a single mistake. It comes from a chain of reasonable decisions that each looked fine on their own. Retail Insight Network’s reporting on the IHL Group data names the usual drivers: long supplier lead times, inaccurate sales forecasts, and changing customer behavior all raise the risk that retailers order too much.

Four causes show up most often once you trace the stock back to its source.

• Buying at category level. A buy sized on a category total and then divided evenly across variants and stores guarantees that some variants overshoot. The category number can be right while every individual product is wrong.
• Minimum order quantities and pack sizes. A supplier’s minimum can force you to buy more than the forecast needs, and the leftover units are excess from day one. Treat the minimum as a known cost in the buying decision, not a surprise on the receipt.
• Even allocation across stores. Stock sent out in equal shares ignores that the same product sells at very different rates by location. The shoes sell out in one store and age in another, and the total looks healthy.
• Slow reaction to early sell-through. A weak first six weeks is the cheapest moment to act, because open orders can still be cut. Most retailers see the signal late, when the stock is already on the shelf.

Across Metreecs’ work with retailers in several verticals, the excess tends to sit in the variants behind the top sellers, such as the less popular sizes, finishes, or flavors, rather than in the core product. Those variants rarely get a forecast of their own, so nobody notices the buildup until a quarterly review.

One mistake we repeatedly see is treating the clearance sale as the fix. Clearance is the last step, and the buying and allocation rules that created the stock usually stay untouched, so the same pattern returns the following season. Our guide on how to prevent end-of-season markdowns covers the seasonal version of this problem in depth.

How to find excess and dead stock with weeks of cover

The most useful single number is weeks of cover: how many weeks the stock on hand and on order will last at the forecast sales rate.

Weeks of cover = (on hand + on order) ÷ forecast weekly demand

Compare it with the target cover for each product, which is the replenishment lead time plus the review period plus a safety buffer. Anything above target is excess, and the excess units are (weeks of cover minus target cover) times weekly demand.

Take a product that costs €18 a unit, with 600 units on hand, nothing on order, and a forecast of 12 units a week. Weeks of cover is 600 ÷ 12 = 50 weeks. If the supplier lead time is 6 weeks, you review weekly, and you hold 2 weeks of safety buffer, the target is about 10 weeks. The excess is (50 minus 10) × 12 = 480 units, which ties up €8,640 of cash.

Run the same calculation for every product and variant in every location, then work through the results in four steps.

1. Sort by cash tied up. Multiply excess units by unit cost, so a €500 pile does not distract you from a €50,000 one.
2. Separate by age. Group the excess by how long it has been in stock, because age decides how much discount you will need later.
3. Check demand in other locations. A product with 50 weeks of cover in total can still have 3 weeks in one store. That case calls for a transfer.
4. Flag the dead stock. Anything with no sales over your window and no planned demand moves to the clearance plan.

Doing this by hand for thousands of variants across dozens of stores rarely holds up past the first month, which is where inventory optimization software earns its place: it recalculates target cover and excess for every product and location each week.

How to reduce excess inventory at the source

Cutting the inflow is the cheapest lever, because a purchase order you cancel costs nothing and stock you never receive never needs a discount. Five changes do most of the work.

• Forecast at product, variant, and location level. Weekly demand per variant is the input that makes weeks of cover meaningful. A category forecast hides the spread that creates excess.
• Cut or defer open orders when cover is high. Check weeks of cover on every open purchase order against the order’s arrival date, and cancel or push out the ones that would land on top of existing excess.
• Size first buys smaller on new and uncertain products. Buy a base case, agree a repeat slot with the supplier, and add stock when early sell-through confirms demand.
• Negotiate minimums and pack sizes. Where a minimum forces a buy above forecast, ask for mixed packs or a split across variants before you accept the excess.
• Review early sell-through weekly. The first six weeks of a launch tell you whether to repeat or stop, and that is when order changes are still possible.

McKinsey’s research on AI-enabled supply-chain management reports that early adopters improved inventory levels by 35% and service levels by 65%. The two moving together matters, because it shows that holding less stock and serving customers better are not opposing goals once the forecast is sharper.

Lucía plans for a pet supplies chain with 60 stores. She added a weekly check that compared weeks of cover with each open order’s arrival date, and in the first month it flagged three orders for cat litter and treats that would have landed on more than 30 weeks of existing stock. She cut them by about 40%, which avoided roughly €60,000 of inbound inventory that the stores could not have sold before the next season’s reset. (Lucía is another illustrative example with round numbers.)

How to rebalance stock across locations

Before any markdown, check whether the stock can sell somewhere else. Excess in one store is often a stockout in another, and a transfer recovers full price where a discount would not.

Rank each product by weeks of cover per location, then move stock from locations with high cover to locations with low cover, after accounting for the cost of the transfer. A transfer that costs €2 a unit is worth it for a product with a €25 margin and not for one with a €3 margin. Our guides on rebalancing allocation across stores and smarter stock allocation to protect full-price sales cover the allocation logic and the rules for when a transfer pays.

In Metreecs’ experience deploying product and location forecasting, the share of excess that can be rebalanced rather than discounted is larger than most buying teams expect, because the stock total looks fine while the distribution is wrong. Online channels deserve the same check: a product that is slow in stores may still sell on the web shop, where the audience is wider.

How to sequence clearance without wrecking margin

When rebalancing is exhausted, clear what remains in a planned order, starting with the options that protect the most margin. The sequence matters, because each earlier step is cheaper than the next.

StepBest forWatch-outPromotional placement (no discount)Excess with weeks of life left, seasonal items before the season peaksNeeds a visible slot, such as a front table, an email, or a homepage bannerBundles and add-onsSlow variants paired with a strong sellerCan distort the price of the strong seller if overusedFirst markdown (shallow)Stock that is slow in every locationSet a review date, or the shallow discount drifts on foreverDeeper markdown on a scheduleAged stock approaching season endPlan the steps in advance, so one deeper step does not trigger an early panic cutLot sale to a liquidator or wholesale buyerDead stock, volume that stores cannot absorbRecovery is a fraction of cost, so use it once the other steps are doneDonation or write-offStock with no resale valueCheck tax and accounting treatment with finance first

Two habits protect margin during clearance. First, set the markdown calendar when you decide to clear, with a date and a discount level for each step, so the decision does not get made again every week. Second, pull the clearance stock out of the forecast history or flag the promoted weeks, otherwise the next forecast reads the discounted sales as normal demand and recommends buying more of the same product.

Kofi runs merchandising for a home improvement retailer. He split 1,200 units of aged garden planters into three tranches: 400 went to the three stores with the lowest cover on a transfer, 500 got a shallow markdown with a two-week review date, and 300 went to a wholesale lot at a deeper discount. He lost less margin than a single deep markdown would have cost, and he finished the clearance in six weeks instead of the four months it had taken the year before. (Kofi is an illustrative example with round numbers.)

Where reducing excess inventory breaks down

Fixing excess inventory narrows the problem and does not remove it. Three limits are worth knowing in advance.

• Cutting too far creates stockouts. If you push weeks of cover below the lead time, you trade excess for lost sales. Set a target cover per product role, with a higher service level for core items than for trend items.
• Some stock has no good exit. A product that missed a trend, or a variant that was never going to sell, may only recover a fraction of cost. Knowing that early is the argument for smaller first buys.
• Data quality limits everything. If on-hand counts are wrong, weeks of cover is wrong. Cycle counts and clean inventory records come before the clever part.

Teams also worry that cutting inventory will hurt availability. The risk is real when cuts are applied across the board, and much smaller when they target only the products above target cover. The cash this releases is covered in our guide to working capital in inventory.

FAQ

What is the difference between excess inventory and dead stock?

Excess inventory is stock above what forecast demand needs over the lead time, review period, and a safety buffer, and it is still selling. Dead stock has had no sales over a window you set, often six to twelve months, and has no planned demand. Excess calls for rebalancing and smaller buys, while dead stock calls for clearance.

How do you calculate excess inventory?

Divide on-hand plus on-order units by forecast weekly demand to get weeks of cover. Subtract your target cover (lead time plus review period plus safety buffer), and multiply the remainder by weekly demand. Multiply the result by unit cost to see the cash tied up.

How long before inventory is considered dead stock?

There is no universal rule, so set it by category. Fast-moving consumer goods may qualify after two or three months without sales, while durable and seasonal goods need six to twelve months and a check against the seasonal calendar. Document the window, so the definition does not shift with the mood of the quarter.

Should you discount excess inventory or transfer it first?

Transfer first when another location has low cover and the transfer cost is below the margin gain, because a transfer sells at full price. Discount only the stock that no location can absorb, and do it in planned steps with a review date.

What causes excess inventory in retail?

The most common causes are long supplier lead times, inaccurate forecasts, minimum order quantities, and even allocation across stores. Changing customer behavior adds to it. Most excess traces back to a buying or allocation rule, so changing the rule matters more than clearing the pile.

Conclusion

To reduce excess inventory and dead stock in retail, measure weeks of cover for every product and location, cut the inflow first, rebalance next, and mark down last on a calendar you set in advance. Start with the five products that tie up the most cash, because they usually trace back to a variant that was bought on a category average. If you want to see this on your own range, book a demo to see where your excess stock sits and what it would take to prevent the next pile.

Sources

• Retail Insight Network, “How overstock, stockouts and returns cost retail $1.75tn”: IHL Group’s 2026 inventory distortion estimate, causes of overstock, and the lengthening of purchasing lead times in 2025.
• McKinsey, “Succeeding in the AI supply-chain revolution” (April 2021): inventory and service level improvements for early adopters.