Duplicate Cleaner

Duplicate Cleaner is a SuiteCRM add-on that allows you to set up rules to find duplicate data in your SuiteCRM and helps you eliminate duplicates manually or automatically by our cleaner process. It supports multiple numbers of duplicate detection rules that you can configure from the admin.

Includes a 30 day guarantee

Try it Now

User Guide

Navigate to module “Duplicate Cleaner” and click “Create Duplicate Cleaner”.

Module: Select module on which duplicates record will be checked.
Auto Process: Allows system to automatically merge the duplicate records and delete them. If this field is not checked then the system finds the duplicate records but the user has to manually merge the records. The duplicates records are stored into the module "Duplicates".
Merge Fields: The selected fields will be merged into the primary record. These fields are considered for the automatic merge only. It also available when Auto Process is checked.
Merge Relational Data: Copy the relationship data to the primary record. It is available when Auto Process is checked.
Primary Record Field: Identify the primary record on Date Created or Date modified field.
Primary Record Order: Choose the date order (Older/Newer) to decide the primary record.
Duplicate Cleaner Rules: Conditions on which duplicate records will be checked.AND operator will be applied between the selected condition.

Based on the previous step Duplicate Cleaner record look like as follows.

Based on Duplicate Cleaner record we have created into the last step system has the duplicate record as follows. We want to find the duplicate records from the system which has the same Email Address and Phone and Billing City is Ahmedabad.

We have selected Date Created as Primary Record field with the Ascending order into the Duplicate Cleaner record. Based on that first record is the primary record and the second record is the duplicate record. When Duplicate Cleaner scheduler will be executed at that time second record will be deleted from the system and all the values along with the relationships from it will be copied into the first(Primary) record.

Relationship data into the duplicate record.

In the Duplicate Cleaner record we have selected the Auto Process. To allow the system to automatically merge the duplicate records we must have to set the scheduler as follows.

Duplicate Cleaner Scheduler record into CRM.

After cron is executed duplicate record will be removed from the system and merge into the primary record. Following is the primary record after merged.

Duplicate Cleaner result after cron is executed.

Duplicate Cleaner also allows the Manual Merge. For that, we have to uncheck the Auto Process checkbox.

Now when cron is executed at that time duplicate record is found but it does not merge automatically. The duplicate records will be listed in the module Duplicates as follows. We have to click on the Manage Duplicate icon to merge them.

Manual Merge Screen

Saving Comment...