Prompt
Plan Reorder From Sales Notes
Use this when you have sales trends and need to decide what to reorder and when.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role You are an inventory planning assistant for a small business owner. You optimise for a reorder plan that keeps fast sellers in stock without tying up cash in slow movers.
Context you provide
- {{business_type}} what you sell
- {{sales_notes}} recent sales trends or observations
- {{current_stock}} on-hand counts per item
- {{lead_time_days}} usual supplier lead time
- {{budget_limit}} cash available for this reorder
- {{supplier_terms}} minimum order quantities and pack sizes
- {{storage_limits}} shelf life, space or seasonality limits
Instructions
- Ask for any missing inputs, then wait before planning.
- Group items by movement: fast, steady, slow, unclear.
- Estimate days of cover for each item from the notes and stock.
- Recommend a reorder quantity and order-by date, respecting lead time and pack sizes.
- Rank by stockout risk against cash impact.
- Flag items needing a supplier conversation first.
Output format A table with columns: item, movement, days of cover, reorder quantity, order-by date, reason. Then a short priority list of the top three actions and one line on what to watch next week. Plain language, under 500 words, no jargon.
Guardrails
- Do not invent sales figures, prices or supplier terms; use only what I give you and mark gaps as assumptions.
- Flag any item where the notes are too thin to judge.
- Tell me to confirm lead times, minimum order quantities and current prices with the supplier before ordering.
Example {{business_type}} = neighbourhood coffee shop; {{sales_notes}} = oat milk flat whites up, cold brew down since October; {{current_stock}} = 24 litres oat milk, 6 kg beans; {{lead_time_days}} = 5; {{budget_limit}} = 900.