Inventory Aging: How to Identify Slow-Moving and Old Stock

Inventory aging measures how long inventory has remained in stock or how long it has gone without selling, depending on the reporting method. Aging analysis helps identify products that are becoming slow-moving, excessive, obsolete, or likely to require a markdown.

What is an inventory aging report?

An inventory aging report groups inventory into time-based buckets so operators can see how much stock is relatively fresh and how much has been sitting for longer periods.

Example buckets might be:

• 0–30 days
• 31–60 days
• 61–90 days
• 91–180 days
• 180+ days

Those ranges are only examples. The appropriate buckets depend on the product lifecycle and business.

What date should inventory aging use?

This is one of the most important decisions. Different reports may use receipt date, first-stocked date, last sale date, or another inventory event.

For FIFO-style received inventory, aging by receipt date can show how long specific stock has been held. For merchandising decisions, days since last sale or sales velocity may sometimes be more useful than the product's original creation date.

Document the method clearly so teams know what the age actually represents.

Inventory aging example

Suppose a retailer has $100,000 of inventory:

• $45,000 in 0–30 days
• $25,000 in 31–60 days
• $15,000 in 61–90 days
• $10,000 in 91–180 days
• $5,000 over 180 days

The report does not prove that the older $15,000 is bad inventory. It identifies where the business should investigate sell-through, seasonality, demand, and product lifecycle.

Inventory aging vs. dead stock

Dead stock is inventory unlikely to sell normally within a useful timeframe. Aging inventory is simply older inventory. A durable spare part may be old but still strategically useful; a seasonal fashion item may become commercially problematic much sooner.

Inventory aging vs. DSI

Days Sales of Inventory is typically a financial ratio based on average inventory and COGS. An aging report is usually a SKU-, receipt-, or lot-level operational view of how long specific inventory has been held.

Why inventory ages

• Demand was overestimated
• Buying quantities were too large
• A seasonal selling window passed
• A newer product replaced the old one
• The product is stocked at the wrong location
• Price or assortment is no longer competitive
• Reorder rules continued after demand slowed
• Supplier minimums forced excess purchasing

What to do with aging inventory

Stop or reduce replenishment

Do not continue buying a product simply because an old reorder rule triggers. Review current demand and open purchase orders.

Transfer it

If other locations have stronger demand, use stock transfers before applying a company-wide markdown.

Markdown strategically

For time-sensitive products, earlier controlled markdowns may protect more margin than waiting until demand disappears.

Bundle or reposition

Useful bundles, merchandising changes, or alternate channels can sometimes improve sell-through without a direct price cut.

Return or exchange with suppliers

Where supplier agreements allow it, returns or exchanges may recover value from slow stock.

How aging analysis improves purchasing

Purchasing teams should review aging before approving new orders. A category can look low on one popular SKU while holding substantial excess in related products.

Pair aging with weeks of supply, sell-through, and inventory turnover to understand whether the issue is age, quantity, or declining demand.

Inventory aging by location

Age inventory by store or site when possible. A product that is stale at one location may still sell quickly elsewhere. Location-level aging can surface transfer opportunities before the stock loses value.

How often should aging be reviewed?

The faster the product lifecycle, the more frequently aging should be reviewed. Fashion, perishables, and seasonal inventory require faster intervention than long-life replacement parts.

How Stash fits

Stash gives physical businesses visibility into stock, locations, purchasing, and product performance. That operational context helps teams identify inventory that is sitting too long and change replenishment before it becomes dead stock.

Frequently asked questions

What is aged inventory?

Aged inventory is stock that has been held for a relatively long period based on the aging definition used by the business.

What is a good inventory aging threshold?

There is no universal threshold. It should reflect shelf life, product lifecycle, selling cadence, seasonality, and the cost of holding the stock.

Is old inventory always bad?

No. Some products naturally sell slowly or are intentionally held for strategic availability. Aging is a signal to investigate, not an automatic write-off.