When connecting multiple systems together QuickBooks Connector has the ability to match pre-existing data without creating duplicates.
Contacts
QuickBooks Connector uses quite a complex algorithm to match contacts across different systems, however, the main criteria are as follows:
- Company Name
- First Name
- Last Name
- Phone Number
As a first step, we will pull contact data from the connected systems into QuickBooks Connector and check if any contact names match up by reading the first name, and last name in the Display Name field. Then, we look at these contacts' emails to confirm they're a match. If the emails don't match, we won't match them. If one or more of the contacts don't have an email, we'll try to match via phone number. If the phone numbers don't match, we won't match them.
Please note that we can't handle any existing duplicates. For example, if you have a repeat customer who creates a new login account for every purchase, we will treat every new account as a separate contact. We can't merge existing duplicates.
Products
QuickBooks Connector matches products by matching the SKU field or Name field in QuickBooks Online to the e-commerce SKU field.
Invoices
Invoices are matched using Invoice Number
Comments
1 comment
Not enough information provided on how this works in practive. For example, what is the relationship between Contacts and Organisations. Is the matching done at the Contact level or the Organisation level (i.e. does it check the password given in the Organisation record, or just the Contact record)?
Please sign in to leave a comment.