Export your past orders with the customer, product, quantity and date, work out each customer's usual reorder gap, list those due in the next three weeks, and have AI draft a short reminder with a ready re-quote. Take the price from your own estimating sheet, then read and approve each email before it goes.
The reason this works for a print shop is that repeat work is predictable. A business that ordered 500 leaflets in March and again in September will probably want them again, and a short, specific message with a price attached is easier to say yes to than a generic newsletter. What goes wrong is automation without checking: an email that quotes last year's paper price, or reminds a customer who left on bad terms. So the routine below keeps the owner in the loop at the points where it matters.
Step 1: get your order history into one flat table
You need one row per order line, not per invoice. Pull it from your print management system, accounting package or, in a small shop, the spreadsheet of job tickets. The columns that matter:
| Column | Why it matters |
|---|---|
| Customer name and contact person | The email has to go to a person, not to "accounts" |
| Customer email and whether they agreed to be contacted | Only email people you are allowed to email |
| Product (for example 100gsm leaflets, A5, full colour, both sides) | The reminder names the exact job |
| Quantity and finishing (folded, stapled, laminated) | The re-quote must match the last job unless they ask for a change |
| Order date and delivery date | To calculate the gap between orders |
| Price charged and your cost | For the re-quote and for a sanity check against current costs |
| Artwork file name or job number | So the reply can say "same artwork, no changes" |
| Notes (late payer, complained, wants to be left alone) | The flag that stops an email going to the wrong person |
A tidy table is half the job. If your data is messy (customer names spelled three ways, products typed freehand), clean it first; the guide to cleaning messy data shows how to do that with AI help. For a first pass it is enough to cover your top 50 customers by revenue.
Step 2: find who is due, with simple sums
You do not need AI to calculate this and it is better if you do not use it. A spreadsheet is more reliable for dates and averages. For each customer and product:
- Sort orders by date and calculate the days between each order and the previous one.
- Take the typical gap (the median is better than the average if one gap was unusual).
- Add the typical gap to the last order date to get the likely next order date.
- Filter for those where that date falls in the next 21 days, or has just passed.
An illustration. A tutoring centre orders 300 term-start flyers every September, January and April, so the median gap is about 120 days. The last order was 2 September. The next likely date is around 31 December, so the January flyers are due to be reminded on about 9 December. A yoga studio orders 1,000 postcards a year but unpredictably, with gaps of 70, 200 and 95 days. The median is 95, so the reminder goes out around day 75 from the last order, and you accept it will sometimes be early. You can see why the gap is a guide, not a promise.
Add a "do not contact" column and a "last reminded" column so nobody gets emailed twice in a month.

