Find and merge duplicate records | Online Help - Bigin by Zoho CRM

Find and merge duplicate records

Duplicate records pose a significant problem when you work with large volumes of data. It is important to keep your database free from duplicates to ensure your business runs efficiently. A database containing duplicate records doesn't offer easy access to the complete communication log with a customer, wastes sales reps' time, and generates inaccurate reports which will affect business decisions. Bigin provides you with a proactive solution by preventing duplicates from entering your database and a reactive solution by merging existing duplicate records.
 

Avoid duplicate records

The Do not allow duplicate values checkbox in the field's settings prevents duplicate records from being created. Once a field has this option enabled, the system will not allow another record to be created with the same field value. For example, you have enabled this option for the Email field in the Contacts module. Now, you cannot create a record in the Contacts module with an email address that is already associated with another contact. There cannot be two records with the same email address.
 
To avoid duplicate records 
  1. Log in to Bigin with admin privileges.
  2. Go to Settings and then Fields and select the desired module.
  3. Go to the desired field and click the edit icon.
  4. Select Do not allow duplicate values.
  5. Click Save
Note: The Do not allow duplicate values option is not available for the Activities module.

Find duplicate records

If you have not enabled the Do not allow duplicate values checkbox for the Contacts or Companies module there is a risk that your database might contain duplicates. Bigin lets you find duplicates of a record and merge them into one record. This is a two-step process. First, you find the duplicates based on one or more field values and second, you select one of the duplicate records to be the master record and merge the details from other records into it. The master record is the record that will be retained and other records will be permanently deleted after merging. A maximum of three records can be merged at a time.  
 
To find duplicate records
  1. Go to the Contacts or Companies module.
  2. Click the desired record.
  3. In the Details page, click the more icon and then click Find & Merge Duplicates.
  4. Specify the criteria for finding duplicate records in the Search Criteria section.
  5. Click Search.
    The matching records will be listed so you can identify duplicate records.
  6. In the Merge section, select the records you want to merge.
  7. Click Next.
  8. Select the record that you want to set as the Master Record.
  9. Click Select All if you want to take all the master record's values as the final values and merge the duplicates. Or click the radio buttons next to the fields for other records to take those values as final values and merge the duplicates.
  10. Click Merge.
    All selected values from the duplicate records will be merged with the master record. All the related records of the duplicates (Attachments, Notes, and Activities) will be merged with the master record. 

Note:
Find and merge lets you merge duplicate records into a single master record and delete the duplicate records. The record which is retained is considered the master record and the deleted records as duplicate records. Automation actions that are triggered on Edit will be executed when the master record is updated and automation actions that are triggered on Delete will be executed when the duplicate record is deleted. For instance, if you have a workflow rule that sends an email alert when a record is deleted then this workflow rule will be triggered when a duplicate record is deleted.

 

    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION





                          Quick Links Workflow Automation Data Collection
                          Web Forms Enterprise Begin Data Collection
                          Interactive Forms Workplace Data Collection App
                          CRM Forms Customer Service Accessible Forms
                          Digital Forms Marketing Forms for Small Business
                          HTML Forms Education Forms for Enterprise
                          Contact Forms E-commerce Forms for any business
                          Lead Generation Forms Healthcare Forms for Startups
                          Wordpress Forms Customer onboarding Order Forms for Small Business
                          No Code Forms Construction RSVP tool for holidays
                          Free Forms Travel
                          Prefill Forms Non-Profit

                          Intake Forms Legal
                          Mobile App
                          Form Designer HR
                          Mobile Forms
                          Card Forms Food Offline Forms
                          Assign Forms Photography
                          Mobile Forms Features
                          Translate Forms Real Estate Kiosk in Mobile Forms
                          Electronic Forms

                          Notification Emails for Forms Alternatives Security & Compliance
                          Holiday Forms Google Forms alternative  GDPR
                          Form to PDF Jotform alternative HIPAA Forms
                          Email Forms
                          Encrypted Forms
                          Embeddable Forms
                          Secure Forms
                          Drag and Drop form builder
                          WCAG


                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Search and sort records

                                                                                                                Search records A typical day in the life of a sales rep involves checking and replying to emails, making calls, following up with leads, and helping customers find what they want. They must also keep a record of all relevant information about each ...
                                                                                                              • Duplicate Management

                                                                                                                When a new record is submitted through Bigin forms, the system checks for duplicates based on unique field data. You can configure how the system should handle duplicate submissions within the form submission rules. If your form includes a field ...
                                                                                                              • How to view product records?

                                                                                                                To view a product record 1. Open the Bigin app on your smartphone. 2. Navigate to the Products module. You can find all your product records listed here. Note: To display specific product records, tap the List View Dropdownat the top right of the ...
                                                                                                              • How to view product records?

                                                                                                                To view a product record 1. Open the Bigin app on your iPad. 2. Navigate to the Products module. You can find all your product records listed here. Note: To display specific product records, tap the List View Dropdownat the top left of the screen and ...
                                                                                                              • How to view product records?

                                                                                                                To view a product record 1. Open the Bigin app on your Mac. 2. Navigate to the Products module. You can find all your product records listed here. Note: To display specific product records, click the List View Dropdownat the top left of the screen ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources