Café QR

Import Customers from Your Old POS in Pakistan

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

  1. In your dashboard, open Customers.
  2. Tap Import customers.
  3. Under Upload your file, drop the file on the box or tap Choose.
  4. 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.
  5. 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.
  6. 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

ColumnNotes
Name, or first name and last nameJoined into one name.
PhoneNeeded. A 0 that Excel removed from the front is put back.
EmailLeft blank if it isn't a real email address.
BirthdayThe day and month are kept, not the year.
TagsUp to 8, separated by commas or semicolons.
NotesUp to 500 characters.
Offers by WhatsApp, text or emailYes, no or blank. See "Offers and consent".
Points, stamps, full cards waitingSee "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.

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.

Articles

Step-by-step guides

Search the help centre →

Still stuck?

Ask us, and we’ll walk you through it.

Tell us about your venue and we’ll reply, usually within one working day, to plan your setup or show you round the till on a call. It’s an enquiry only: no card, no subscription and no trial started.

An enquiry only. No card or subscription required

We use these details to respond to your enquiry. Read our privacy notice.

One month free

Run your restaurant on Café QR.

Rs 4,999 per restaurant, per month after the trial, billed in PKR. No setup fee and no commission on your orders.

Start free trial →

Optional analytics and ad cookies. Privacy