Duplicate cleanup

Duplicate cleanup


A landscaping company uses Bigin to keep track of their customers and prospects. They add details of the people who have expressed interest in their services to their contacts module, whether through inquiries on their website, referrals from customers, or people they've met at expos and events.
 
However, because they're adding so many contacts each day through different sources, sometimes the same contact gets added twice. Let's say one of the sales representatives of the landscaping company has added a few contacts they received as referrals. The same contacts have already filled out the webform on the company's website, and now they're added again to Bigin without the representative realizing that these contacts were already in the system. 

As a result, the business ends up with duplicate records in their Bigin account, which can cause problems such as:
  1. Inconsistent data. 
  2. Wasted time and effort as different employees communicate with the same contact.
  3. Inconsistent communication, which can create confusion and make the business look unprofessional.
  4. Missed opportunities for the business.
To address these problems, Bigin has a de-duplicating feature called "Duplicates Cleanup" for the Contacts and Companies modules. You can identify the duplicates in your database by regularly reviewing the data in these modules based on certain conditions and merging duplicate records together using this feature.

Availability

  1. Duplicates Cleanup is available for Premier edition.
  2. Only administrators can access and use this feature.

To identify duplicate records:

  1. Log into your Bigin account with administrator privileges.
  2. Go to the Contacts/Companies module.
  3. Click the More icon at the top right. Select Duplicate Cleanup.
  4. Choose the fields to identify duplicates. Based on the fields you choose, Bigin will check all of the records in the module and identify records that have similar values. For example, if you choose "Mobile" as the field, Bigin will check for records with the same mobile number. You can choose up to three fields to identify duplicates and, of these three fields, two fields can be custom fields.

  5. Click the +Add Unique field button if you want to use other fields in the module as a factor to check the records.
  6. Click Find and Merge Duplicates.
  7. Once the de-duplication process is complete, the administrator will be notified on screen and via an email. The email will inform the administrator about details such as the number of duplicates, resolved duplicates, and unresolved duplicates. The administrator can resolve conflicts by opening the link that will directly open the page containing duplicates.  

  8. Once the system identifies the duplicates, it follows two different processes to merge the records. Say there are 1,000 records in your Bigin account; of these, 200 are duplicate records. Bigin does a check on those 200 records, and  categorizes them into two types. The two types of records are:

    Records without conflicts: Consider a set of three duplicate records with all fields containing similar values as the other two records. Bigin will consider them to be records with no conflicts and automatically merge those records into one record. 

    Records with conflicts: Consider another set of two duplicate records with different values in the Mobile field, which will result in conflict. Bigin won't merge them automatically; the administrator has to merge and resolve them manually.
    Even if other fields have the same value, the Duplicates Cleanup method won't combine them, and it will only do the match on the unique field that you want to check for. The user has to choose the record manually to resolve the conflict.


Once the duplicate cleanup process is completed, the user will receive a notification in the System Notifications section. This notification will be available for three days. Additionally, they will receive an email notification.


How can you avoid duplicates?  

You can utilize the "Unique Field" option to mark a field as unique, and this will prevent a duplication of records. The email address field is most commonly marked as a unique field because no two people can have the same email address.
 
So when the email field is marked unique and mandatory, duplication of records can be avoided. When a contact is added by the Bigin user, and if the same customer submits the webform from the webpage, the contact will not be added in Bigin.
Notes
  1. Administrators can run de-duplication as many times as they need. There is no limit. Every time a de-duplication is run, a new email will be sent. The link is valid for three days.
  2. If a deduplication is executed by selecting any old link within the '3' days for the same records, the other links will become invalid.
  3. Users will be able to run a de-duplication using the old link for a maximum of three days.
  4. Once you have specified the master record, all related lists of child records are moved to the master record.
  5. The record(s) merged to the master record will be deleted permanently and the action cannot be reverted.
  6. Read-only fields will not have radio buttons.


    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









                                            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

                                                                                                              • 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 ...
                                                                                                              • Managing Email

                                                                                                                Cleanup Policy As per our cleanup policy, IMAP sync will be paused under the following circumstances: If a user hasn't sent any IMAP emails and hasn't opened any IMAP emails for more than a month. If a user remains inactive for more than five months. ...
                                                                                                              • Integrating with Zoho Books

                                                                                                                The Zoho Books/Invoice integration for Bigin lets you sync contacts, companies, and products between Zoho Books or Zoho Invoice and Bigin. Zoho Books and Zoho Invoice users can also create and view invoices, estimates, and sales orders related to ...
                                                                                                              • Forms

                                                                                                                Overview Forms are an effective business tool that help small businesses gather a wide variety of details from customers. By using the form builder in Bigin, small businesses can create customized forms for lead generation, customer support, ...
                                                                                                              • Explore Settings

                                                                                                                Bigin has various functions which can be configured by administrators from the Settings menu. Access the Settings menu The Settings menu can be accessed by clicking the gear icon in the top right of your window. All the features and Configurations in ...
                                                                                                                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