The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowStep 3: write the reminder with AI, using real details
Now the AI earns its place. Give it the facts from the row and your style, and ask for a short email. Use a business plan or a plan with training switched off if your customer data includes names and emails. ChatGPT Business and Claude Team do not train on business content by default; both need at least two seats, at $25 a seat monthly or $20 on annual billing for the standard seat as of November 2026. On the individual plans you can switch training off in the privacy settings. Paste only what the email needs: first name, product, last order date and the quote figure.
Write a short email from a print shop owner to a regular customer.
Tone: friendly, plain, no hype, no exclamation marks.
Facts: first name [first name]; last order 500 A5 leaflets, 130gsm gloss, full colour both sides, folded to DL, ordered on 14 March;
price then $212; new price $226 for the same job (paper cost rise); turnaround 4 working days from artwork approval; same artwork on file.
Ask: do they want the same again, or any changes?
Length under 110 words. Subject line under 50 characters. Do not invent offers or deadlines.
An illustrative result:
Subject: Your A5 leaflets, ready to reprint?
Hi [first name], it was six months in March since we printed your 500 folded A5 leaflets, so I wondered whether you were running low. We still have the artwork on file. The same job, 130gsm gloss, full colour both sides, folded to DL, would be $226 now, up from $212 because paper has gone up, and takes four working days from your approval. Want the same again, or any changes to the text or quantity? Just reply and I will send the proof. Best, [your name]
What you would fix in that sample: the first sentence is clumsy ("it was six months in March"), so rewrite it as "It is about six months since we printed your leaflets". Check "six months" against the order date. Check "up from $212 because paper has gone up", which is the sort of explanation a model may add if you did not give it; if paper really has risen, it is a good line, and if you do not know why the price changed, delete it. A customer who sees an unexplained rise is more likely to shop around than one who sees a one-line reason.
Step 4: build re-quote templates for the common cases
Most reminders will fall into a handful of types. Write each one once with placeholders, let AI polish them, and keep them in a shared document. A re-quote that arrives within minutes of a reply wins the job more often than one that arrives next day.
- Same again, same price. Short: the job, the price, the turnaround, "reply YES to go ahead".
- Same again, price up. As above plus one honest line on the reason, and an option that brings the price back down (a thinner stock, a smaller run, a different finish).
- Quantity change. Show two or three quantities side by side, since print pricing falls per unit as volume rises.
- Annual or seasonal job. Reminder timed to the customer's planning date, with a note that you can hold artwork and paper.
- Lapsed customer. No order in more than twice their usual gap; a lighter message that asks if anything has changed, with no price pressure.
An illustrative quantity table the AI can format for you, after you supply the numbers from your estimating sheet:
| Quantity | Price | Price per leaflet |
|---|---|---|
| 250 | $146 | $0.58 |
| 500 | $226 | $0.45 |
| 1,000 | $318 | $0.32 |
Those prices are made up for the example. Use your own, and check the division yourself: $226 divided by 500 is $0.452, rounded to $0.45. Never ask a model to do the arithmetic you will send to a customer, as why AI is bad at maths explains.
Step 5: keep the price honest
The price is the one field AI must not decide. Three ways to keep it reliable:
- Single source. Prices come from your estimating sheet or print software for that product and quantity. If you are weighing options, the estimating software comparison shows what each costs.
- Cost drift check. Before sending, compare each re-quote with the last price. If the change is more than a threshold you set (say 8 percent), flag it for the owner to look at.
- Expiry. Put "price held until [date]" in every quote, usually 14 or 30 days, so a stale quote cannot come back at an old price three months later.
A realistic mistake: a shop reuses last year's template, which still says "$198 for 500", because the model copied the number from the example in the prompt. That is why the prompt above supplies the price, and why the owner reads the figure against the sheet before sending.
Step 6: the approval queue
The routine should end with a person, not with a send button. A practical queue for a small shop:
- The spreadsheet filter produces this week's list (typically 5 to 20 customers).
- For each, AI drafts the email from the row. Paste it into a draft in your email program, or a shared document with one section per customer.
- The owner reads each in under a minute against a short checklist.
- Approved drafts are sent from the owner's own email address, not from a mass mailer, so replies come to a person.
- The "last reminded" column is updated.
REPEAT-ORDER EMAIL CHECK
[ ] Right person and email address; not on the do-not-contact list
[ ] Product, size, stock and quantity match the last job
[ ] Price matches today's estimate, and any rise is explained or removed
[ ] Turnaround is achievable with this week's workload
[ ] No offers or deadlines I did not agree
[ ] Reads like me; one clear question at the end
[ ] Last-reminded date updated in the sheet
If you are nervous about quality at first, run the first two weeks in shadow mode: draft the emails, compare them with what you would have written yourself, and send only your own versions. The shadow-mode tutorial explains the method. Then move to approving AI drafts with edits, and only later think about anything more automatic, which most small print shops will not need.
A worked example: a six-person print shop, one month
An illustration with invented figures. A commercial printer has 140 active business customers and takes about 90 orders a month. The owner exports two years of order lines (1,900 rows), cleans customer names for an hour, and builds the gap sheet in an afternoon.
- Week 1. The sheet shows 31 customers with a likely order in the next 21 days. The owner removes 6 (two in dispute over a reprint, three who have not replied in a year, one who has closed).
- Weeks 1 to 2. 25 drafts are written with AI in about 40 minutes. The owner edits 9 and rewrites 2. Time to read and fix: about 50 minutes.
- Replies. 11 customers reply within a week, 8 order, and 3 ask for a different quantity. The re-quotes for those three are sent within the hour using the quantity template.
- Result. Eight repeat orders from 25 reminders. If the average order is $240 (illustrative), that is $1,920 of work, against a few hours of owner time and a chatbot subscription of $20 to $50 a month. Note that some of those eight might have ordered anyway; the honest comparison is with the same weeks in earlier months.
The point of the example is not the 32 percent response rate, which is made up. It is that the routine takes about two hours a week, and the owner can measure its own figures after a month.
The lapsed customer: a different email, with an example
A customer who is overdue by more than twice their usual gap needs a different message from one who is simply due. They may have moved to another printer, changed their marketing, or been let down on the last job. The email should not push a price. It should ask, and make replying easy.
Write a short, warm email from a print shop owner to a customer who has not ordered for 14 months. Their usual gap was about 5 months.
Last job: 1,000 business cards, 400gsm matt, spot UV on the logo. They were always prompt payers.
Do not mention a discount. Do not guess why they stopped. Ask whether anything has changed, offer to check the artwork is current, and say I can quote in an hour.
Under 90 words.
An illustrative output would be a three-sentence note that says you noticed it had been a while since the business cards, asks whether the details on the card have changed, and offers a quick quote. What you would fix: any line such as "we miss you" that sounds like a mass mailer, and any claim like "most customers reorder every year", which the model may add as filler. Delete invented statistics. If the customer was let down last time (check your notes), do not send this at all; call them.
A calendar for the year, so reminders are not an afterthought
Print demand follows other businesses' calendars. Once you have two years of data, you can pin the main repeat jobs to a rough yearly timetable and send reminders on a schedule instead of hunting for them each week. An illustrative shop might use something like this:
| Customer type | Typical job | Remind roughly |
|---|---|---|
| Tutoring centre | Term-start flyers and timetables | 3 weeks before each term |
| Landscaping company | Spring door-hangers and van signage updates | Late winter, then early autumn for leaf-clearance leaflets |
| Yoga studio | Class schedule cards and new-year membership postcards | Early December for January starts |
| Local clubs and events | Programmes, tickets, banners | 8 to 10 weeks before the event |
| Offices and shops | Stationery, menus, price lists | When their last stock is likely half gone |
Put the dates in the same spreadsheet as a "next reminder" column. Ask the AI to turn your two years of history into a list of the five customers you would most regret losing, ranked by revenue and regularity; then check the ranking against what you know of them. The tool is good at sorting a table, and you are good at knowing who is about to be difficult.
Handling the replies quickly
The reminder is only the start; replies decide whether it pays. Four habits help:
- Answer within the hour during working hours. Re-quote requests go cold quickly. Keep the quantity-table template ready and fill it from the estimating sheet.
- Let AI draft the reply, not decide it. Paste the customer's message and your price, and ask for a two-line response. Check that it answers the question they asked.
- Confirm in writing. A "yes" reply should be followed by a short confirmation: job description, price, artwork version, delivery date. This is what you refer to if there is a dispute later.
- Record the outcome. Ordered, declined, asked for a change, or no reply. Declines with a reason are the most valuable data you collect, since they tell you if the price or the timing is the problem.
An illustrative reply draft: the customer writes "Can we do 750 instead?" The AI draft says "Yes, 750 is $272 with the same turnaround; I will send the proof as soon as you confirm." You check $272 against the sheet (the figure you supplied), and send. Without the figure in the prompt, a model may quote a number it makes up, which is exactly the mistake the approval step is there to catch.
Business customers and consumers
Most print-shop repeat orders come from other businesses, and a reminder tied to a job you did for them is usually welcome. Consumers (wedding stationery, family calendars, club T-shirts) are different: the repeat is less predictable, and rules on marketing messages can be stricter. If you sell to both, keep two lists with different tones and different consent records, and check the rules that apply to the people you are emailing. Whatever the audience, every email should carry your business name and a clear way to say "stop".
Measuring whether reminders bring orders back
Track five numbers in the same spreadsheet: reminders sent, replies, orders, revenue from those orders, and unsubscribes or complaints. Compare reorder rates for customers you reminded with similar customers you did not (for example, remind alternate customers for the first month if you have enough). If replies are good but orders low, your price or turnaround is the issue. If there are few replies, test the subject line and the day you send. If anyone complains, stop and read their message before you do anything else.
Where repeat-order emails go wrong
- Emailing someone you should not. A customer in dispute, a late payer, or someone who asked to be left alone. The do-not-contact column exists for this.
- Wrong job details. The AI blends two jobs and the email names the wrong stock. Paste one job at a time, and check the stock against the ticket.
- Mismatched artwork. A reminder says "same artwork" but the customer rebranded. Ask, do not assume.
- Too many emails. A reminder and a second nudge is enough. After that, a phone call from a person does more.
- Data in the wrong place. Do not paste the whole customer list into a free chatbot. Paste only the fields one email needs, and follow the privacy points in the disclosure guide if customers ask how you use their information.
Repeat orders are also where artwork and proofs matter again; once a customer says yes, proof approvals and status updates keep the job moving. If you would rather set the whole routine up with someone looking at your own data, that is what my AI implementation consultation covers.
Repeat-order reminders for a print shop
How far ahead of the likely reorder date should I email?
Start with two to three weeks before the date a customer usually runs out, based on their last gap between orders. Add a short second nudge a week later if there is no reply. Seasonal jobs such as event programmes or calendars should be timed to the customer's planning cycle, not yours.
Can AI work out the new price?
Not reliably. Let it write the email and format the quote, but take the price from your estimating sheet or print software. Paper, ink and postage costs move, and a model that guesses a number will sometimes guess one that loses you money.
Do I need permission to send reminder emails?
Marketing email rules vary by place and by whether the customer is a business or a consumer. A reminder about a product someone has already bought from you is often treated differently from a general promotion, but check the rules that apply to your customers and always include a clear way to opt out.
Should the emails say they were written by AI?
A routine reminder you have read and approved does not need a label. What matters is that it is accurate, in your voice and sent by a real person. If you add a chatbot that answers customers directly, tell them it is automated.
Further reads
- Following Up Silent Quotes With AI: A Decorator's Playbook — Following up quotes that nobody has answered.
- How Barbers Can Win Back Lapsed Clients With Automated Messages — Win-back messages for lapsed regulars, another small-business view.
- ChatGPT for Screen Printing Shops: Quotes, Art Prep and Customer Emails — Quotes and art prep for a garment printer.
- Web-to-Print Software: Online Storefronts, Instant Quotes and AI — Let repeat customers reorder online themselves.
- Print Production Scheduling Software: Where AI Actually Helps — Smooth the workload that repeat orders create.
- How to Set Up Human Review for AI Work Without Slowing Down — Keep human review quick as the volume grows.
- Sign Company Marketing: Case Studies and B2B Emails With AI — A job sheet, case-study prompt, consent email, local page test and three outreach emails a sign company can use this month.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: general practice for order-history reminders and quoting; OpenAI's ChatGPT Business pricing page and Claude's pricing page for plan costs and training defaults, checked 4 November 2026; no product claims beyond those pages.