Ms. Lan has been drinking coffee at the café for almost two years. In the café's customer list she has three profiles: "Ms. Lan" saved the first time, "Lan" created when a cashier mistyped one digit, and another one from the time she booked a table with her husband's number. Her loyalty points are split across three places, so she has never moved up a tier. The reports count her as three customers, two of them "new" customers who came once and never returned. Duplicate customers do not cost the café money right away, but they distort every number the café uses to decide whom to look after.
Why duplicates appear in the customer list
Duplicate profiles are almost never the customer's fault; they come from how the shop records them. The five most common sources:
| Cause | Example | How to prevent it |
|---|---|---|
| Mistyped phone number | Two digits swapped when the customer reads quickly at a busy time | Read the last three digits back to the customer |
| Customer has two numbers or changes number | One work number, one personal number | Ask "which number do you usually collect points with?" |
| Someone else books on their behalf | A husband books the table, a child books an appointment for their mother | Note the actual guest's name on the booking |
| Saving customers with only a name | "Mr. Tuan table 5", no number | Do not create a profile until you have a phone number |
| Re-importing an old list from Excel | The old customer book includes customers already saved in the system | Read the rows flagged as duplicates carefully before importing |

Signs that a customer is duplicated
- Two profiles with nearly the same name and numbers that differ by one or two digits. This is the typo kind, the easiest to find when the list is sorted by name.
- A customer asks "why do I have so few points?". Usually the points are sitting in the other profile.
- Reports show more new customers, but the counter sees no new faces. Some of those "new customers" are regulars who got an extra profile.
- A customer who comes often never reaches a higher membership tier. Their spending is split across several profiles, so no single profile reaches the threshold.
How to merge without losing history
Deleting the extra profile is the fastest and also the worst option: that profile's purchase history and points disappear with it. What you need to do is merge. In the Ordersys CRM, when you merge two profiles of the same customer, the purchase history and loyalty points move to the profile that is kept. Before you click, take three steps:
- Choose the profile to keep. Keep the profile with the phone number the customer currently uses, because that is the number they will give next time.
- Ask the customer one question. Next time they visit, ask "are this number and that number both yours?". One confirming question avoids merging two different people by mistake.
- Be careful with shared numbers. Couples or sisters sometimes share one number. They are two real customers with different tastes; do not merge them just because the number matches.
You do not need to clean the whole list in one go. Each week, have one person spend about ten minutes checking, starting with high-spending customers, because mistakes in this group distort the reports the most.
Prevent duplicates right at the counter
Merging is the cure; the phone number is what prevents duplicates in the first place. Ordersys already has two duplicate checks based on phone number: when importing customers from a file, rows whose number already exists in the system are flagged; when a table is booked with a number that already belongs to another customer, the software also warns that the number is in use. The rest is counter habits:
- Ask for the phone number first, search for the customer by number, and only create a new profile if none is found.
- Do not save customers with only a name. Without a number, just sell as normal; there is no need to create a profile yet.
- When a customer says they changed numbers, update the number on the old profile instead of creating a new one.
A clean customer list does not need to be big; it just needs one row per person. Only then do the numbers for returning customers, lapsed customers and VIP customers reflect the shop accurately. Customer profiles that bring together purchase history from the store, the website and social media, along with loyalty points and customer segmentation, are part of the Ordersys CRM software. Shops can try it free for 7 days.
Read more: Asking for the customer's phone number at checkout · Segmenting VIP customers to give offers to the right people.
Ordersys has editions for restaurants and for retail stores: checkout, stock, reports and e-invoices, with on-site setup and training.
Other news
Sales software for household businesses that fits the new rules
From 2026 household businesses no longer pay presumptive tax and declare based on actual revenue; stores with revenue of 1 billion VND/year or more selling directly to consumers must use e-invoices generated from cash registers. This guide summarises the regulatory milestones that affect retail stores and what sales software must do: record every order, issue e-invoices, report by period, keep purchase records and track debts.
Scan a QR code to order at the table: guests order for themselves, the restaurant needs fewer staff
When guests scan a QR code to order at the table, handing out menus, taking orders, running tickets to the kitchen and answering "where is our food?" move to the guest. This guide separates what guests do themselves, what staff still have to do, how to rearrange shifts by table zone, and where things slip when the restaurant runs with fewer people.
Ordering software for wedding banquet restaurants: serving many tables at once without the bill going wrong
A thirty-table wedding banquet usually goes wrong on the extras: drinks added mid-party, tables set up at the last minute, dishes sent to the kitchen twice, deposits remembered by word of mouth. This guide puts the whole banquet into one order from a multi-table booking or by merging tables, takes extra orders by phone, sends only new items to the kitchen, and settles with the host using a provisional bill, surcharges and automatic deposit deduction.
Complete coffee shop management software: how ordering, checkout, inventory and reports connect
Complete coffee shop management software is not a long feature list but ordering, checkout, inventory and reports working together: ring up one cup and the money goes into the right shift, ingredients are deducted by recipe and the end-of-day report updates itself. The article follows one cup through four stages, shows four common break points and the order to switch things on.
Billiards management software for a small new club: what to set up before opening day
For a new billiards club with five to ten tables, where the owner works the counter and starts the clocks, the software needs to do a few things right: set up tables, hourly rates, the menu and QR codes before opening; let players order drinks themselves and have table lights follow playing time; use camera highlights to get the club known; and after the first month read reports by table, debts and shift close.
Retail order management software: counter sales and online orders in one place
Counter orders, phone and Zalo orders, and orders from the store's web shop all go into one order book in Ordersys. Each online order moves through five clear statuses, delivery requires the address, delivery time and delivery person, customers track their own order, and there is no adding up two places at the end of the day.
Spa and hair removal appointment software with no double bookings
Hair removal sessions are short, tightly packed and crowded into one machine room, so they clash easily. Each Ordersys appointment records the time, duration, room/bed and therapist; on save the software checks for room clashes, therapist clashes and therapists busy in the spa, adds bed turnover time, and shows exactly which booking is holding the slot.
QR table ordering software for restaurants and eateries
One round of QR ordering in Ordersys goes through five steps: the guest scans the code on the table, picks dishes with options and notes, sends the order (with or without a confirmation step), the kitchen and bar receive it, and the guest reopens the page to check the order and order more. Plus a list of what to set up before putting codes on tables.
Ordersys or KiotViet? A Straight Comparison to Choose Right
An honest Ordersys vs KiotViet comparison by real needs: retail, services, billiards, QR ordering, automatic payment — choose right, not the wrong fit.