The weekly review

Inventory goes stale quietly. Nothing tells you the jacket has been listed for four months. The weekly review does. Pick a day, keep it short, and write one row on the Weekly review tab.

The prompt

With the sheet in Google Drive, or the .xlsx attached:

Weekly review. Read my resale sheet.

1. Overview: items sold this week, profit this week, items to list, items listed, cost tied up in stock.
2. Aging: every Listed item older than the aging days in Settings. Table: SKU, item, age, list price, floor, sold comps. For each, suggest one of: re-check comps, improve the listing, mark down to [price], or pull it. One line why.
3. Problems: anything listed below its floor, anything sold at a loss, any Listed item with fewer than 3 sold comps.
4. What's working: which categories sold fastest and made the most per item, from Sold rows.
5. A top three for next week.

Don't change the sheet. Give me a row for the Weekly review tab at the end.

Then decide

Go down the aging list and decide each one. Marking down, re-listing or pulling are all fine answers. Leaving it for another month without deciding is the one that costs you.

Paste the row into the Weekly review tab. After a couple of months, that tab answers the questions worth asking: which categories pay, how long things really take to sell, and whether your minimum profit is set right.

Once a quarter

• Re-check every fee in Settings against each platform's fee page, and update the "Checked on" date.
• Look at the passes on Sourcing. If a category keeps failing the math, stop stopping for it.
• Look at your minimum. If most sales clear it easily, you can afford to raise it. If good items keep failing it, it may be set too high.