wowprompt

Slow-moving stock clearance plan with discount steps

Sorts unsold inventory by age, cost and sell-through, then plans how to clear each group: bundles, staged markdowns, outlet listings, B2B lots or donation, with a floor price so clearance never loses more than it saves. Use it before a new season arrives or when warehouse space and cash are tied up in old stock.

A table grouping old stock by age and sell-through, a staged discount schedule with floor prices, and the clearance route chosen for each group
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Stock list: [rows: product, units on hand, unit cost, current price, units sold in the last 90 days, date received]
  • Storage cost per unit per month: [amount, or estimate]
  • Channels available: [e.g. own website, two marketplaces, physical store, wholesale buyers]
  • Upcoming events: [e.g. Diwali sale, year-end sale, new collection arriving in four weeks]
  • Cash or space goal: [e.g. free 30 percent of shelf space by 15 December]
  • Products that must not be discounted publicly: [list, if any]

Task

Plan the clearance of slow-moving stock with the least loss and without hurting full-price sales.

Output format

  1. | Product | Age in days | Weeks of stock left at current speed | Holding cost to date | Group |

Groups: watch, clear gently, clear now, write off.

  1. For each group, the route: bundle with a bestseller, staged markdown, outlet section, wholesale lot, gift with purchase, or donation.
  2. Markdown schedule: | Week | Discount | Floor price | Stop if |
  3. Copy for the outlet or clearance section: title, a two-line intro, and badge text.
  4. Three numbers to track weekly.

Rules

  • The floor price never drops below what the unit would recover in a wholesale lot, unless the space goal requires it; say so when it does.
  • Keep clearance pricing away from bestsellers and new arrivals.
  • No fake "was" prices; the reference price is the real recent selling price.
  • Flag expiry-dated or perishable items first.
stock clearanceslow moving inventorydead stockmarkdown planinventory liquidationecommerce operations

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