Ecommerce operations glossary
What is aged inventory?
Also called Inventory aging, Slow-moving inventory, Old stock
Aged inventory is stock that has been on hand longer than you planned to hold it, measured from the date each batch arrived. It is sorted into age buckets, such as 0 to 30 days or over a year. Old stock is not yet dead stock, but it costs money to keep and is most likely to need a markdown.
Worked example
One product has three batches on the shelf:
| Batch | Units | Days on hand | Unit cost | Value | Bucket |
|---|---|---|---|---|---|
| 1 | 200 | 20 | $5.00 | $1,000 | 0-30 |
| 2 | 150 | 140 | $5.20 | $780 | 91-180 |
| 3 | 100 | 400 | $4.80 | $480 | 365+ |
Total value is $1,000 + $780 + $480 = $2,260. The stock over 180 days old is batch 3: $480.
What does keeping it cost? At an annual carrying cost of 25% (storage, insurance, the cash tied up), another 90 days is a quarter of a year:
$480 × 25% ÷ 4 = $30
Thirty dollars is small. The real question is batch 3 itself: 100 units that have not sold in over a year, while newer stock of the same product keeps selling. That usually means pickers reach for the newest boxes first, or the old batch has a problem nobody has looked at.
The unit-weighted average age hides this. (200 × 20 + 150 × 140 + 100 × 400) ÷ 450 = 65,000 ÷ 450 = 144 days, which sounds fine. Age each batch, not the product.
Aged vs dead stock
Aged stock is still selling, just slower than planned. Dead stock has stopped selling. Aged stock becomes dead stock if nothing is done, so the aging report is where you catch it while it can still be sold at a reasonable price.
What to do with it
- Move it to a warehouse or channel where it sells.
- Pair it with a fast seller in a bundle.
- Mark it down while the margin can absorb it.
- Stop buying it. If the same product keeps aging, the order quantity is too big.
- Reserve for it. Stock unlikely to sell at cost needs a write-down or an obsolescence reserve in the books.
More terms: Inventory
- ABC analysis
- Bundle
- Consignment inventory
- Cycle count
- Days of supply
- Dead stock
- GTIN
- Inventory allocation
- Inventory shrinkage
- Inventory turnover
- Kitting
- Lot tracking
- Multichannel inventory management
- Negative inventory
- Product variants
- Sell-through rate
- Serial number tracking
- SKU (stock keeping unit)
- Stock transfer
- Stockout
Updated · All terms