The Shopify connector: how QuickBooks Online users set it up
QuickBooks Online users who sell on Shopify can sync orders, refunds, and payouts through the Shopify Connector app. Here is the accepted setup path.
QuickBooks Online users who sell through Shopify keep asking one version of the same question on the community boards. How do you get store sales into the books without entering every order by hand? The accepted answer is the Shopify Connector by QuickBooks app. We traced the accepted fix from start to finish. It imports orders, refunds, fees, and payouts automatically. This report covers what it needs from you and what to expect after the connection.
The connector’s scope
The Shopify Connector brings transactions and their related details from Shopify into QuickBooks Online. That covers sales, refunds, fees, and payouts. For stores that reconcile often, the app does the heavy lifting. Once connected, incoming transactions land in an area QuickBooks calls Integration Transactions.
The checklist before you start
The setup needs four things. A QuickBooks Online account. The store address Shopify assigned when you signed up, the one ending in myshopify.com rather than a custom domain. Your Shopify login. And permission in Shopify to install third-party apps. Without that last item, the connector cannot be installed.
The connection steps
The connection itself takes a few minutes. Sign in to QuickBooks Online, go to the integrations area, and open the integrations explorer. Find the Shopify Connector by QuickBooks app and choose Get integration now. Enter the store URL and select Connect.
Review the steps and select Continue. Then you sign in to Shopify and authorize data sharing between the two services. After that, QuickBooks Online returns you to the app settings page. That page controls how the sync behaves from here on.
Settings to review
The most important choices happen on the settings page, right after the connection is authorized.
Start with the sync date. It decides how far back the import goes. QuickBooks Online can pull orders from up to 12 months earlier. If you already entered some of those transactions, you can exclude or undo them after the import.
Payouts are controlled by two account fields. The deposit account records where Shopify payouts land. The payments account records where negative payouts, such as refunds, come from.
The main automation switch is labeled Add transactions automatically. When it is on, QuickBooks Online posts high-confidence transactions on its own. They show up in the Categorized tab under Integration Transactions. When it is off, every transaction waits for your review.
Two tracking toggles round out the list. Product tracking syncs products sold on Shopify as inventory items. The app matches by SKU and product name against existing items to avoid duplicates. Customer tracking syncs customer details from Shopify. Select Sync now to finish.
After you connect
Once you finish, select Go to Integration Transactions. The initial import does not happen instantly. Depending on volume, it can take between 10 minutes and 3 hours. Transactions arrive in batches, so a large store should give the import the full window before digging in.
Inside the For Review tab
Product tracking has a safety net built in. When the app finds a close match between a Shopify product and an existing QuickBooks item, it does not create a duplicate automatically. The close match appears in the For Review tab with a suggested match. That is where you accept or reject the suggestion.
Two terms that trip people up
The settings page uses language that is easy to misread. The transaction sync date is not the date a sale happened. It is the date the app starts importing from, up to 12 months back.
That is also the answer to the double entry worry. If orders were already entered by hand, you can exclude or undo the imported copies after the fact. And Add transactions automatically does not mean every transaction posts. Only the high-confidence ones do. Anything the app is unsure about still waits for a human decision.
The bottom line
For most Shopify stores, the connector is the cleanest route between the two products. Setup takes minutes. The initial sync does the heavy lifting. The decisions that matter are the start date, the payout accounts, and whether transactions post automatically or wait for review. If you are new to it, leave the automatic switch off until you have watched a few batches come through.