QuickBooks Online Integration

The QuickBooks Online (QBO) integration keeps customers, products, inventory, orders, and invoices in sync between QuickBooks Online and WizCommerce. Because QBO is cloud-hosted, the connection uses OAuth, there's no Web Connector to install and no host machine to maintain.

This article explains how the connection works, what data flows in which direction, and how to handle the common scenarios when something doesn't look right.

Table of Contents

Before You Begin

1. Confirm with WizCommerce team that your QBO subscription tier supports API access.
2. Make sure you have administrator access to your QBO account, you will need to authorise the connection.
3. QuickBooks Online does not have a sales rep field, so there is no sales rep mapping between QBO and WizCommerce. Sales rep details are not pulled from QBO, they are added and maintained manually in WizCommerce by the client

A. How the Connection Works

WizCommerce team initiates the connection from WizCommerce and shares a link or in-product flow. When you sign in to QBO and authorise WizCommerce to access your account, an OAuth token is issued.

WizCommerce uses that token on every request to QBO to read and write data securely. There is no software to install on your side. Orders placed in WizCommerce push to QBO as Invoices, with line items that map to the corresponding QBO items.

B. What Data Syncs Between QBO and WizCommerce

The integration between QBO and WizCommerce keeps your data in sync across both platforms. Below is a quick overview of the entities that sync and the direction of the data flow.

C. Sync Timing

QBO inventory and product syncs run on a schedule. Order push from WizCommerce to QBO happens shortly after the order is confirmed. For on-demand refreshes, contact WizCommerce team or reach out to help@wizcommerce.com.

D. Troubleshooting and Common Issues

» A new product or SKU added in QBO isn't showing in WizCommerce

See the published FAQ I added products in QuickBooks but they haven't appeared in WizCommerce yet — how do I get them synced?.

» A reactivated customer in QBO isn't appearing in WizCommerce

See the published FAQ We reactivated a customer in QuickBooks — will they automatically show up in WizCommerce after the next sync?.

» Stock quantities in WizCommerce look wrong

QBO inventory pulls on a schedule, so WizCommerce reflects the last sync. Confirm Inventory Tracking is on for the product. See the published FAQ How do I stop a product from showing as available when its quantity is 0?.

» Orders aren't pushing to QBO — OAuth connection expired

If the QBO OAuth connection has expired or been revoked, orders will not push until you re-authorise. contact WizCommerce team or reach out to help@wizcommerce.com — re-authorising QBO requires signing in to QBO from your end and re-granting access.

» Orders failed because a customer or item isn't in QBO

The pattern is the same as QBD:

• If the customer doesn't exist in QBO, push the customer first, then retry the order.
• If a SKU on the order line doesn't exist in QBO, add the item in QBO, then push the order again.

FAQs

1. Do I need to install anything for QBO integration?

A. No. QBO is cloud-hosted, so the integration uses OAuth — no Web Connector and no host machine to keep running.

2. Why do orders show as Invoices in QBO?

A. QuickBooks Online does have a separate section for sales orders in its interface, but it does not provide API support for them. Because of this QBO limitation, orders cannot be pushed or pulled through the integration as orders.

To work around this, WizCommerce pushes confirmed orders to QBO as invoices instead, carrying over all the same line items and product details. This is a limitation on QBO's side, not WizCommerce.

3. What happens if my OAuth token expires?

A. Both pushes and pulls will fail until the connection is re-authorised. You'll need to sign in to QBO and grant access again. The WizCommerce support team can guide you through this.