Inventory Aging: Sort Stock by Age, Then Act

What inventory aging means: days listed versus days owned

Two dates matter for every item: when you bought it and when you listed it. Days listed counts from the moment the listing went live. Days owned counts from your purchase date. Most resellers track days listed because it directly reflects marketplace visibility—OLX shows listings for 30 days, Vinted Bump runs for 3 or 7 days, and Allegro Lokalnie auctions last 7 days.

Use whichever date matches how you think about your stock. If you source items and list them the same day, both dates are nearly identical. If you hold inventory between purchases and listings, track both and see which tells a more useful story.

Pick your age buckets: an editorial choice

For example, a common bucket structure has four bands:

• 0–30 days — fresh listings, normal display time
• 31–60 days — no longer new, needs attention
• 61–90 days — falling behind, needs action
• 90+ days — aged stock, needs a decision

These edges are not a market standard. OLX displays listings for 30 days and auto-extends them for another 30 days, so a 30-day bucket aligns with that clock. Vinted Bump runs for 3 or 7 days—your fresh listings get a boost, then they sit in the feed. Allegro Lokalnie auctions run for 7 days.

Pick bucket edges that match how you think about your stock and keep them consistent. The exact numbers are an editorial choice—say so in your report if you share it.

Build the report in a spreadsheet

Create a sheet with these columns:

The bucket formula groups every item automatically. Add a pivot table that sums buy cost per bucket—you'll see at a glance how much money is stuck in each age band.

See listing expiry dates for platform-specific display periods and inventory valuation for how to value stock on hand.

The bar chart above shows what the pivot table produces. In this example, say you have 700 zł of buy cost sitting in items older than 90 days—that's capital you may want to free up.

Decide what to do per bucket

Each bucket suggests a different action:

• 0–30 days: Normal. Let the listing run. Monitor for views and favourites.
• 31–60 days: Check the price against current comparables. If comparable items have dropped in price, match them. If the price is fair, consider better photos or a description refresh.
• 61–90 days: Re-photograph the item if your original photos feel dated. Crosslist to another platform where fresh buyers might see it. Consider a small price drop—for example, 5–10% often wakes up the algorithm.
• 90+ days: Decide item-by-item. Price aggressively to liquidate, or remove and relist with fresh photos. If the item has poor sales data everywhere, selling at break-even clears cash for faster-moving stock. See dead stock reselling for liquidation options.

• Check price against comparables (31–60 days)
• Re-photograph the item (61–90 days)
• Crosslist to another platform (61–90 days)
• Price drop or liquidation decision (90+ days)

Watch money tied up per bucket

The bar figure above sums buy cost per bucket. Do this every week and you'll see trends: if your 90+ bucket keeps growing, you're buying faster than you're selling. If the 31–60 bucket balloons, your pricing is too high compared to the market.

A healthy pattern has most buy cost in the 0–30 bucket and declining amounts in older buckets. If older buckets match or exceed newer ones, adjust your sourcing, pricing or photography.