LOOKING FOR PARTNERS 🤝

We're currently looking for partners and distributors in different regions. If you're interested, please feel free to contact us.

QuickBooks Customers syncs with Shopify Customers

Sync Quickbooks and Shopify Contacts

Learn how to sync your Quickbooks and Shopify contacts using the SyncPenguin platform


Free 14-day trial with full support, no credit card required

Online stores collect new customers every day in Shopify, but invoicing, bookkeeping and wholesale billing happen in QuickBooks Online. Retyping each shopper's name, email, phone and billing address into QuickBooks is slow and leads to typos, duplicates and invoices sent to outdated addresses. When a customer updates their details in one system, the other quickly falls out of date. As your store grows, keeping both customer lists aligned by hand stops being practical.

How SyncPenguin helps

SyncPenguin connects Shopify Customers and QuickBooks Online Customers so customer records flow automatically between your store and your accounting software. You can push new Shopify customers into QuickBooks so they are ready for invoicing, sync existing QuickBooks clients into Shopify, or keep both lists in two-way sync. Names, emails, phone numbers, notes and addresses are mapped automatically. With no-code filters and custom rules, you can choose exactly which customers sync, such as only those tagged "Wholesale", and control how each field appears on the other side.

Best suited for: Shopify store owners. Bookkeepers and accountants. Wholesale and B2B merchants. E-commerce finance teams.

Real-world use cases

  • Automatically create a QuickBooks Online customer for every new Shopify customer, so online buyers are ready for invoices, estimates and sales receipts without manual entry.
  • Sync only Shopify customers tagged "Wholesale" or "B2B" into QuickBooks, using a tag filter, so your accountant can invoice key accounts on payment terms.
  • Push existing QuickBooks clients into Shopify so they can log in and order online, and use a custom rule to tag them as "Wholesale" automatically.
  • Keep Shopify and QuickBooks customers in two-way sync, so an updated phone number or address in either app is reflected in the other.
  • Build unique QuickBooks display names from Shopify data with a custom rule, for example by combining the customer's full name with their email, so records with the same name don't clash.
  • Copy Shopify customer metafields, such as an account number or sales rep, into QuickBooks customer notes with a custom rule, so your bookkeeper can see this information.
  • Bring both Shopify online shoppers and Square in-store customers into QuickBooks, so all sales channels share one customer list for accounting.
  • Sync Shopify customers into QuickBooks for invoicing, and send only those subscribed to email marketing to Mailchimp for newsletters.
  • Sync customers from Shopify and QuickBooks to HubSpot contacts, so sales, marketing and accounting all work from the same customer details.
  • Publish your combined Shopify and QuickBooks customer list to the Microsoft 365 Global Address List, so every employee can look up customers in Outlook.

Key features

Two-Way Sync

Keep Shopify and QuickBooks customers aligned in both directions, or send changes one way only, such as from your store to your books.

Address Mapping

Shopify customer addresses are synced into QuickBooks billing and shipping addresses, so invoices always use current details.

Tag-Based Filters

Sync only the customers you need, for example shoppers with a "Wholesale" or "B2B" tag, or only those with an email address.

No Duplicates

The initial merge matches existing customers in both systems, and matched records are updated later instead of being created again.

Safe Deletions

Customers removed through a sync are made inactive in QuickBooks instead of being erased, so your invoices and accounting history stay intact.

Affordable & Scalable

With SyncPenguin you only pay for changes to your data, regardless of how many contacts you have now or will have in the future.

Things to note

  • The QuickBooks connector works with QuickBooks Online. QuickBooks Desktop is not supported.
  • Shopify only gives access to customer data on the Grow, Advanced and Plus plans, so stores on the Basic plan need to upgrade first.
  • QuickBooks requires every customer display name to be unique, and Shopify requires each customer's email and phone number to be unique. Conflicting records are reported, and you can use custom rules to build unique display names, for example by adding the email address.
  • Shopify customers can have several addresses, while QuickBooks stores a billing and a shipping address. Additional addresses are not transferred to QuickBooks.
  • Shopify may reject phone numbers it can't recognize as valid. Custom rules can reformat QuickBooks phone numbers, for example by adding a country code, before they are synced.
  • QuickBooks does not allow customers to be permanently deleted, so customers removed through a sync are marked as inactive. Customers made inactive in QuickBooks are treated as deleted on the Shopify side, and you control this behavior with general and deletion rules.
  • Only top-level QuickBooks customers are synced, and sub-customers (jobs) are skipped. QuickBooks custom fields are not currently available, but Shopify metafields can be mapped into standard QuickBooks fields such as notes.

