The Core Issue

Not all Shopify data automatically syncs into QuickBooks Online (QBO) because the native integration has limited data mapping. Syncing depends on how your app or connector (such as Shopify Connector, A2X, Synder, Webgility, etc.) is configured. When orders, inventory, or payouts don’t appear, it is usually due to:

• Integration settings or permissions
• Timing of sync (real-time vs. batch)
• Data type not supported by the app (for example, refunds or adjustments)

Common Reasons Shopify Orders Don’t Sync

1. Missing or Misconfigured App Connection

Check your app connection by navigating to Apps → Shopify Connector → Settings → Connections. If the connection is tied to the wrong company or an inactive user, QBO will stop importing data. You may see messages like “Connection lost” or “Action required” in the Shopify app.

Fix: Reconnect the integration using the correct QuickBooks Online company and admin credentials.

2. Orders Not Meeting Sync Criteria

Many connectors only sync certain orders:

• Paid orders (not pending or partially paid)
• Online sales (not manual POS or draft orders)
• Orders from a specific start date (set when the integration was first activated)

Example: If your integration syncs “paid orders only,” pending or test orders will not appear in QBO.

Fix: In Shopify Connector → Sync Settings, enable “Sync all order statuses” or adjust the order filters.

3. Mapping Conflicts Between Products or Accounts

If Shopify items don’t have matching product names or SKUs in QuickBooks, the integration may skip those transactions. Sometimes they appear in a “Sync Errors” or “Uncategorized Item” queue.

Fix:

• Open the Product Mapping tab in the connector.
• Map each Shopify item or category to the correct QBO product/service or income account.
• Ensure all Shopify items have SKUs or unique names as QuickBooks relies on these.

4. Inventory Tracking Disabled or Mismatched

If inventory updates are not syncing, it could be because inventory tracking is not enabled in QuickBooks or Shopify, or your connector is not syncing quantity-on-hand updates.

Fix:

1. In QBO, go to Account & Settings → Sales → Products and Services → enable “Track Quantity on Hand.”
2. In Shopify, ensure “Track Quantity” is turned on for each product.
3. In your connector, ensure inventory sync is enabled and both platforms use the same units (e.g., pieces vs. units).

5. Integration Sync Schedule

Some apps, like A2X or Synder, sync summaries once per day rather than in real-time. Orders placed today may not appear in QBO until the next batch.

Fix: Trigger a manual sync from the connector dashboard or adjust the schedule to sync hourly.

6. Multi-Currency or Location Conflicts

Shopify supports multi-currency sales, but QBO may not if multi-currency is not enabled. This can cause skipped transactions when the order currency does not match the QBO home currency.

Fix:

• Enable multi-currency in QBO (Account & Settings → Advanced → Currency).
• Map each Shopify currency to the correct payment account in the connector.

7. Refunds or Adjustments Not Supported

Many connectors do not automatically sync refunds, gift cards, or manual adjustments. These must be entered manually or posted as journal entries.

Fix: Check your app’s “Refund sync” option. If unavailable, record refunds manually in QBO: New → Refund Receipt → select customer → link to original payment.

How to Diagnose Sync Gaps

1. Check the Sync Log or Dashboard in your connector for skipped or failed transactions.
2. Look for error messages such as “Missing account mapping,” “Product not found in QuickBooks,” or “Transaction skipped: order status not eligible.”
3. Compare Shopify order numbers with QBO Sales Receipts or Invoices to identify missing entries.

Best Practices to Prevent Sync Failures

Quick Recap

If Shopify orders or inventory are not syncing, the issue is likely one of the following:

• Missing mapping or product setup
• Limited permissions or inactive connection
• Timing delay in sync schedule
• Multi-currency or order-type filter issues
• Inventory sync disabled or mismatched