How to Resolve Duplicate Contacts

How to Resolve Duplicate Contacts

Aside from taking up space in your database, duplicates may get updated independently of one another. Duplicate records can be resolved by merging records together. This preserves the information on both records and compiles it into one comprehensive record.

If you notice duplicates, do not simply delete one of the records. This could result in data loss!
 
The user will need the permissions to View/Edit/Delete All Contacts, and Resolve Duplicate Contacts to access and merge duplicates via the Suspected Duplicates dashlet on the Dashboard.

The user will need the minimum permissions to View/Edit/Delete Own Contacts and Resolve Duplicate Contacts to merge duplicates via the Resolve Duplicates command under Special Editing in the Contacts area.

Automatic duplicate detection

Sumac automatically detects suspected duplicate contacts and displays a count on the Dashboard. 



Clicking the number on the suspected duplicates tile opens the suspected duplicates window.



From this screen you can choose to:
  1. Review each instance of suspected duplicates
  2. Ignore the suspected duplicate
  3. Select and merge the suspected duplicates



Suspected duplicates that are ignored will be remembered by Sumac and will be excluded from future results.
The Deduplicate auto search will pause every time 100 instances of suspected duplicates have been found.

Manual duplicate detection

Your Sumac administrator can also manually trigger the system to restart the suspected duplicates scan by going to Utilities > Customize Database > Preferences > Contacts Tab, and clicking the Reset Button next to the "Review Duplicates Last Contact ID Checked" box:



This will run the next time you launch Sumac. When completed, the Dashboard will be updated and duplicates can be resolved following the steps outlined above.

If you expand the newly merged record you will see that all related contact information, communications, donations, etc. are now attached to the single donor record.





    Our products got an upgrade!



    Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!


      • Related Articles

      • How to add new Contacts

        To add a new contact to your Sumac database, click Contacts in the main Sumac console window then click New. In the window that opens, enter some basic information about the new contact. You need to first specify whether you are adding a new ...
      • How to Import Contacts

        Regardless of the type or source, you can import contacts into your Sumac database. In this example, we'll import new contacts. Before importing your spreadsheet, it is important to clean up the data. Use Sumac's Import Workspace to do this. Only ...
      • Can I archive contacts in Sumac?

        If you are running out of space in your contact list, and need to remove some old, inactive contacts to make more room, you have two options: 1) Archive the data in spreadsheets, then remove data from Sumac Perhaps once a year, you could export the ...
      • Using Search Builder to find all contacts who might be linked to the same membership record

        When trying to find contacts who have memberships matching assorted criteria, you can use Search Builder to find contacts who are listed in the Member field, or the Member 2, 3, 4, 5, 6 or Billing Contact fields of their corresponding membership ...
      • Contacts Window Overview

        To open the contacts area, click on Contacts in the menu. In the list view, you will see records for donors, volunteers, staff members, organizations, or a household. Contact history Additional and related information like communications, donations, ...
      Societ Academy

      Learn what you need to know, any time. Free!



      • High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
      • Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
      • A certificate of completion - you can request a certificate of completion for every session you attend.