When you have hundreds and thousands of records in your CRM, as your business grows, it becomes a very difficult task to check for duplicates. Zoho CRM helps you arrest duplicates even before they can be created, with the help of what we call "unique fields".
When you mark a field as unique, CRM will search existing records for duplicates based on that field's value. For example, assume that you have marked Email address as a unique field in the Leads module. When you try to create a lead whose Email address is the same as an existing lead, CRM will throw a duplication alert. Clearly, two people cannot have the same email ID. Other examples include Social Security Numbers, Passport Numbers, Product codes and the like. In Zoho CRM, you can mark a field from any module as "Unique". Once marked as "Unique", these fields play a vital role in managing duplicate records in Zoho CRM in various instances including manual creation of records as well as records created via import, APIs, lead/sales order/quote conversion.
The administrator or a user with the Customize Zoho CRM profile permission will be able to mark a field as unique. Once a field is marked as unique in a module, you will be able to arrest the creation of duplicate records in that module via manual creation, imports, integrations, web forms and so on.
Despite marking a field as unique, over time, if you find that there might be duplicate records in your account, you can use CRM's de-duplication tools to clear them up.
Mark a field as unique
Users with the Customize Zoho CRM permission in profile can enable this feature. All the Administrators will receive an email notification, when this feature is enabled or disabled. Please note that you need to enable it separately for the Leads and Contacts module. Once it is enabled, all the users can use it and they will be notified while adding a lead or a contact whose email address already exists in CRM.
Click on this link to know how to mark a field as unique and related notes: Mark a field as unique
- When you mark a field as unique in the Leads module, you will see an option to enable duplication check for converted leads as well.
Consider a scenario. You have followed up with and converted a lead called James. Now James is record in the Contacts module. Another sales rep in your team adds the same lead (James), without knowing that the lead has already been followed up with. In that case, there is no need for James to be added as a lead again - it will simply be a duplicate entry.
In this case, you can stop the creation of the same lead by enabling duplication check for converted leads. Once you have enabled this, whenever a duplicate entry is added in Leads, CRM will check existing leads as well as converted leads for matches.
To enable Duplication check for Converted Leads, click the Change Preference link, which appears when you mark a field as unique. In the Duplicate Check Preference popup, select the Check duplicates on converted Leads also checkbox and click Save. You can always change this setting later.
You can also enable duplication check from Setup > Customization > Modules and Fields > Leads. Click the More icon on Leads > Duplicate Check Preference.
- When a duplicate record is entered in the Leads module, an alert message will be generated stating about an existing record. By hovering the View Lead icon, one can view the record name and the owner. You can view the records details by clicking on the View Lead icon. The View Lead option will be available only if there is one duplicate record.
- If multiple records are found with the same email address then, an alert message will be displayed asking you to Merge the Leads. This option will allow you to find and merge the duplicate records. See Also: Merging Duplicate Records
There are different ways of adding a record in Zoho CRM. You can fill the lead/contact form, clone a record, use the web forms, import records, use API and use many other ways to add records. Below, you will find the various scenarios when email duplication check is performed.
- When a field has been marked as unique, it field cannot be removed from the module layout. Also, you cannot remove the section that contains the unique field.
- If the Zoho defined Email field is hidden, this feature will not be available.
Email address duplication check will not be performed in the following scenarios:
- Updating or adding records using Zoho Sheet View.
- During Data Migration.
- Restoring records from the Recycle Bin.
- Synchronizing contacts using Zoho CRM Plug-in for Microsoft Outlook, Google Contacts Sync features.