Having enough stock lets you meet demand. But when the quantities on hand durably exceed needs, stock becomes a cost: it ties up cash, takes up space and increases the risk of markdowns, write-downs or losses.
Overstock, or overstocking, doesn't simply mean “having a lot of products”. A large quantity can be perfectly normal for an item that sells fast.
The real question is: is the stock on hand consistent with the pace at which it sells?
This comparison is what lets you detect overstock, decide which items to deal with first and, above all, avoid recreating the same excess in your next restocking.
What is overstock?
Overstock appears when the quantity on hand durably exceeds the store's foreseeable needs.
It therefore can't be defined by a number of units that is the same for every product.
100 items in stock can be perfectly normal for an item selling 50 times a day, and represent several months of stock for a product selling twice a month.
To identify overstock, you therefore need to put the quantity on hand in perspective with:
- the sales pace;
- the time needed to sell through the stock;
- forecast sales;
- upcoming replenishments;
- supplier lead times;
- the item's seasonality.
Overstock is therefore an excess relative to needs, not simply a high quantity.
Overstock, low turnover and dead stock: what's the difference?
These three notions are close, but they don't describe exactly the same problem.
- Overstock is about quantity: the store holds more units than needed compared to expected sales.
- Low turnover is about speed: the product still sells, but slowly relative to the quantity held.
- A dead stock item is about the absence or near-absence of movement: the item has barely sold for a significant period.
A product can therefore be overstocked while still selling well. The problem is simply that the quantity held represents too many weeks or months of sales.
Conversely, a dead stock item may be only a few units: its quantity isn't necessarily large, but its stock no longer moves.
This distinction matters, because the actions won't be the same.
Why does overstocking happen?
Overstocking is rarely due to a single cause. Several situations can gradually lead to accumulating too much merchandise.
An order that is too large
The store bought more than needed, sometimes to take advantage of a price, reach a minimum order or anticipate a sales increase that ultimately didn't happen.
Forecasts that are too optimistic
A particularly strong previous period can lead to overestimating future demand.
A promotion, a local event, exceptional weather or an atypical season can, for example, skew the reading of recent sales.
A drop in sales
The order made sense when it was placed, but demand then slowed down.
If the next restocking isn't adjusted, the excess grows.
A reorder threshold that is too high
A poorly set threshold can trigger orders too early or systematically keep more stock than needed.
Seasonality that wasn't anticipated well
Needs can vary sharply from one period to another.
Stock that is right in December can become excessive in January. Likewise, a summer item shouldn't be managed solely from its annual average.
Identifying the cause is essential: selling off the current overstock isn't enough if the mechanism that created it remains unchanged.
Why is overstock so costly?
The most immediate consequence is tied-up cash.
Merchandise that has already been bought but stays in stock for a long time is money that can't be used elsewhere: more urgent purchases, investment, marketing or day-to-day operations.
But the cost of overstock doesn't stop there. It can also lead to:
A few excess units on one item may seem harmless. A few excess units across dozens or hundreds of items can add up to a significant sum.
That's why it's useful to measure overstock not only in units, but also in tied-up value.
How do you detect overstock?
Looking only at the quantity on hand isn't enough. A useful analysis cross-checks several metrics.
1. Stock on hand
This is the starting point: how many units are currently there? But this figure alone doesn't let you conclude anything.
2. The sales pace
It shows how fast the item sells. If 120 units are available and 30 are sold every week, the situation is very different from a product of which only two units are sold per week.
3. Stock coverage
Coverage translates the stock on hand into a duration. For example, if 100 units remain in stock and the store sells about 10 a week: 100 ÷ 10 = about 10 weeks of coverage.
This duration can then be compared with the supplier lead time and the usual replenishment frequency. If the supplier delivers every week, ten weeks of coverage may deserve a closer look.
4. Inventory turnover
Turnover helps identify the items that renew quickly and those that stay tied up longer. It is particularly useful for comparing products or families with one another.
5. Sales trends
An average alone can mask a trend. An item can still show a decent six-month average while its sales have been dropping sharply for four weeks.
You therefore need to look not only at how much the product sells, but also at the direction its sales are moving in.
6. Tied-up value
Not all overstock has the same priority. 50 excess units of a low-cost product may tie up less cash than five units of a very expensive item.
Ranking items by excess stock value lets you start with the situations that have the most impact.
Example: detecting overstock
Take an item of which the store has 120 units. Recent sales are about 10 units per week.
The stock therefore represents: 120 ÷ 10 = 12 weeks of sales.
But the supplier delivers every week and the store normally wants to keep about four weeks of coverage. The situation therefore deserves a closer look: the stock on hand is about three times the usual coverage.
This doesn't automatically mean the product has to be marked down. You first need to understand why:
- was an exceptional order placed?
- have sales recently slowed down?
- is a sales campaign planned?
- is a stronger seasonal period approaching?
- is another order already on the way?
Detecting overstock is a decision signal, not an automatic decision to clear stock.
What to do about overstock?
A promotion isn't systematically the best solution. The action depends on the cause, the margin, the sales speed and the product's context.
Reduce or pause restocking
If the product keeps selling normally, not reordering it for a while absorbs the stock without sacrificing margin.
Transfer between locations
In a network of several stores, a transfer rebalances quantities without buying more or clearing stock at reduced prices.
Improve visibility
A product may be poorly visible rather than genuinely unappealing: changing its placement can speed up its sell-through.
Run a targeted promotion
When the margin allows it, a targeted discount speeds up sales without needlessly hurting the profitability of the whole range.
Clear the stock
For items with a lasting excess or no expected return of demand, clearing the stock becomes preferable to tying it up for longer.
How do you avoid overstocking?
Dealing with existing stock fixes the symptom. To keep it from coming back, you need to fix the replenishment process.
- Use recent sales without following them blindly: an exceptional week after a promotion shouldn't necessarily serve as the reference for the following orders.
- Account for the stock already on hand: a restocking recommendation should never be based only on what has sold; the remaining stock must be subtracted from the estimated need.
- Adjust stock thresholds: a threshold that is too high mechanically sustains overstocking and must evolve with sales, supplier lead times and the season.
- Account for orders already in progress: an item may seem to need restocking when a delivery is already expected.
- Regularly review high-coverage items: it's easier to correct a drift after a few weeks than to discover several months of tied-up stock.
How can Gillia help detect overstock?
When sales, stock, prices and supplier data are accessible in one place, the analysis can be run directly from the store's data. A merchant can ask Gillia:
“Which items represent the most stock tied up relative to their sales?”
The analysis can then be taken further:
“Rank them by tied-up stock value.”
The goal is then not to treat all excess the same way, but to start with the items that really weigh on cash. Then:
“Which of them have also seen their sales slow down in recent weeks?”
This tells a simply high stock level apart from a situation where demand is falling. Finally, the analysis can lead to an action:
“Prepare a selection of products to clear whose margin allows a promotion.”
The agent selects the items concerned, checks the available margin and prepares the promotion or the order adjustment — to be approved before it runs.
The point is therefore not just to produce a list of products. It is to go from detection to explanation, then from explanation to action, with approval when the action actually changes data or prepares an operation.
With Gillia's inventory management, the goal is to help the merchant detect these cases, understand them and find the right actions faster — without breaking the margin. For the full logic of inventory, see In-store inventory management; to avoid over-ordering in the future, the analysis extends to supplier ordering, and at the opposite end from overstock, too little stock raises the problem of stockouts. You can find other examples of concrete Gillia uses around inventory: preparing sales from dead stock or knowing the value of your stock.
Overstock must be managed before it becomes a problem
Overstocking isn't just “too many products in the back room”. It appears when the quantities held are no longer consistent with the store's future needs.
To manage it properly, you therefore need to cross-check: stock on hand → sales speed → coverage → trend → tied-up value. Then choose the action suited to each situation.
Good overstock management doesn't mean multiplying promotions. It mostly means detecting excess early enough, understanding where it comes from and adjusting your next purchases before cash stays tied up for months.