Prompt Library for Small Businessby Small Business Control Center · free
Team and operationsWork with your numbers Check the numbersAbout 15 minutes

When to restock: minimum stock based on your sales

A simple way to work out how much stock to keep and when to order, using a spreadsheet.

Useful for: Shops and online sellers, Restaurants, bars and cafés, Salons, spas, gyms and clinics, Trades and home services.

  1. 1Copy the prompt
  2. 2Replace what’s in [brackets] with your details
  3. 3Paste it into ChatGPT, Claude, Gemini or Copilot

The prompt

Act as an operations advisor for small shops and businesses that hold stock. Write in English, without jargon. My business is in [COUNTRY, e.g. the US, the UK or Australia]: if something depends on the rules there and you’re not sure, tell me. I want to know when to restock each product. Don’t do the math yourself: design the sheet and give me the formulas. My business: [YOUR BUSINESS] Data I can get (sales per product over recent weeks, supplier lead time, minimum order, cost and price): [AVAILABLE DATA] Most important products: [KEY PRODUCTS] Products that expire or go out of fashion: [PERISHABLE OR SEASONAL PRODUCTS] Give me: 1. The columns for an inventory sheet with weekly sales, lead time, safety stock and reorder point. 2. The formulas for Excel and Google Sheets, explained in one line. 3. How to highlight in red what needs ordering now. 4. An example with 3 made-up products, clearly marked as an example. 5. How to handle seasonal products. If you need a figure, ask me. Don’t make up numbers for my business.
Fill in the gaps on this page
Example of what to write: YOUR BUSINESS: gift shop | AVAILABLE DATA: weekly sales for the last 8 weeks, 10-day delivery, $100 minimum order | SEASONAL PRODUCTS: the holiday season.

Did it work for you?

One click is enough. Your answer tells us which prompts need work, and it helps the next person who uses it.

Reviewed with: Claude (Nov 2026). Last updated: 2026-11-15. AI answers can contain mistakes. Check what matters.

More like this

Recommended tools

Tools we recommend for your business

We picked them because they suit small businesses. Some links are affiliate links: if you sign up through them we get a commission, at no extra cost to you. How we choose them and all the tools.

Affiliate linkEmail and teamworkGoogle Workspace

Email on your own domain, shared documents, calendar and video calls.

Works with Small Business Control Center: the workbook runs in Google Sheets, which comes with Google Workspace.

What’s new

New and reviewed prompts every week

See more updates →

Help us improve the library

What would you like AI to take off your plate?

Tell us the task that eats up your week. We read every request and the most repeated ones become new prompts.

We’ll only use them to reply about this request. No newsletter unless you ask for it.

Free newsletter · 1 email a week

Get practical tools to run your business better

A selection of prompts, guides and tips to put AI to work and improve how you run your business. We only ask for your email; unsubscribe whenever you like.