Why do I have duplicate customers in QuickBooks Online?
While QuickBooks Online will not allow two customers to have the exact same customer name, if you encounter potential duplicate customer records in QuickBooks there are a couple of possibilities as to why.
Wrong Customer Matching Chosen
Customer chooses first name last name as the customer match. In QuickBooks, the customer is last name, first name. (screenshot of image)
Our software treats Joe Example and Example, Joe as different customers. We match the QuickBooks Desktop customer name field:
While they may technically be the same customer, because the formatting is different, QuickBooks treats these customer records are unique.
Mapping Billing or Shipping
Connex matches the billing address name or company to the QuickBooks customer name field.
From our configure page, you can choose shipping address first and last name or company: (needs screenshot)
If the email field is different in QuickBooks and the store and you selected billing email as the match, then Connex creates a new customer under first name last name.
Add Link to if new customer, then map to web store.