QuickBooks Shopify connector not syncing? Missing orders and duplicates: a 12-step checklist
Since Intuit replaced its older e-commerce integrations with a new Shopify connector inside QuickBooks Online, a lot of stores have hit the same three problems: orders that never show up, orders that show up twice, and a sync that simply stopped. This checklist walks through the most common causes in order, starting with the quick ones. Where we point to how the connector behaves, we link to Intuit's own help article so you can check it yourself.
Before you change anything: write down your current connector settings (deposit account, start date, product and customer tracking, auto-posting) and the date of the last transaction that synced correctly. Intuit recommends recording these before migrating, and they're just as useful when troubleshooting.
Source: Intuit — Migrate to the new QuickBooks Online e-commerce connectors
What changed in 2026
Intuit is moving users of its legacy e-commerce apps (the OneSaas apps and the Commerce connectors) to new connectors that live inside QuickBooks Online. Shopify stores were moved over early in 2026. According to Intuit's migration article, the new connectors:
- sync every few hours, not instantly;
- import transactions individually, instead of one summary sales receipt per payout period;
- can't import orders as unpaid;
- don't yet offer two-way inventory sync (Intuit says Shopify inventory sync is in development);
- may need your product and customer mappings set up again.
Each of those changes can make a sync that "worked fine last year" look broken. Most of the checklist below follows from them.
Source: Intuit — Migrate to the new QuickBooks Online e-commerce connectors
The 12-step checklist
-
Count the gap first
Export your Shopify orders for a short date range (a week is enough) and compare the count with what's in QuickBooks under Accounting → Integration transactions. Knowing which orders are missing or doubled tells you which step below applies.
Source: Shopify Help — Exporting orders
-
Check the "For review" tab before assuming orders are lost
Imported sales wait in For review until you approve them, and they don't appear on your reports until you confirm them. A "Review" action means something is missing (like a customer or product); "Confirm" means QuickBooks has what it needs. Many "missing" orders are sitting here.
Source: Intuit — How to use the Shopify Connector app in QuickBooks
-
Give it time — the sync isn't instant
The new connectors sync every few hours, and the very first import after connecting can take from about 10 minutes to 3 hours depending on volume. Orders from this morning may simply not have arrived yet.
Sources: Intuit — Migrate to the new connectors; Intuit — Connect Shopify to QuickBooks Online
-
Look for unpaid orders
The new connectors can't import orders as unpaid. If the missing orders are pending payment, payment-on-invoice, or otherwise not yet paid in Shopify, that's likely why. Intuit says to contact support for alternatives.
-
Check your sync start date — the #1 cause of duplicates
When you set up the new connector you choose a start date (up to 12 months back). Intuit flags this as important: if the start date overlaps with data your old app already imported, you can get duplicates. If it's set too late, you get a gap. Compare it to the last transaction date your old connector synced.
-
Make sure only one app is syncing orders
If the old connector, the new connector and/or a third-party sync app are all connected to the same QuickBooks company, each one can post the same order. Open My integrations (or Integrations) in QuickBooks and disconnect anything that shouldn't be syncing sales. Disconnecting the legacy app does not delete transactions it already recorded.
-
Match payout deposits — don't add them by hand
Shopify pays out in batches, so sales sit in a clearing account (Undeposited Funds / Payments to Deposit) until the payout. Intuit's guidance is to confirm the payout and then Match the deposit in your bank feed. Adding the bank deposit manually as well is a classic way to double-count income.
Sources: Intuit — How to use the Shopify Connector app; Intuit — Connect Shopify to QuickBooks Online
-
Re-check product and customer mappings
After migrating you may need to set up product and customer mappings again; close matches show up in For review. With product tracking off, every Shopify item is posted to one default "Shopify sales item", which can make sales look wrong by product even when totals are right.
Sources: Intuit — Migrate to the new connectors; Intuit — How to use the Shopify Connector app
-
Don't expect inventory to sync both ways (yet)
Intuit says the new connectors don't yet offer two-way inventory sync and that you should update inventory in both systems for now. If your stock counts drifted after the migration, this is why — it isn't a fault you can fix in settings.
-
Check you're connected to the right company
If you (or your bookkeeper) manage more than one QuickBooks company, confirm the Shopify store is connected to the correct one. It's an easy mistake when reconnecting.
Source: QuickBooks Community — Sync issue (QuickBooks Team reply)
-
Seeing "AccountInactive" or a sync that stopped completely? Reconnect cleanly
In a QuickBooks Community thread about orders not syncing with the error "Failed to provision account. Error=AccountInactive", the QuickBooks Team linked it to the migration and suggested: sign in as a company admin → Integrations → find the Shopify integration → ⋮ → Disconnect → Explore integrations → Shopify Connector by QuickBooks → Get integration now → enter your store URL → Connect. When you reconnect, revisit step 5 so your new start date doesn't overlap what's already in your books.
-
After any change, save and sync, then re-count
Settings changes are made from the app's ⋮ → Settings, then Save and Sync now. Once it has run, repeat step 1 for the same date range to confirm the gap is closed and nothing was doubled.
Quick symptom → cause table
| What you see | Check first |
|---|---|
| Orders missing from reports | For review tab (2), sync timing (3), unpaid orders (4), start date (5) |
| Every order appears twice | Two apps syncing (6), overlapping start date (5) |
| Income too high vs. bank | Deposits added by hand instead of matched (7) |
| Sales by product look wrong | Product tracking / mappings (8) |
| Stock levels drifting | No two-way inventory sync yet (9) |
| Nothing syncing at all / AccountInactive | Right company (10), clean reconnect (11) |
When to contact Intuit support
If you've worked through the list and orders still aren't syncing, contact Intuit. Its help article for the connector points to the chat icon on the Shopify app tile in QuickBooks and to the integrations support email listed on that page. Have your counts from step 1 ready — specific order numbers get faster answers than "some orders are missing."
Sources: Intuit — Connect Shopify to QuickBooks Online; QuickBooks Community — Sync issue
Tired of checking the sync yourself?
SelfHeal watches your Shopify → QuickBooks (or Xero) sync around the clock, catches missing and doubled orders, and fixes them before month-end. Try it free: we build it on sample data first, you watch it run, break and fix itself, and you connect real accounts only if you like it.
Start a free pilot