Prompt Library for Small Businessby Small Business Control Center · free
Money and pricingReview or audit something Check the numbersAbout 12 minutes

Which product categories make money in my shop

Rank your categories by margin and turnover and decide where to put your space and your money.

Useful for: Shops and online sellers.

  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 a retail consultant. Write in English. 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 which product categories pay their way and which just take up space. My categories (name, monthly sales, purchase cost, average stock): [CATEGORIES] Space each one takes up: [SPACE, e.g. in shelf feet or percentage of the shop] Give me: 1) gross margin and turnover by category, with the formulas; 2) margin crossed with turnover in 4 groups, with what to do in each; 3) which categories take up more space than they deserve; 4) 3 specific decisions for next quarter; 5) which indicators to track every month. Don’t make up industry data or typical margins. If information is missing, ask me before analyzing.
Fill in the gaps on this page
Example of what to write: Stationery: $2,400 sales, $1,400 cost, $3,000 stock, 30% of shelf space | Gifts: $1,800, $800, $5,000, 40%.

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.