Skip to content

Finding Overstock: How Much Cash Is Sitting on Your Shelves

Blog Restocked 4 min read

Stockouts get noticed because customers complain. Overstock is quieter: it just sits there, holding cash you could spend on products that sell. Finding it is the first step to freeing that cash.

What counts as overstock

A practical definition: stock you are unlikely to sell before you would normally reorder. If a product sells 2 a month and you have 40, you hold 20 months of stock. Unless it is seasonal or a deliberate bulk buy, that is overstock.

A worked example

Product On hand Sold per month Months of cover Cost each Cash tied up
Ceramic mug, blue 120 10 12 $5 $600
Linen apron 45 3 15 $14 $630
Coffee beans 1 kg 30 40 0.75 $11 $330

The beans are fine, they sell through in under a month. The mug and the apron are both overstocked, with a year or more of cover and over $1,200 between them that could be spent on stock that sells. Sorting by cash tied up, not by units, shows where to act first.

Cash tied up, sorted by valueLinen apron15 months of cover$630Ceramic mug12 months of cover$600Coffee beansunder 1 month$330
Sort by cash tied up, not units: the mug and apron hold over $1,200 between them.

Set your own threshold

There is no single right number of months. A sensible threshold depends on:

  • Lead time: a product from a 60-day supplier needs more cover than one delivered next week.
  • Shelf life: anything perishable or dated needs a short threshold.
  • Seasonality: winter stock in October is not overstock; in March it might be.

Many stores start by reviewing anything with more than six months of cover, then tighten the threshold for fast-changing categories.

Plan the clearance

  1. Stop reordering the product today.
  2. Try full-price fixes first: better placement in store, bundling with a bestseller, or featuring it online.
  3. Mark down in steps, for example 20%, then 40%, rather than one deep discount.
  4. Set an end date. If it has not sold by then, return it, donate it or write it off, and record the write-off properly so your stock stays accurate.

Stop it happening again

Most overstock comes from ordering decisions made months earlier. The usual culprits are supplier minimums (see MOQs and case packs), forecasts that missed a slowdown, and forgetting stock already on order. Review months of cover every month, so a slowing product is caught after one order, not three.

Overstock and stock counts

Before acting on an overstock report, make sure the stock figure is right. A product that looks overstocked may simply have a counting or receiving error. A quick count of the top items confirms the problem is real.

Months of cover vs turnover

Two common ways to measure how fast stock moves:

  • Months of cover: stock on hand ÷ average monthly sales. Easy to understand per product: “we have 8 months of this”.
  • Stock turnover: cost of goods sold over a year ÷ average stock value. Useful for a whole category or the whole store: a turnover of 4 means stock sells through about four times a year.

Use months of cover to decide what to act on product by product, and turnover to see whether the store as a whole is improving. If turnover rises after a clear-out, the cash you freed is working harder. For the ordering side, see how to calculate a reorder point.

How to find it

  1. For each product, take stock on hand and divide by average monthly sales. That is months of cover.
  2. Multiply stock on hand by cost price. That is cash tied up.
  3. Sort by cash tied up and look at anything with more than 3 to 6 months of cover.

What to do with it

  • Stop reordering it. The cheapest fix is not buying more.
  • Move it: another location may sell it faster.
  • Bundle or promote it with a faster-selling product.
  • Mark it down before it ages further.
  • Return it to the supplier if your terms allow.

Why overstock happens

  • Supplier MOQs and case packs.
  • Forecasts that didn’t notice a product slowing down.
  • Ordering again because a previous PO hadn’t arrived yet.

How Restocked helps

Restocked’s overstock view shows how much cash is tied up in slow stock, so you can stop reordering it. Open POs count toward stock, which prevents double-ordering, one of the most common causes. To rebalance stock between locations, ShiftRight is coming soon.

Read next: Stocky Alternatives Compared: Purchase Order Apps for Shopify · Safety Stock Explained for Small Retailers

FAQ

Is overstock always bad?

No. A deliberate bulk buy at a good price, or seasonal stock ahead of the season, is planned. Overstock is stock you did not mean to hold.

How often should I check for overstock?

Monthly is a good rhythm for most stores.