Quickbooky

Accounting News

E-commerce Integration

Connecting Shopify to QuickBooks Online: Setup Choices and Import Timing

Shopify sellers can connect QuickBooks Online to import sales, refunds, fees and payouts, but start date, account mapping and auto-posting settings matter.

Connecting Shopify to QuickBooks Online: Setup Choices and Import Timing

QuickBooks Online users linking a Shopify store often run into the same two surprises. The connector requires the original Shopify shop address, and the first import can take up to three hours. The setup path is straightforward, but the settings chosen during connection decide which sales, refunds, fees and payouts land in the books without review.

The affected setup and the store address rule

The affected product is QuickBooks Online, paired with the Shopify Connector by QuickBooks app. Before starting, a merchant needs an active QuickBooks Online account, Shopify sign-in details, and permission in Shopify to install third-party apps. The connection also expects the original Shopify shop address in the form my-store.myshopify.com. A custom storefront domain will not complete the handshake.

Before connecting, merchants should confirm that their Shopify role allows app installation. A store owner or staff account without that permission can see the option but cannot complete the authorization. That is one of the more common early blockers.

The connection path from QuickBooks Online

From QuickBooks Online, open Integrations and choose Explore integrations. Search for the Shopify Connector by QuickBooks app, select it, and choose Get integration now. Enter the original Shopify store address, select Connect, and then sign in to Shopify to authorize the data share. After that, the app returns you to QuickBooks Online for the final settings.

The connector is built to import Shopify sales, refunds, fees and payouts into QuickBooks Online in one flow. That removes the need to build a manual bridge or export and re-enter transaction files each day. The value comes from the mapping choices, because fees and payouts behave differently from a simple sale and need their own accounts.

Import settings that control the books

This is where the practical setup happens. The merchant can choose how far back the import should reach, where payouts and negative payouts are recorded, and whether transactions post automatically or wait for review.

The first choice is the transaction sync date. The connector can reach back up to one year, so a merchant who already recorded some orders manually can start from an earlier point and later exclude or undo anything already entered.

Two account fields map Shopify payouts and negative payouts to the right places in QuickBooks Online. Choosing the wrong account here does not block the import, but it sends money to an unexpected place in the chart of accounts.

The automatic posting switch controls whether high-confidence transactions move straight to the categorized tab or wait for review. Product tracking lets the app match Shopify products to existing QuickBooks inventory items by SKU and name, with close matches set aside for review. Customer tracking does the same for customer details.

The first sync can look incomplete

Once Sync now is selected, the connection is complete and the merchant can open Integration Transactions. The initial import normally takes between ten minutes and three hours, depending on volume. Large volumes import in batches, so the full set may not appear all at once. That delay is a normal part of the process, not evidence that the connection failed.

High-confidence transactions appear in the categorized tab. Items that need a closer look, including some product matches, appear in the for-review area with suggested matches or the option to resolve them manually.

Resolving the common connection complaints

For users in the support thread, the fix was not a repair or manual re-entry. It was completing the setup with the original store address and setting the deposit, payment, auto-posting, product and customer options before the first import. Merchants who skipped account mapping or left auto-posting off still received transactions, but those items sat in review or posted to an unexpected account. Adjusting those settings and checking Integration Transactions cleared the confusion.

Merchants who start the sync and see no transactions in the first few minutes should wait for the batch import to finish rather than reconnecting. If the original Shopify address was entered incorrectly, the connection fails before the settings page appears, so correcting that address is the first troubleshooting step.

← Back to Community Issues