Quickbooks Commerce Customer Linking

Quickbooks Commerce Customer Linking

When Extensiv Integration Manager loads orders into Quickbooks Commerce , it attempts to find an already existing customer to link the order to. If no matching customer is found, a new customer record is created. The following logic explains how Integration Manager searches for Customers in Quickbooks Commerce when attempting to match them.

As soon as a match is found, the Customer is used and the remaining searches are not performed. If multiple matches are found in a specific step, the first match provided by Quickbooks Commerce is selected.

Normal Matching


1) Customer ID - Integration Manager first checks if there was a customer ID provided by the order source. If so, it searches for an exact ID match. If one is found, that customer is used. If not, Integration Manager will continue searching using the methods below.
2) Company or Customer Name Search - Integration Manager searches for existing Customers with the same Company (if provided) and Billing Name (if not). (Uses Customer/Billing record if provided, Shipping record if not)
  1. Email or Phone must also match
3) Email Search - Integration Manager searches for existing Customer with the same email. (Uses Billing record if provided, Shipping if not)
4) Phone Search - Integration Manager searches for existing Customer with the same email. (Uses Billing record if provided, Shipping if not)

 Strict Matching

1) Customer ID - Integration Manager first checks if there was a customer ID provided by the order source. If so, it searches for an exact ID match. If one is found, that customer is used. If not, Integration Manager will continue searching using the methods below.
2) Company or Customer Name Search - Integration Manager searches for existing Customers with the same Company (if provided) and Billing Name (if not). (Uses Customer/Billing record if provided, Shipping record if not)
  1. Email or Phone must also match
3) Email & Phone Search - Integration Manager searches for existing Customer with the same email and phone. (Uses Billing record if provided, Shipping if not)

The only guaranteed way to ensure the customer you want is always selected, is to pass a Customer ID.
Quickbooks Commerce does not perform any automatic Customer matching which is why Integration Manager attempts to perform this matching.

You can manually override the Billing address for all orders in Integration Manager if you would like them to all load under the same Customer record in Quickbooks Commerce . To do so, set the Overwrite Customer Info option at the bottom of the Cart settings in Integration Manager to Overwrite Billing and enter your desired customer record information.

Within a Customer record, Quickbooks Commerce is responsible for managing contacts and addresses. Integration Manager passes all the name and address information to Quickbooks Commerce, who then decides whether to create a new record or re-use an existing one under that customer.

    • Related Articles

    • Quickbooks Commerce OMS Order Settings

      When Quickbooks Commerce is selected as your Extensiv Integration Manager WMS, there will be Quickbooks Commerce specific settings to set for each cart connection in Integration Manager. These settings are listed and explained below: Quickbooks ...

    • Quickbooks Commerce OMS Integration Overview

      is now Inventory and order management software for modern merchants. All of your inventory, orders and customers managed and accounted for in one place. Website: https://www.tradegecko.com/ Supported functions Order Send Inventory Sync Pickup ...

    • Quickbooks Commerce OMS Tax Settings

      This article covers the tax options available when sending orders through Extensiv Integration Manager to Quickbooks Commerce . These options are all configurable per order source. You will find these settings in the Integration Manager Carts tab by ...

    • Quickbooks Commerce OMS - The access token was revoked

      Problem All interfaces to your Quickbooks Commerce account are failing with the message: The access token was revoked Solution This can happen for several reasons if a change in Quickbooks Commerce removes Extensiv Integration Manager's access to ...

    • Vend POS to Quickbooks Commerce OMS Integration

      Extensiv Integration Manager integrates the Vend POS and Quickbooks Commerce systems very tightly for a seamless data flow keeping both systems in sync. With this setup: Vend acts as the frontend POS system that can be used from many retail locations ...