Open navigation

LXV | Client Deduplication

10 STEPS

1.  In this tutorial, we'll guide you through the process of merging duplicate contacts within Xero.

Step 1 image

2. The first step is to go to Contacts > All contacts.

Step 2 image

3. Search for the contacts to merge by entering their name or other relevant details.

Step 3 image

4. From the results, check the box next to the duplicate only.

Step 4 image

5. Click Merge.

Step 5 image

6. In the pop-up, search for the primary contact.

Step 6 image

7. Click the primary contact to confirm your selection and click Merge.

Step 7 image

8. Click Confirm merge.

Step 8 image

9. You'll get a notification that the contacts have been merged.

Step 9 image

10. That's it. You're done.

Thank you for your time.

Step 10 image

Here's an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/2499013/Xero---Merge-Contacts

11 STEPS

1.  In this tutorial, we'll guide you through the process of merging duplicate customers within Lightspeed.

Step 1 image

2. The first step is to open the Customers tab.

Step 2 image

3. Search for the customers to merge by entering their name or other relevant details.

Step 3 image

4. Ensure both customers to merge are visible on the screen at the same time so you can check both boxes. When searching, use contact details that appear in both records; in this example, the name was sufficient.

Step 4 image

5. Check the boxes beside the records to merge.

Step 5 image

6. Click Choose an action then Merge customers.

Step 6 image

7. Select the primary customer profile to keep.

Step 7 image

8. For the duplicate, select Merge and delete customer from the dropdown.

Step 8 image

9. Click Merge.

Step 9 image

10. You'll receive a notification confirming that sales have been transferred to the primary record and the duplicate has been deleted.

Step 10 image

11. That's it. You're done.

Thank you for your time.

Step 11 image

Here's an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/2499001/Lightspeed---Merge-Contacts

12 STEPS

1.  In this tutorial, we'll guide you through the process of merging duplicate contacts within the Vital platform.

Step 1 image

2. To access the deduplication tool, go to Setup > Data Management > Contacts.

Step 2 image

3. There are multiple attributes available in the Filter section. This will show any records that match on the selected criteria.

Step 3 image

4. Switch on different combinations of filters based on the criteria you want to check.

Step 4 image

5. Select 100 in Rows per page to display the maximum number of contacts at once.

Step 5 image

6. Click Check duplicates to display results.

Step 6 image

7. Find the contacts you want to merge and expand the row to view additional details.

Step 7 image

8. The first record in the list is selected as primary, but you can change this by clicking Set as primary.

Remember
to apply the Things to remember before merging in Vital section for guidance on which contact should be set as primary.

Step 8 image

9. You can edit the primary record’s data (such as phone numbers, email, etc.) to define what the final deduplicated record will look like.

Step 9 image

10. When ready, click Merge contact to combine the selected records into a single primary record. All associated records, such as jobs, quotes and invoices, will be transferred to the primary record.

Step 10 image

11. You'll receive a final prompt warning that all contacts, except the primary, will be deleted. Click Yes to proceed.

Step 11 image

12. That's it. You're done.

Thank you for your time.

Step 12 image

Here's an interactive tutorial

** Best experienced in Full Screen (click the icon in the top right corner before you begin) **

https://www.iorad.com/player/2498965/Vital---Merge-Contacts?iframeHash=trysteps-1

Learn how to streamline client records across Vital, Lightspeed, and Xero through deduplication.


Currently, there is no automatic integration for deduplication across Vital, Lightspeed, and Xero, so client records must be managed separately in each platform. This article provides step-by-step intruction for merging duplicates in each platform, ensuring your data stays accurate and consistent.


Step 1: Merging in Vital

It’s best to start your deduplication process in Vital. Vital includes a built-in deduplication tool, but the columns displayed in the tool are currently fixed. To make the process easier, open two tabs: one for the deduplication tool and another for your Contacts list. This allows you to cross-check the details of each contact in the tool with a more comprehensive view from the Contacts list. On the Contacts list, enable the Created Date column, which is also visible in the deduplication tool. This helps you verify and retain the correct record while merging duplicates.



Things to remember before merging in Vital

Before proceeding with deduplication, keep these key points in mind:

  1. If you merge a contact with a stored credit card into one without, the card details will be lost. Always check for stored credit cards and consider keeping the record with the card. Update it with the correct contact details and make it the primary contact.

  2. While jobs, quotes, and invoices transfer to the primary contact, only the primary contact’s details are kept. Ensure the primary contact has the correct info (e.g., notes, batching preferences) before merging to avoid losing important data.

  3. Pools will also transfer from the duplicate to the primary contact. If there are duplicate pools, merge them first.


View tutorial for detailed step by step 


For the best viewing experience, we recommend clicking on the full-screen icon below




Step 2: Merging in Lightspeed

Next, take the client data merged in Vital and search for the same clients in Lightspeed. Use the client ID from Vital to cross-check against the ID in Lightspeed, ensuring you're keeping the correct primary record.



View tutorial for detailed step by step 


For the best viewing experience, we recommend clicking on the full-screen icon below


Step 3: Merging in Xero

Finally, merge the same contacts in Xero. Keep in mind that only contacts with open transactions are synced to Xero, so some duplicates in Vital and Lightspeed may not appear as duplicates in Xero.


View tutorial for detailed step by step 


For the best viewing experience, we recommend clicking on the full-screen icon below



Tip:

Although optional, you can verify that the primary contact across systems corresponds to the same record. Start in Vital by clicking the Synced button to navigate to the corresponding record in Lightspeed. From Lightspeed, click on View on Xero to access the matching record in Xero.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.