Customer Mapping: Based on B2B Company Location Name

  • Pradip Ghanghar

Overview:

Our app syncs customers from Shopify to QuickBooks Online along with orders. During the setup process, you can choose how customers should be created and mapped in QuickBooks based on your business requirements.

If you are already using our app with a different customer mapping option, please let us know if you would like us to update the customer mapping settings for you as per the option below.

If you are on the Shopify Plus plan, you will see additional options for customer mapping, as shown in the image below:


Option 4: Map Customers by B2B Company Location Name

With this option, the B2B company location name from the Shopify order is synchronized with the Customer Display Name in QuickBooks.

This option is useful when you want to differentiate customers based on their business locations.


How It Works

When an order is synced from Shopify to QuickBooks:

  • The company location name provided in the Shopify order is used for mapping.

  • The app checks if a customer with the same display name already exists in QuickBooks.

If a match is found:

  • The existing QuickBooks customer is linked to the order.

If no match is found:

  • A new customer is created in QuickBooks using the company location name as the display name.


Example

  • Shopify order company location name: Lone Tree, CO

Scenario 1:
If a customer with the display name Lone Tree, CO already exists in QuickBooks:
→ That existing customer will be mapped to the order.

Scenario 2:
If no such customer exists in QuickBooks:
→ A new customer will be created with the display name Lone Tree, CO.


Important Notes

  • The mapping is exact-match based, so the company location name must match precisely.

  • Once a mapping is established, it is saved in the app and automatically applied to future orders.

Was this article helpful?

Thanks so much for your feedback!

Have more questions? Submit a request

Do you want to save your hours of bookkeeping?

Connect your E-Commerce store to Xero, QuickBooks OR Sage By Parex Bridge.

Try Parex Bridge to save your valuable time By clicking below button.

Try Parex Bridge