Duplicate Clients in CRM: How to Find and Merge Them
A client called from a different number, left a request on your website, and a second sales rep added them all over again — now the CRM has two cards. Deals are scattered, the call history is split, and reports count one client twice. Let's look at how emyCRM keeps duplicates from appearing and how to merge them if they're already there.
Contents
Where duplicates come from — and where the CRM already catches them
- An incoming call finds the card by the last digits of the number: “+380 67 123-45-67” and “380671234567” are the same client. An unknown number creates a lead, and a repeat call goes to that same lead.
- A messenger message looks for a contact, a company and an open lead by the number, and only then creates a new lead.
- A website request with the same phone number or email lands as a note in the open lead instead of creating a second one.
- Import from Excel skips rows that are already in the CRM, as well as repeats within the file itself.
What's left are the duplicates people create: a sales rep didn't find the client by search and added them again, or two departments each keep the same company on their own. How to load your database without repeats is covered in our article on importing clients from Excel.
A warning when you create a card
When a phone number is typed into the new contact form, the CRM checks it against the database and shows “This number is already in the CRM:” under the field, with links to the cards it found. You can still create the contact — the hint doesn't block anything, but one look is usually enough. The mobile app shows the same “Already in the CRM:” warning when you create a lead or a contact.
How to find duplicates in your database
There's no separate duplicate search across the whole database yet, but searching the lists finds repeats quickly. In companies, search looks at the name, legal name, tax ID, phone number and email, and a phone number is found in any format — five digits in a row are enough. Sort the list by name or tax ID, and similar cards will end up next to each other.
How to merge companies
- Open “Companies” and tick the checkboxes next to two or more cards of the same client.
- In the action bar, choose “Merge.”
- In the “Merge companies” window, mark the main card — it stays, and the others will be deleted.
- Check the fields: by default, the main card's values are used, and empty ones are filled in from the other cards. You can keep all phone numbers, emails and websites.
- Look at the “Will move to the main card” block and click “Merge.”
Everything moves to the main card: deals, invoices, leads, contacts, tasks, activity feed entries, calls, emails, company details and custom fields. Repeats aren't doubled — the same call or contact stays as a single copy. A “Merged from: …” entry appears in the feed with the name of whoever did the merge.
Who can merge
To merge, you need permission to edit the main card and to delete the others. Sales reps can't delete by default, so the administrator does the merging — or someone they give the permission to in the role settings. More in our article on CRM roles and permissions.
Where to start
- Agree with your team: before creating a client, search for them by phone number.
- Go through the company list sorted by name and mark the obvious repeats.
- Merge two or three cards at a time, checking the main card and the fields.
- If different departments handle a client, link their cards instead of merging them.
How the client card works and why it matters to have just one is explained in our article on the client card in CRM.
How does the CRM know a client is already there?
What happens to deals when you merge?
Can a merge be undone?
Can I merge contacts or leads?
Who can merge cards?
One card per client — the whole history in one place
14 days free on the “Standard” plan. No card required.