Inventory age is a signal that stock deserves review; it is not a complete diagnosis. An item can be old because it sells slowly, arrived in too large a case, was unavailable for sale, or belongs to a seasonal plan. A useful review combines age with movement, available quantity and a documented next step.
Choose age buckets that fit the business
Start with the receipt date of the units currently on hand when that information is available. Common buckets might be 0–30, 31–60, 61–90 and more than 90 days, but the appropriate ranges depend on the product, normal sales cycle and any applicable date limitations. The key is to use the same definition from one review to the next.
Build an exception report
Focus first on items that cross a chosen age or coverage threshold. For each exact SKU, gather:
- available units and units that are held or damaged;
- oldest relevant receipt date and most recent receipt date;
- last sale date and sales during a defined period;
- average weekly unit sales and weeks of supply;
- open purchase orders or automatic replenishment settings;
- case-pack size and current shelf location.
Interpret age with movement
Thirty old units selling ten per week present a different situation from thirty units selling one per week. Calculate weeks of supply = available units ÷ average weekly unit sales. When weekly sales are zero, label the measure as unavailable or no recent sales instead of dividing by zero.
Sell-through adds another view: units sold during the period divided by units available for sale during that period. Define the denominator in the worksheet so the calculation can be repeated.
Find the operational cause
| Observed pattern | Question to investigate |
|---|---|
| High stock after one receipt | Was the case pack larger than the target? |
| Repeated receipts despite slow sales | Is an old reorder point or automatic order active? |
| No sales after a location change | Is the item correctly listed, priced and placed? |
| One variant ages while others move | Was demand planned at family level instead of SKU level? |
| Inventory unavailable for sale | Is stock damaged, quarantined or incorrectly coded? |
Assign a lawful, specific action
Possible actions include correcting the inventory record, stopping replenishment, changing the assortment role, relocating stock, returning goods when an agreement permits it, or using a lawful promotion. Product category, supplier terms and applicable rules may restrict some actions. Record the owner, quantity affected and follow-up date instead of writing only “review later.”
Prevent the same problem from returning
Compare the finding with the original purchase decision. If the case pack created excess coverage, use the pack-conversion guide. If replenishment continued too early, recalculate the reorder point. If too many similar variants were added, revisit assortment roles and weeks of supply.
Separate inventory corrections from commercial actions
First confirm that the quantity and SKU are accurate. A duplicate receipt, unposted transfer or damaged unit coded as available can make an item appear slow. Correct the record with an audit note before evaluating demand. Commercial actions should be based on the corrected available quantity.
Next check whether the item was continuously available to shoppers. Time spent in a hold area, an inactive online listing or the wrong shelf location is not normal selling exposure. Document the unavailable period so the review does not describe an execution problem as a demand result.
Create a follow-up test
Every action needs a measure and date. If the item is relocated, compare unit sales for a defined period while noting other changes. If replenishment is stopped, confirm that open purchase orders were also addressed. Close the exception only when the next review records the outcome; otherwise the report becomes a list of intentions.
Keep a short decision log: review date, evidence, cause, action, owner and next check. Over time, the log shows whether aging comes from buying quantities, inaccurate records, lead-time assumptions or assortment design. That evidence is more useful than a one-time clearance decision.
Content notes
A repeatable aging review that combines receipt date, last sale, weeks of supply and sell-through to identify slow inventory and assign a documented next action.
Last reviewed:
Reviewed by: MWHQ GOODS Editorial Team