I Have Duplicate Customers — How Do I Fix It?
Over time, duplicate customer records sneak in: someone is added once as “Bob Smith”, once as “Robert Smith”, once as “Smith Bob” with a typo. Each duplicate has its own slice of history, balance, and notes — making the customer’s full picture hard to see.
JewelTrak has a tool for this: Utilities → Consolidate Customers.
Most clients don’t know this exists. It’s the most common support call we get about contacts. You don’t need to ask — you can fix it yourself.
What it does
Pick a primary contact (the one you want to keep) and one or more secondary contacts (the duplicates). The tool:
- Re-points every transaction (invoices, payments, memos, repairs, appraisals, store credits, gift cards) on the secondaries to the primary.
- Combines balances and history into the primary.
- Marks the secondaries as merged so they no longer appear in pickers.
The primary keeps its own contact details (name, phone, address). If the secondary had better details, edit the primary after merging.
Two ways to find duplicates
The page has two tabs:
Manual
Search and pick contacts yourself. Use this when you already know the duplicates — for example, a customer just told you they have two records.
- Search for the primary (the one you want to keep) and click to select it.
- Search for one or more secondary contacts and add them.
- Review the merge preview, confirm, done.
Candidates
Lets the system suggest likely duplicates by matching on name + phone or name + email. Walk down the list — for each pair, either confirm the merge or dismiss if they’re actually different people.
Dismissed pairs stay dismissed (the system remembers and won’t surface them again).
What’s safe to merge
- Same person, two records → safe.
- Spouse / household members who share an address but are distinct people → don’t merge. Keep them separate; their purchase histories should not pool.
- Business and the person who works there → judgment call. If you always invoice the business, merge into the business record. If the person ever buys personally, keep them separate.
What can’t be undone
Merging is not reversible through the UI. Take a moment to review the preview screen before confirming. If you discover after the fact that you merged the wrong pair, restoring requires support.
Tip — preventing duplicates going forward
When creating a new customer at the till, the customer search box does fuzzy matching across name + phone + email. Take an extra second to glance at suggestions before clicking + New — most duplicates are created when staff are in a hurry and skip the suggestion list.