How to Merge Lead, Contact, & Company (Client/Vendor) Records
Setup | Merge Lead Records | Merge Contact Records | Merge Company Records
Do you need to merge duplicate leads, contacts, and company (client and vendor) records in Workamajig?
If these records were used for financial or project transactions, this would prevent them from being deleted, but you can still merge them.
Important notes:
- There is no undo to this action, so be careful to select the correct records.
- Contact records that have been converted to full users or employee records that have been converted to contact records cannot be merged. You must deactivate the record to hide it. You can also add '-old' to the end of the name prior to deactivation to provide clarity between the records within the database.
- Client/Vendor Company Records: The 'Is A Client/Vendor' and 'Client/Vendor ID' fields will be cleared if the 'Primary Merge To' record is not a Client/Vendor. You will need to update the new company record with this information after the merge.
How the merge process works
- If a field contains data in one record and is blank in the other record(s), the new record will include the data.
- If a field contains data in all records, the new record will contain the data the 'Primary/Merge To' record. The Primary record is selected based upon the oldest edited record or the newest edited record. The Primary and the replica(s) may show the same date, however, the last edited field includes a non-displayed timestamp so there is a clear oldest/newest record.
Setup
The following security rights are necessary to merge lead, contact, or company records
Menu>Admin/Manager>System Setup>Account Information: Security Settings
>Contact Management section
- Merge Contacts
- Merge Companies
- Merge Leads
Access to the Leads, Contacts and Companies screen must also be allowed.
Merge Lead Records
Menu>Salesperson>Leads
From the Leads screen>click ...more
click REMOVE LEAD DUPLICATES
Select the Matching Criteria>SEARCH
NOTE: The criteria will only provide "EQUAL TO" results for the selected fields. Select First Name and Last Name to ensure you will be searching for all "John Smith" and not just all "John" records. If you add in Company Name, then the search would be John Smith, ABC Company. If there are no duplicate matches, then no results will be displayed. You are not able to actually select specific names, etc. to search by. The system is simply looking for a field match.
From the results displayed on the right, click on the line to display the detail records that will be merged
All records will be auto-selected and a MERGE INTO line will identify the "Primary" record. At this point you are able to deselect any records that should not be included in the merge process. You are also able to select whether the Oldest or Newest record will be set as the "Primary" Merge Into record.
Click Merge Selected Detail Rows to begin the merging process.
Merge Contact Records
Menu>Salesperson>Contacts
From the Contacts screen>click ...more
click REMOVE CONTACT DUPLICATES
Select the Matching Criteria>SEARCH
NOTE: The criteria will only provide "EQUAL TO" results for the selected fields. Select First Name and Last Name to ensure you will be searching for all "John Smith" and not just all "John" records. If you add in Company Name, then the search would be John Smith, ABC Company. If there are no duplicate matches, then no results will be displayed. You are not able to actually select specific names, etc. to search by. The system is simply looking for a field match.
From the results displayed on the right, click on the line to display the detail records that will be merged
All records will be auto-selected and a MERGE INTO line will identify the "Primary" record. At this point you are able to deselect any records that should not be included in the merge process. You are also able to select whether the Oldest or Newest record will be set as the "Primary" Merge Into record.
Click Merge Selected Detail Rows to begin the merging process.
Merge Company Records
Menu>Salesperson>Companies
From the Contacts screen>click ...more
click REMOVE COMPANY DUPLICATES
Select the Matching Criteria>SEARCH
NOTE: The criteria will only provide "EQUAL TO" results for the selected fields. Select Company Name and Phone or Address 1 to ensure you will be searching for all "ABC Company, 111 East St" and not just all "ABC Company" records. If there are no duplicate matches, then no results will be displayed. You are not able to actually select specific company names, etc. to search by. The system is simply looking for a field match.
From the results displayed on the right, click on the line to display the detail records that will be merged
All records will be auto-selected and a MERGE INTO line will identify the "Primary record. At this point you are able to deselect any records that should not be included in the merge process. You are also able to select whether the Oldest or Newest record will be set as the "Primary" Merge Into record.
Click Merge Selected Detail Rows to begin the merging process.
