How to Fix Duplicate Contacts and Companies in Bigin?
What Does This Guide Cover? (Quick Summary)
Duplicate records waste time, split customer history, and distort reports. Bigin by Zoho CRM offers tools to prevent duplicates and to merge the ones you already have. This guide explains why duplicates appear, how to find and merge them, and how to undo a bad import. It also shows how to block new duplicates with unique fields and how to handle duplicates from integrations and the API. Follow these steps to restore one clean record per customer.
| Item | Detail |
|---|---|
| Goal | Keep one record for each contact and company |
| Prevention | The “Do not allow duplicate values” field setting |
| Cleanup | Find & Merge Duplicates and Duplicates Cleanup |
| Merge limit | Up to three records at a time in Find & Merge |
| Safety step | Export your data before you merge |
Why Do Duplicate Contacts and Companies Cause Problems?
Zoho’s documentation describes the damage clearly. A database with duplicates does not give you easy access to the complete communication log with a customer, wastes sales reps’ time, and generates inaccurate reports that affect business decisions. In practice, one rep emails the “John Smith” record while another logs a call on a second “John Smith,” and nobody sees the full story.
Duplicate companies create a similar mess. Deals, contacts, and notes scatter across several versions of the same business. Therefore, your pipeline totals and activity counts drift away from reality.
What Causes Duplicates in Bigin?
Most duplicates come from a handful of sources:
- Manual entry: Two people add the same customer on the same day.
- Repeated imports: Someone uploads the same file twice.
- Spelling variations: “Acme Inc.” and “Acme Incorporated” look different to the system.
- Integrations: A sync tool creates records that already exist.
- Email capture: A new address creates a second contact for the same person.
How Do You Spot Duplicates Quickly?
Sort your Contacts or Companies list by email, phone, or name, and scan for repeated values. Also search for common company names and check how many records appear. This quick audit tells you how large the problem is before you start.
How Do You Prevent Duplicates Before You Clean Them?
Cleaning without prevention means you will clean again next month. Bigin offers a proactive setting that stops duplicates at the source.
How Do You Block Duplicate Values in a Field?
The “Do not allow duplicate values” checkbox in a field’s settings prevents duplicate records from being created. Once you enable it, Bigin refuses a new record with the same field value. For example, if you enable it for the Email field in Contacts, two contacts cannot share one email address.
To enable it, follow these steps:
- Log in to Bigin with admin privileges.
- Go to Settings, then Fields, and select the module.
- Click the edit icon on the field you want to protect.
- Select “Do not allow duplicate values.”
- Click Save.
Zoho notes that this option is not available for the Activities module.
Which Fields Make Good Unique Keys?
Pick fields that identify a record reliably.
| Module | Good Unique Field | Reason |
|---|---|---|
| Contacts | Most people use one primary address | |
| Contacts | Mobile | Useful when email is missing |
| Companies | Website or domain | Stays consistent across name variations |
| Companies | Phone | Works when the website is blank |
Avoid names as unique keys. Many people share names, and the same company can appear under several spellings.
What Should You Check Before You Enable the Setting?
Enabling the setting does not remove existing duplicates, so clean first when you can. Also warn your team, because the setting blocks a save when a value already exists. Explain that they should search for the existing record and update it instead.
How Do You Find and Merge Duplicate Records in Bigin?
If duplicates already sit in your database, use Find & Merge Duplicates. Zoho calls this the reactive solution. It works in two stages: you find duplicates by one or more field values, and you then pick a master record and merge the details from the others into it.
Step 1: How Do You Find the Duplicates?
Open the Contacts or Companies module and click a record. On the Details page, click the more icon and choose Find & Merge Duplicates. Then set the search criteria and click Search. Bigin lists the matching records so you can identify true duplicates.
Step 2: How Do You Select Records to Merge?
In the Merge section, select the records you want to combine and click Next. Bigin merges a maximum of three records at a time, so work in small groups when you face larger clusters. Review each group carefully, because lookalike names can belong to different people.
Step 3: How Do You Choose the Master Record?
Select the record that will serve as the master. The master record stays in your database, while Bigin permanently deletes the other records after the merge. Choose the record with the most complete history, the best data, or the oldest creation date.
Step 4: How Do You Decide Which Values Survive?
Click Select All to keep all of the master record’s values. Alternatively, use the radio buttons to take specific field values from the other records. For example, you can keep the master’s name but take a newer phone number from a duplicate.
Step 5: How Do You Complete the Merge?
Click Merge. Bigin combines the selected values into the master record. It also merges the related records of the duplicates, including attachments, notes, and activities, into the master. As a result, the full history ends up in one place.
What Should You Know About Automation During a Merge?
Merging triggers automation, and that surprises many teams. Zoho explains that automation actions set to run on edit execute when the master record is updated, and actions set to run on delete execute when Bigin deletes a duplicate. If a workflow sends an email when someone deletes a record, that email goes out during the merge.
How Do You Avoid Unwanted Triggers?
Review your workflows before a large cleanup. Pause any rule that sends emails or creates tasks on delete or edit. Then restore the rules after you finish. This precaution prevents confusing notifications to customers and staff.
Why Should You Back Up First?
Deleted duplicates do not return. Export your Contacts and Companies before a big merge, and store the file somewhere safe. A backup lets you recover a value you merged by mistake.
How Does the Duplicates Cleanup Feature Work?
Zoho also announced a Duplicates Cleanup feature for the Contacts and Companies modules. It scans the entire module instead of one record at a time. Check your account to confirm that your plan includes it, because Zoho rolls out features gradually.
How Do You Identify Duplicates in Bulk?
You choose the fields that define a duplicate, and Bigin scans every record for identical values. You can select up to three fields, and two of them can be custom fields. Use the Add Unique field button to include more fields.
How Does Bigin Handle Conflicts?
Bigin sorts duplicates into two groups. Records without conflicts have identical values across the fields, and Bigin merges them automatically into one record. Records with conflicts hold different values in some field, such as Mobile, so you review them yourself. This split saves time because the obvious duplicates disappear without effort.
Which Method Should You Use?
| Situation | Best Method |
|---|---|
| A few suspected duplicates | Find & Merge Duplicates on a record |
| Hundreds of duplicates | Duplicates Cleanup, if available |
| Duplicates from one bad import | Undo Import, if within limits |
| Ongoing prevention | Unique field setting |
How Do You Fix Duplicates Created by an Import?
Imports cause many duplicates, especially when someone uploads the same file twice. Bigin gives you a way to reverse a recent import.
How Do You Use Undo Import?
Go to Settings, then Data Administration, then Import, and open Import History. Find the import you want to revert and select Undo Import. Zoho lists important limits. Once you update data anywhere in Bigin, you cannot roll it back. You can undo only one import action, and only within 30 days of the import date.
What Should You Check After an Import?
Use Import History to review added, skipped, and updated counts. Zoho notes that these details stay available for seven days after the import. Check the numbers promptly, and compare them with your source file.
How Do You Link Contacts to Companies Correctly?
Poor linking creates duplicate companies because Bigin cannot match a contact to its company. Zoho recommends importing Company records first. Then import Contacts with an Account Name or ID that matches the companies you imported earlier. Finally, import Pipelines to associate them with companies and contacts.
How Do You Handle Duplicates from Integrations and the API?
Connected tools can create duplicates without anyone noticing.
How Do Integrations Treat Duplicates?
Some Zoho integrations let you choose a duplicate rule. For example, Zoho Invoice’s Bigin integration offers three options: clone, which keeps both records; overwrite, which replaces the existing record; and skip, which keeps the existing record and ignores the new one. Skip works best when you want to protect clean data.
How Does the API Prevent Duplicates?
Developers can use the upsert records API. It checks system-defined unique fields and user-defined fields that have “Do not allow duplicate values” enabled. It then updates a matching record or inserts a new one. Zoho states that each call handles a maximum of 100 records. If a developer specifies no duplicate check fields, the API checks system-defined fields first and then user-defined fields.
What Should Your Team Do Before Connecting a Tool?
Test the integration with a few records. Confirm which duplicate rule it applies to, and verify the result in Bigin. Then connect the full data set.
What Are the Best Practices for Keeping Bigin Data Clean?
Prevention and routine checks keep duplicates from returning.
What Habits Reduce Duplicates?
- Search before you create: Check for an existing record first.
- Standardize formats: Use one format for phone numbers and company names.
- Enable unique fields: Protect email and other key fields.
- Review imports: Read the import summary every time.
- Schedule cleanups: Run a duplicate check each quarter.
How Do You Train Your Team?
Write a one-page rule set and share it with everyone who adds records. Explain which fields identify a customer and who owns data quality. Bigin by Zoho CRM works best when the whole team follows the same habits, since one careless import can undo weeks of cleanup.
How Do You Respect Privacy During Cleanup?
Customer records contain personal data. Limit who can export, merge, and delete records, and follow privacy rules such as GDPR when you store backups.
How Can Solution for Guru Support Your Bigin Data Cleanup?
Large cleanups carry risk, especially when workflows, imports, and integrations interact. Solution for Guru is a CRM and software implementation consultancy that helps businesses audit their data, design unique-field rules, and run careful merges. Its specialists can also review your integrations and train your team on clean data habits. Expert help reduces the chance of accidental data loss.
What Are the Key Conclusions About Fixing Duplicates in Bigin?
Fix duplicates in two steps: clean what exists, then prevent new ones. Use Find & Merge Duplicates to combine records, and use Duplicates Cleanup for bulk work if your account includes it. Turn on “Do not allow duplicate values” for key fields, review imports, and choose safe duplicate rules in integrations.
Bigin by Zoho CRM gives small teams practical tools to keep one clear record for each customer. Back up your data before you merge, review automation, and schedule regular checks. Confirm current menus and limits in your account before you start, since Zoho updates the product often.
Frequently Asked Questions
Zoho’s documentation says Bigin permanently deletes the duplicate records after a merge, and it describes no undo option. Export your data first so you can restore a value if needed. Review the master record carefully before you click Merge.
Find & Merge Duplicates handles a maximum of three records at a time. For larger clusters, merge in rounds, or use the Duplicates Cleanup feature if your account includes it.
Open Import History under Settings, Data Administration, and Import, then select Undo Import for that import. Bigin limits this option: you can undo only one import within 30 days, and only if no one has updated that data since. If you miss the window, use Find & Merge Duplicates instead.
