Start by separating unlisted purchases from old live listings. An unlisted coat has a work-queue problem: it cannot sell yet. A coat listed for six months has a demand, price, presentation, or platform problem. Put both in the same spreadsheet, but give them different review actions.
Every week, record four numbers: unlisted item count, unlisted purchase dollars, listed items aged 90 days or more, and unsold purchase dollars aged 180 days or more. That last number is the cash stuck in old stock. It is more useful than a dramatic photo of the garage.
| Measure | Calculation | Next decision |
|---|---|---|
| Unlisted backlog | Items with no live listing | Schedule listing, bundle, or exit |
| Backlog cost | Sum of purchase cost for unlisted items | Limit new sourcing until it shrinks |
| Stale listings | Live items grouped by days since listing | Recheck price, photos, title, and marketplace |
| Aged capital | Purchase cost of unsold items held 180+ days | Choose a recovery path |
These age bands are review checkpoints, not a claim that every category should sell in 90 days. Seasonal items and unusual collectibles need their own calendar. A new unlisted purchase is backlog, not automatically a death-pile item; a year-old unlisted purchase is both.
Run one pass on the unlisted queue
Sort by purchase date, oldest first. Give each item one of four outcomes: list this week, sell in a lot, hold for a named seasonal listing date, or remove from working stock. Put the decision and deadline beside its SKU. If a $4 item needs an hour of repair and research to list for a likely $15 sale, the work may cost more than the recovery. That is a judgment about expected net proceeds and time, not about what you once hoped the item would earn.
Set a weekly listing capacity before the next sourcing trip. If you acquire 30 items a week and list 15, the backlog grows by 15 even if sales are excellent. Acquisition is the lever that changes the queue fastest.
Review the old listings differently
For each old live item, check recent sold comps, current asking price, photos, title, condition details, and the platform where its buyers actually shop. eBay's Product Research can help compare current market prices and sales. Then record one action: improve the listing, adjust price, crosslist, bundle, or clear it. Do not relist blindly just to reset the displayed age; make a specific change you can evaluate later.
On the next review, compare how much stock left the queue. The useful measure is items newly added − items listed, sold in lots, or removed. A tidy spreadsheet with a growing backlog is still a growing backlog.
Make the count automatic where you can
The free Reseller CFO tracker has an Inventory Log with purchase date, listed date, bin, status, days held, and age flags. Its Dashboard calls unsold items held 180 days or more the death pile and totals both their count and purchase dollars. It does not decide whether to discount or dispose of anything; it makes the stock visible for your weekly decision.
Keep one physical SKU per item even when it is listed on both eBay and Poshmark. That prevents a crosslisted coat from doubling your backlog count and makes the oldest ten items easy to pull from their bins today.
