How to Build a Reseller Inventory Aging Report

Record both the acquisition date and the first listing date when possible. Acquisition age reveals how long your cash has been tied up; listing age tells you how long buyers have had a chance to see the offer. Use one definition consistently within each report.

For a starting point, group open units into 0–30, 31–60, 61–90, and more than 90 days. Adjust the bands for your category and normal selling cycle. Keep sold, returned, reserved, and unavailable units out of the count of currently sellable stock.

Count both units and acquisition cost in each band. If 72 of 400 available units are older than your chosen threshold, 72 ÷ 400 = 18% of units. The cost share may tell a different story if expensive items age more slowly.

Break the report down by category, price range, source, or storage location to find useful patterns. A whole-catalog average can hide one difficult category.

Confirm the item is still in stock and that its SKU and location are correct. Check the listing's photos, condition notes, title, item specifics, shipping terms, and comparable sold prices. Check whether the marketplace offer is active and the product is discoverable.

Then choose an action: improve the listing evidence, adjust the price based on current economics, move to a more suitable available channel, bundle, or liquidate. Repricing alone will not fix missing photos or an incorrect item identity.

Compare the original research and expected sale price with actual offers and sales. Update buying ceilings or pass on categories that repeatedly hold cash for too long. Record why you changed an item and review the result later.

Inzoly's inventory records can help keep products, quantities, locations, and listing work connected. Review marketplace availability before planning a new publishing channel.