Job 5 of 16 · Outline

Use your till data to order smarter and waste less

The problem

Unsold bakes and milk are money in the bin. Looking at what actually sells on which day helps you order less and sell out more.

What AI does

AI works through your own till sales and waste notes to show what sells on each day and where waste is highest, then suggests starting quantities for next week. You adjust for weather, holidays and local events, and the order is your decision.

Time

Time: 20 minutes a weekTools: Square, ChatGPT, Google Sheets

The steps, in short

  1. Export a few weeks of item sales by day from your till.
  2. Add rough notes of what you prepared and what was thrown away.
  3. Have AI work out the patterns and suggest starting quantities.
  4. Adjust for what you know locally, then compare your waste after a couple of weeks.

A short sample prompt

Here are my café's daily item sales for [number] weeks and my notes on what I made and threw away. Show what sells on each weekday, where waste is highest, and a suggested starting amount for next week. Use only my data. Sales: [paste] Waste: [paste]

In the full playbook

  • 4 steps in full
  • The exact prompt to copy
  • A check-before-you-send list (3 points)
  • UK notes with official sources
The full playbook

Unlock all 16 cafés and coffee shops jobs

Every job has the full steps, the exact prompt, a check-before-you-send list and optional UK notes. We keep adding new jobs and new niches, and re-checking existing jobs, while you subscribe. Monthly, cancel anytime, instant access, no password.

Just cafés and coffee shops

£5 a month

Every job in cafés and coffee shops, including its agent playbooks, plus the updates we make to it.

Subscribe · £5/mo

3 niches

£12.99 a month

Starts with cafés and coffee shops; you pick the other two (or swap later) on your account page.

Subscribe · £12.99/mo

All niches

£19.99 a month

All 81 niches, and every new one we add. Or £149 a year: save £90.88.

Subscribe · £19.99/mo or £149 a year (save £90.88)

Cancel anytime. One click in Stripe's billing page, no emails or phone calls: how to cancel.

Pay securely with Stripe. Prices include any VAT. Digital content: at checkout you ask for instant access and agree you lose the 14-day right to cancel once it starts. Terms · Privacy · Pricing · Already subscribed? Sign in

More jobs for cafés and coffee shops

See all 16 jobs in the cafés and coffee shops playbook →