How do I avoid creating duplicate records while importing?

How do I avoid creating duplicate records while importing?

While importing records, you can identify the duplicate records based on a unique field for each type of record. These are the fields for each type of record based on which you can check for duplicates:

  • Leads - Email
  • Contacts - Email
  • Accounts - Account Name
  • Deals - Deal Name
  • Cases - Subject
  • Solutions - Title
  • Campaigns - Campaign Name
  • Vendors - Vendor Name
  • Products - Product Name

Scenario:

You do not use any of the fields mentioned above and want to update a list of records with additional details. While importing a file with those updated records, you want to check for duplicates.

In such cases, you can use the Record ID to check for duplicate records. Each record in Zoho CRM has a unique ID. When you export these records, you get their individual Record IDs. Follow these steps to check for duplicate records while importing:

  1. Export the records that you wish to update. The exported file will include the Record IDs.
  2. Make the necessary changes to the records in the file.
  3. Import the file in Zoho CRM using the Overwrite option.
  • Duplicates will be checked based on the record IDs.
  • When a duplicate record is found in Zoho CRM, it will be overwritten with the data in the import file.
  • Only the mapped fields will be overwritten.
  • If the Record ID field is not mapped, new records will not be created.







    • Related Articles

    • How do I import accounts with new data without creating duplicate records?

      In Zoho CRM, users of the Enterprise Edition and above can use the Overwrite option while importing records. This option helps you overwrite records in CRM with similar records that you might import. You can also use the  'Duplicate Records' option, ...

    • Merging Duplicate Records

      When you work with a significant volume of data, it gets quite challenging to keep your database free from duplicates. As the avenues to create records in CRM increase, the chances of duplicate entries increase as well. For example, the same lead may ...

    • Creating Candidate Records

      Methods There are multiple ways for creating candidate records in Zoho Recruit, namely; Entering data in the candidate details form: You can manually fill in the Candidate details gathered from various external sources, e.g. trade shows, exhibitions, ...

    • Importing Data to Zoho CRM

      Data can be gathered through various sources such as, purchasing a record database, collecting from trade shows and campaigns, and so on. Importing records from such external sources to Zoho CRM is one of the most important lead creation activities ...

    • Importing leads from Evernote

      Zoho MarketingHub lets you to import contacts from different cloud storage services. You can import contacts stored in Evernote as leads in Zoho MarketingHub. The file to be imported should met the following requirements, It should be in either Excel ...