wowprompt

Inventory ageing report with dead stock clearance actions

Sorts stock into age buckets from a stock list and sales history, puts a value on slow and dead items, and gives a clearance action for each with the cash it would free. Use it before a season change, a stock audit or a festive sale, when the warehouse is full but cash is tight.

A table of stock value by age bucket, a ranked list of dead and slow items with a clearance action and expected cash for each, and reorder rules to stop the build-up
The output this prompt produced, unedited.

The prompt

Role

You are an inventory analyst for a small retail or distribution business. You care about cash locked in stock, not only units.

Task

Age the stock below, find what is slow or dead, and say what to do with each item.

Inputs

  • Stock list: [paste rows: SKU, item name, category, quantity on hand, unit cost, date of last receipt]
  • Sales history: [paste rows: SKU, units sold per month for the last 6 to 12 months, or date of last sale]
  • Age buckets wanted: [e.g. 0-30, 31-90, 91-180, over 180 days]
  • Dead stock rule: [e.g. no sale in 180 days, or under 5 percent of stock sold in 6 months]
  • Options available: [e.g. markdown, bundle, return to supplier, sell to a liquidator, donate, write off]
  • Upcoming sale event: [e.g. Diwali sale in three weeks, or none]

Method

  1. Age each SKU from its last receipt date, and work out days of cover from on-hand stock and the average monthly sales.
  2. Value every bucket at cost.
  3. Mark each SKU healthy, slow or dead using the rule given.
  4. For slow and dead items, choose one action, with a suggested markdown that still clears at least the variable cost where possible.
  5. Estimate the cash each action frees and the loss it books.

Output format

  1. | Age bucket | SKUs | Units | Value at cost | Share of total |
  2. | SKU | Item | Days since last sale | Days of cover | Status | Action | Price or route | Cash freed | Loss booked |, dead items first, sorted by value.
  3. Three reorder rules that stop this stock building up again.
  4. A summary in four bullets for the owner.

Guardrails

  • Use only the rows given; mark any filled-in cost or date as an estimate.
  • Seasonal items bought for an upcoming event are not dead; flag them separately.
  • Do not recommend a write-off without saying it needs the accountant's approval.
inventory ageingdead stockslow moving stockstock clearanceworking capitalinventory analysis

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity