Merge duplicate customers
The same customer is in twice. How do I join the two records?
- For
- Admins and accounts
- Where to find it
- SidebarCustomerspossible duplicates
- Takes
- 2 minutes a pair
- You need
- Permission to edit customers
What it is for
Duplicates split a customer's history and quietly defeat credit control: a hold on one record does nothing about the other. Merging moves everything onto the record you keep, and old links still work.
After this you can
- Find likely duplicates
- Choose which record survives
- Merge them
Step by step
- 1
Open the duplicates
On Customers, click the possible duplicates line at the top.
- 2
Check each pair
Choose which record to keep.
- 3
Read the counts
It lists the quotes, jobs, invoices, contacts and addresses that will move. Choose which name and account number survive.
- 4
Merge
Type the surviving customer's name to confirm.
What is on this screen
| Part | What it does |
|---|---|
| Possible duplicates banner (Customers list) | The pairs Sign OS thinks are the same. |
| Which record to keep, which name and account number survive | Everything else moves to it. |
| Counts of what will move, type the surviving name, Merge | Quotes, jobs, invoices, contacts and addresses that will move, and the confirmation. |
Tips
Both email addresses and both phone numbers are kept. The second of each becomes a contact on the same customer.
You are only asked about things a customer can have one of, like the name or the account number.
Watch out
Merging cannot be undone.
Check the counts before you confirm. Forty-seven quotes against a record you thought was empty means you have the wrong pair.
If either record is on hold, the merged record stays on hold.