How to configure the sync?


This guide explains in detail how to create, configure, and start the sync.

If you'd like to start syncing right away, feel free to create an account and set up the sync on your own. Come back to this guide if anything is unclear. You can also contact us with any questions, requests, or feedback.

Step 1. Create a SyncPenguin account

The first step is to create a SyncPenguin account. We offer a free 14-day trial (no credit card required), so you can make sure everything works well before you commit. Follow the link below to create an account.

14-day free trial • no credit card required • quick setup

Step 2. Create the sync

Next, create a sync in the Synchronizations section of the dashboard by clicking the + New sync button. You'll see a wizard page where you need to do the following:

  • Choose QuickBooks Customers for the first app.
  • Then choose Shopify Customers for the second app.
  • Then select the sync direction.
  • Then click the Create button.

Step 3. Provide access to Quickbooks and Shopify

Now that your sync is created, the next important step is to grant SyncPenguin access to your contact data. You'll see an Account section for each app involved in the sync. Below we explain how to connect and configure each account.

How to connect Quickbooks?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The QuickBooks Customers account connection section will look like this:

Account for QuickBooks Customers (Example)
QuickBooks Customers

How to connect Shopify?

This is a preview of the connection form in your SyncPenguin dashboard, shown for illustration only. Don’t enter any credentials here.
The Shopify Customers account connection section will look like this:

Account for Shopify Customers (Example)
Shopify Customers

Please make sure both apps are properly connected before starting the contact sync.

DATA SECURITY

If you're concerned about the security of your data, please check out our Security Practices page.

Step 4. Sync settings

In the Sync settings section, you can adjust some of the default settings of your sync:

  • The name of your sync.
  • Sync direction (two-way or one-way).
  • Sync interval (by default, the sync runs every 10 minutes).

Please note that this connection uses webhooks, so syncing will be near real-time in most cases. The syncing interval is used as a fallback in case a webhook was not fired.

Additionally, in Field mappings & rules you can customize how contact data is mapped between the apps, or add filters and custom rules to the sync. This is done using our simple no-code visual interface, which lets you make simple adjustments as well as implement complex custom scenarios.

Supported Quickbooks fields: First name Last name Middle name Display name Title Suffix Notes Company name Website Email Work phone Mobile phone Other phone Fax Billing address Shipping address
Supported Shopify fields: First name Last name Note Email Phone Addresses Tags Email marketing status SMS marketing status Custom single-line text fields Custom multi-line text fields Custom URL fields Custom number fields (integer and decimal) Custom true/false fields Custom date fields Custom date and time fields Custom lists of text Custom lists of URLs Custom lists of numbers Custom lists of dates and date-times

Virtually any syncing behavior based on supported fields is possible using the customizations interface.

Learn more about our customization interface.

Sync settings

Step 5. Start the sync

The last step is to start the sync. To do that, click the Start syncing button.

You'll then be offered the following options:

  1. Only sync new data, meaning anything added or updated from now on.
  2. Merge all historic data two-way: take all QuickBooks Customers and Shopify Customers and merge them together. Any data that already exists in both apps is merged instead of being duplicated.
  3. Merge QuickBooks Customers into Shopify Customers: take all QuickBooks Customers and add/merge them into Shopify Customers.
  4. Merge Shopify Customers into QuickBooks Customers: similar to the previous option but in the opposite direction.
Start sync
We'll be checking every 10 minutes for changes in your data.
What should we do initially with already existing contacts?

Once you've made your choice, click Start syncing. If you choose an initial merge, it'll be queued immediately. Once it's done, we'll check for contact changes at the sync interval you've set and sync them accordingly. Each sync run is shown in the Sync history at the bottom of the sync page.

Learn more

Frequently Asked Questions

How do I sync Shopify customers with QuickBooks Online?

Does this integration sync Shopify orders or invoices to QuickBooks?

Will syncing create duplicate customers in QuickBooks or Shopify?

Can I sync only some Shopify customers to QuickBooks, such as wholesale clients?

Which Shopify plan and QuickBooks version do I need?

What happens when a customer is deleted in Shopify?

Can QuickBooks customer changes update Shopify too?