Locate and Merge Duplicate Customer:Job

By |2021-07-09T01:28:02-05:00March 22nd, 2018|Comments Off on Locate and Merge Duplicate Customer:Job


This topic will teach you how to locate duplicate contacts. This form is usually used to locate duplicates that you wish to merge together (using the merge duplicate tool).


Use this form to merge information associated with two or more contacts into one contact.

Sometimes user will realize they have been maintaining two contacts that are actually the same. This may happen when you enter a customer for the first time; not realizing that they were already in Total Office Manager. This utility works by moving all information from one contact to another. This includes contact info, notes, logs, invoices, sales, credits, estimates, work orders, scheduling, checks, and more.

Basically here is how you merge contacts. You will search for duplicates using the Find Duplicate form. You will then select a customer to merge others into. This is called the “target” contact. You will then select the contacts that have information you wish to move. These are called the “source” contacts.

Important Warnings

  • This process cannot be reversed. Be careful!

  • Make a backup of your database prior to using this tool.

  • If security is not turned on in Total Office Manager, anyone can use this tool and that is NOT recommended. Turn on security. Doing so will insure that only the administrator will have access to this form.

  • When merging contacts that have complex financial information, carefully check your financial statements to be sure you have not created problems. If there is trouble, you can usually correct it. If not, you can restore your backup.

Form Access

The Merge Contacts form may only be accessed from the Locate\Merge Duplicate Customer:Job form. When security is turned on, only the administrator can use this tool.

  • From the main menu, click Tools | Utilities | Locate | Merge Duplicate Customer:Job

  • On the Customer:Job List, select two (2) or more Customer:Jobs, right-click and select “Merge Contacts”.

Field Definitions

Merge Selected Into Select the contact that the information will be merged into. This is the target. You can only select one at a time but you can do multiple merges. Note: When selected, this contacts is no longer available in the Merge Selected From list.
Merge Selected From Select one or more contacts that the information will be merged from. This is the source.
Delete After Merge Select this option if you wish to delete the contacts that have had their information moved from. This refers to the source contact (the one that has the info you want to move).
Make Inactive After Merge Select this option if you wish to inactivate the contacts that have had their information moved from.  You can always delete them later. This refers to the source contact (the one that has the info you want to move).
Do Nothing Select this option if you wish to keep the contacts that have had their information moved from. This refers to the source contact (the one that has the info you want to move). This is usually not a good choice.
Show Inactive Check this box to show contacts even if they have been inactivated. Display inactive contacts.
Merge Contact Info Check this option if you wish to copy the address information from the source to the target. This is a good option if the source has the most current contact info.
Merge (button) Click this button to perform the actual merge. It’s recommended that you do a backup first!


  1.  Be sure that you have a good backup before you use this tool.
  2. The first step is to search for the duplicates using the Find Duplicate utility.
  3. Once duplicates are located, click the Merge Duplicate button. The Merge Contacts form will open.
  4. At the top of the form, select the contact you wish to merge other contacts into.
  5. On the lower potion of the form (the source list), this contact becomes bold and you will not be able to select it (for obvious reasons).
  6. Check each contact that you wish to move information from. You do this by checking the small box on the left side of each contact.
  7. Select an option indicating what you wish to happen to contacts once their information has been moved. We recommend that you inactivate them. Later, when you are sure everything is ok, you can delete them.
  8. Click the Merge button when you are ready to do the merge.


  • When security is turned on (in Preferences), only the Administrator can use this tool. That’s is because generally users should not be allowed to merge contacts.
  • This form does not close when you click the merge button. You can perform multiple merges.
  • If you discover duplicates using another form (like the customer:job list), you may consider adding something in the contact or address 2 field (like XXXX) to help you located them later with this form.

Related Topics

Post Data Migration Duplicate Customers

Tips – Preventing Duplicate Names

Copy Customer – Customer Moved

Share This Story, Choose Your Platform!

About the Author:

HVAC Electrical Plumbing Software

Aptora delivers a true All-In-One services software solution including CRM, accounting, payroll, inventory, vendors, sales, marketing, dispatch, flat rate pricing, and more. NO 3rd party plugins or integrations required. Created by contractors for contractors, we know what it takes to grow your services-based businesses.


Sign-up to get the latest news and update information. Don’t worry, we won’t send spam!

Thank you for your message. It has been sent.
There was an error trying to send your message. Please try again later.
Go to Top