How to find and merge duplicates in Bitrix24 CRM (Year 2014)

10 min read
Vlad Kovalskiy
August 26, 2014
Last updated: May 5, 2023
How to find and merge duplicates in Bitrix24 CRM (Year 2014)
For updated information about duplicate control in Bitrix24 CRM, please read our Helpdesk article.


In March 2014 we added duplicate control to Bitrix24 CRM, alerting users that lead, contact or company they are trying to add to their database may already exist. This summer we expanded this feature to include searching and merging duplicate entries that can be performed at any time, not just data entry.

5a6461eb51c11c7da6baf59b876fb68c.png

This is how it works.

Creating an index


Duplicate search is available for three CRM entities – leads, contacts and companies. You start by selecting a CRM entity that you want to search for duplicates and create index for it. After the index has been created, all you have to do is click the gear icon in the upper right corner and select Duplicate control, which is the last item in the drop down list.

445610ba95ec7d8f78b09c2a49b09d4a.png


Searching for duplicates


You will see a small duplicate search form appear right above your leads, contacts or companies. There are three boxes – Full name/Company name, email and telephone that you can search for duplicates, either individually or all of them simultaneously.

215dcfd37bab674b58f4aab02076f67d.png


Duplicate search and CRM access rights


Bitrix24 CRM comes with flexible access rights. This usually means that multiple managers work with CRM, each having access only to his or hear leads, contacts or clients. Each manager is able to perform duplicate search, however if a duplicate entry is found among CRM entities assigned to another manager that the first manager has no access rights to, entity merging will not be available, meaning each manager can only merge entities that he or she is responsible for. CRM administrator, however, will be able to merge duplicates regardless of the fact that such entities have been assigned to different mangers.


Duplicate merger


So, now you are ready to merge duplicate entries. IMPORTANT! You can not reverse or undo duplicate entry merger right now, so this operation should be performed only by a person who understands the process and what information and access rights will be lost/altered as the result of the merger. We do plan to add merger history later on, which will provide a detailed log of changes and an option restore CRM entity elements, if necessary.

When merging duplicate entities, our CRM first determines which lead, contact or company will be primary entity and which ones will be secondary and thus deleted after the merger is complete.

When determining primary entity, the following factors are considered:

  • Citation index. Citation index is calculated based on how often CRM manager has worked with this entity and how many connection this entity has with other CRM elements such as deals, activities, quotes and invoices. The more entity is connected and worked with, the higher its citation index.
  • Date. CRM entity with more recent changes is ranked higher than the one where no recent changes have been made.
  • Profile. Profiles with more information filled in are ranked higher than profile with fewer records.
  • Access rights. Access rights determine the order in which entities are displayed. Entities with view-only rights will be displayed at the bottom.
5a6461eb51c11c7da6baf59b876fb68c.png

So you’ve generated a list of likely duplicates for a particular entity. You’ll see several columns with entity fields that have been used to determine that these entities are duplicates – like same name, email address or phone number.

If another manager is responsible for that entity, you are given an opportunity to contact that manger via calling or sending message to alert him or her of the fact that a duplicate entry exists, that you are about to merge all duplicate entries into one and ask if there’s any important information than needs to be saved.

85fa360e89d001b0f06ad5ffb6fd3379.png

If you want to see a full profile for the entity in question, you can simply click it. If you determine that a particular entity is not a duplicate entry, you should click ‘Skip’ and it will be deleted from the list and not used for a merger.

If you determine that the entities in the list are in fact duplicates that should be merged, click ‘Merge’.

18a724e0adda3823b1760c21464ea47d.png


Merger completed


Again, it’s worth reminding that you can not undo or cancel merger in the current version of Bitrix24 CRM. After you’ve merged entities, access rights to the final entity might be changed, and information, such as history, activity stream or product catalog associated with the deleted secondary entities, will no longer be available.

Manager who had access rights to the primary entity will inherit these rights after the merger is completed. Managers who had access rights to secondary entities, but not the primary one, will not have access rights to the merged leads, contacts or companies. If a merger results in access rights loss by one or more managers, you will see a warning beforehand.

Connections to deals, tasks, quotes and invoices will be changed too. If these were associated with a secondary entity that was deleted, they will no be connected to the primary entity. However, events from the activity stream of the secondary entity, such as creating a deal or an invoice, will not be added to the primary entity.

After you’ve search for duplicates and merged them, your managers will still be adding new information to CRM, which means that it’s still possible to have duplicate entries in the future. If you click ‘Update list’, the system will search for duplicates again, showing you if any new duplicates have appeared in your database:

43c4432d588764e938cf8dbcdf83efc0.png

Within a few months we plan to add duplicate and merger history page, which will not only show you which entities have been merged, but also undo mergers with entities that have been done mistakenly.


FAQ



Why is management of duplicate records important in CRM?

It is important in CRM because having multiple records for a single lead or contact can cause confusion and lead to inefficiency in communication and sales processes. It's important to have all the information related to a client located in a single record.

What is the duplicate control option in Bitrix24 CRM?

The duplicate control option in Bitrix24 CRM can automatically find and merge duplicate leads, contacts and companies. 

How can users access the duplicate control option in Bitrix24 CRM?

To access the duplicate control option in Bitrix24 CRM, users should go to the Contacts, Companies or Leads section, click the gear button, and select Duplicate control.

Can users perform duplicate control on all records in Bitrix24 CRM?

No, each sales manager can only perform duplicate control for their own records and those they have access to. Duplicate control won't be available if users don't have access permissions to update and delete records.

How can users merge duplicates automatically in Bitrix24 CRM?

Users can click the Merge duplicates automatically button after the scan is complete. Duplicates without conflicts will be merged automatically.

Most Popular
Enhancing Email Efficiency with Bitrix24 CoPilot Mail Assistant
Bitrix24 - A Game-Changer for Nonprofits - A Success Story from Teamexpansion
Bitrix24 CoPilot: Crafting Beautiful & Engaging Websites Made Easy
New Bitrix24 Helpdesk Channel on YouTube
New BI Builder In Bitrix24 CRM
Table of Content
Creating an index Searching for duplicates Duplicate search and CRM access rights Duplicate merger Merger completed FAQ Why is management of duplicate records important in CRM? What is the duplicate control option in Bitrix24 CRM? How can users access the duplicate control option in Bitrix24 CRM? Can users perform duplicate control on all records in Bitrix24 CRM? How can users merge duplicates automatically in Bitrix24 CRM?
You may also like
articles
webinars
glossary

Free. Unlimited. Online.

Bitrix24 is a place where everyone can communicate, collaborate on tasks and projects, manage clients and do much more.

Start for free