Quickbooky

Accounting News

Integrations

Connecting Shopify to QuickBooks Online: setup and sync times

QuickBooks Online users can link Shopify through the official connector; here is the setup path, account choices, and how long imports take.

COMMUNITY ISSUESQUICKBOOKY

QuickBooks Online users keep asking the same question in community threads: how do I connect my Shopify store to QuickBooks Online? The accepted answer points to the official Shopify Connector by QuickBooks, an integration that pulls orders and related details out of Shopify automatically. This report covers the setup path, the key settings, and the import times users should expect.

The data the connector imports

The connector handles the transaction data that makes up daily store activity. That includes sales, refunds, fees, and payments. The goal is reconciliation: Shopify totals and QuickBooks Online records stay in line without manual copying. Once connected, QuickBooks Online starts accepting the data according to the date you choose during setup.

Before you connect

There are four prerequisites in the accepted answer. You need an active QuickBooks Online account. You need the original Shopify store URL, the one generated when the shop was created, not a custom domain. You need your Shopify username and password. You also need permission in Shopify to install third-party applications. The original URL matters because the connector uses it to identify the store.

The connection steps

Start in QuickBooks Online. Go to Integrations, choose Explore integrations, and locate the Shopify Connector by QuickBooks. Select the option to get the integration, enter the store URL, then connect. The next screen shows the steps involved; continue past it and you will land on the Shopify side, where you sign in and authorize access to share data across the two services. From there, QuickBooks Online redirects you to an application settings page.

Settings to review before the first sync

The settings page is where the practical decisions happen. You choose the date the app starts importing orders; the connector can only bring in orders up to one year old. You pick a deposit account for incoming payments and a payment account for negative payment amounts. You decide whether transactions are added automatically. If you leave that option off, any transactions that are not added automatically will need to be reviewed by hand. You can also turn on product tracking, so items sold in Shopify match inventory items in QuickBooks Online, and customer tracking, so customer details move across. The final control is a Sync now option, which completes the connection.

What happens after you connect

Once the connection is complete, use the go to integration transactions option to see the imported activity. QuickBooks Online will begin importing Shopify transactions from the date you selected. The first import takes between 10 minutes and 3 hours, depending on how many transactions are in the store. Data comes in batches, so a high-volume store should allow the full three hours before every transaction appears.

The store URL detail

The accepted answer makes one point repeatedly: use the original URL that Shopify generated, not a custom domain. The integration expects the store address that Shopify assigned when the account was created. If the URL does not match, the connector cannot complete the setup. App install permissions matter just as much. Without permission to install third-party apps, Shopify will not show the authorization step. Checking that setting before you begin saves a round trip.

The one-year limit

Users who expect a full history should plan around the same constraint. The import start date can go back one year at most. Older Shopify orders will not appear in QuickBooks Online through this connector. That is not a bug; it is the boundary built into the integration. If the full history matters, reviewing the cutoff before setup avoids surprise later.

The path from Shopify to QuickBooks Online is straightforward when the prerequisites are in place. Confirm the original store URL, make sure third-party apps are allowed, then move through the settings in order. The first import takes time, especially for larger stores, but the connection itself is usually the simplest part of the process.

← Back to Community Issues