Import Your Customers from Another Till
Bring your customer list into Café QR from your old till: upload a CSV or Excel file with phone numbers, loyalty points and offer choices.
Updated 12 November 2026
If you had customers on another till or loyalty app, you can bring them into Café QR so nobody starts again from zero. You upload one file, check what Café QR found in it, and import. Your customers keep their name, phone number, email, birthday, tags, notes, loyalty balance and their choice about offers.
Owners and managers can import customers, from the Customers page.
Before you start
- Export the list from your old till. Most tills have an export on their customers page. Choose CSV or Excel (.xlsx). An old .xls file or a PDF won't work: open it and save it as .xlsx or CSV first.
- Every customer needs a phone number. Café QR knows a customer by their phone number at the till, online and for loyalty. A row without one is left out.
- The first row must be the column names, such as Name, Phone and Email.
- Up to 5,000 customers in one file. Split a longer list into several files.
- Only your own customers. Don't import a list you bought or were given by someone else.
Import the file
- In your dashboard, open Customers.
- Tap Import customers.
- Under Upload your file, drop the file on the box or tap Choose.
- Under Check the columns, look at each column from your file and what Café QR will import it as. Change any that are wrong. Set a column to Don't import to leave it out.
- Under Check and import, read the numbers: how many customers are new, how many you already have, and how many rows are left out and why.
- Tick the boxes that apply (see below), then tap Import customers.
If you don't have a file yet, tap Download a blank template to get one with the right column names to fill in.
What Café QR reads
| Column | Notes |
|---|---|
| Name, or first name and last name | Joined into one name. |
| Phone | Needed. A 0 that Excel removed from the front is put back. |
| Left blank if it isn't a real email address. | |
| Birthday | The day and month are kept, not the year. |
| Tags | Up to 8, separated by commas or semicolons. |
| Notes | Up to 500 characters. |
| Offers by WhatsApp, text or email | Yes, no or blank. See "Offers and consent". |
| Points, stamps, full cards waiting | See "Loyalty balances". |
Total spent, number of orders and last visit are not imported. Café QR works these out from the orders you take with it.
Café QR recognises the column names most tills use. If it doesn't know one, it asks the help assistant what the name means. Only the column names are sent, never your customers' details.
Customers you already have
A customer whose phone number is already in Café QR is not added twice. Only their empty details are filled in. A name, email, birthday or note you already hold is never replaced, and tags from the file are added to their own.
This means you can import the same file again safely, for example if your connection dropped part of the way through.
Offers and consent
You may only send offers to people who agreed to them. So Café QR is careful here:
- Yes in the file switches offers on for that customer only if you tick These customers agreed to get offers from us. Tick it only if that is true.
- No or Unsubscribed in the file keeps offers off for that customer.
- Blank leaves offers off.
- A choice a customer already made in Café QR is never changed by a file.
Texts are for UK cafés only, so a "yes" to texts is ignored elsewhere.
Loyalty balances
Tick Bring over loyalty balances to give customers the points, stamps and full cards from your file.
- A customer who already has a loyalty balance in Café QR keeps it unchanged. Importing a file twice never doubles anyone's points.
- Stamps need a stamp card. Set one up first under Customers, then the Loyalty tab, or stamps are left out. A card can't arrive full: put full cards in the Full cards waiting column instead.
- Imported customers don't get your welcome stamps or welcome message. They didn't just join.
Every import is recorded in your activity log with the number of customers, so you can see who brought a list in and when.