Catch Overstock Risk Early
Overstock usually gets noticed too late, after the cash and the warehouse space are already tied up. The surface question is 'how much stock do I have left'; the real question is 'which of these products is quietly bleeding my capital right now, and what do I do about it before the next purchase order.' This prompt turns your existing sales data into an early-warning system: it flags which SKUs carry real overstock risk, ranks them by severity, and tells you what to cut, slow down, or discount before the problem compounds.
You are an experienced inventory analyst. Your job is to look at the sales data I give you and tell me which products carry overstock risk, and what I should do about it. Never invent numbers. Work only from the data I give you, and say so plainly if the data isn't enough to draw a conclusion. Use the following information for the analysis: [ANALYSIS PERIOD]: (last 3-6 months) [MY PRODUCT CATEGORIES]: [MY SALES DATA]: (paste as product, stock on hand, units sold) [MY WAREHOUSE CAPACITY/CONSTRAINTS]: [MY LEAD TIME]: Structure the analysis under these headers: 1. **Risk Table**: product, current stock, sales velocity, risk level (Critical/High/Medium). 2. **Top 3 Most Critical Products**: why each one is at risk. 3. **Purchase Order Adjustments**: what to pause or cut back on. 4. **Ideas for Moving Excess Stock**: promotion or bundling suggestions.
How to use it
- Use it before placing a new purchase order, to see your current stock risk first.
- Use it when warehouse space gets tight, to prioritize which products need to move fastest.
- Use it at season transitions (summer to winter and back) to evaluate what's still sitting on the shelf.
Example / tip
A seller of winter accessories runs their stock list before March. The output flags two winter items as Critical, still holding high inventory with sales slowing down, and recommends clearing them with an end-of-season discount rather than carrying them into next year.
Usage example
Copy the prompt as is, fill in the bracketed fields for your own business, and paste it into ChatGPT or Claude. The more concrete your input, the more useful the output. Take the first draft, ask for a one-sentence fix on whatever you don't like, then give it a final pass in your own voice.
When not to use it
Don't force it if you have no real input to work with. A prompt doesn't fill an empty field with data, it organizes and speeds up what you already know. Never publish the output unchecked; AI sometimes produces a claim that sounds right but is wrong or made up. Always verify anything that needs proof yourself: numbers, prices, guarantees.
Output quality checklist
- Is the output specific to your input, or generic filler that fits any business? If it's generic, run it again with more concrete input.
- Does every number, ratio, or claim have something backing it? Delete the unbacked ones or soften them honestly.
- Does it sound like you? Simplify the cliches and inflated lines in your own voice.
- Does it give one clear next step? If the reader knows what to do, the output did its job.
