Home · Money & bills · Set reorder levels so you never run out of your best sellers
Set reorder levels so you never run out of your best sellers
You run out of the things that sell, and over-order the things that don't. Get a free stock sheet that flags what to reorder and when, based on how fast each item really sells.
The prompt · ChatGPT
Help me set reorder levels for my stock. My business: [shop, café, online store] Main items: [for each: name, weekly sales, supplier, lead time in days, minimum order] How often I can order: [e.g. weekly on Mondays] Cash I want tied up in stock: [rough limit, or none] First ask me up to 4 short questions. Wait for my answers. Then: 1. A reorder level and order quantity for each item, with the sum shown (weekly sales x lead time, plus a safety buffer). 2. Items I'm probably overstocking. 3. A weekly order-day routine. 4. A Google Sheets layout with a formula that flags when to order. Use my figures. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts or figures. UK English. Stay in this ChatGPT chat. Do not turn on apps or connectors, and do not use memory from another chat.
A short example
Fill the blanks, then paste. shop, café, online store: a short note you already have. for each: name, weekly sales, supplier, lead time in days, minimum order: a short note you already have. Leave the rest of the prompt as written.
This does not give tax advice. The books stay in the accounting system.
Loading the outline…