Shopify inventory in QuickBooks Online,
decremented in real time

The Shopify-to-QuickBooks Online integration that keeps QBO inventory accurate to the order — not to yesterday's batch. Every Shopify sale decrements the matching QBO item the instant it syncs. Refunds restock automatically. COGS posts on every sale. Multi-store inventory stays cleanly separated.

Why Shopify Inventory in QuickBooks Drifts in Other Integrations

Daily batches, aggregated journal entries, and missing COGS — every Shopify-QBO integration except WeIntegrate

Inventory counts that lag a day or more

Batch-mode integrations sync once daily (or worse). Your QBO inventory count reflects yesterday — useless for reordering decisions made before the next batch lands.

Aggregated journal entries leave inventory untouched

Summary-mode integrations post a single revenue journal entry per day or per payout. QBO inventory does not decrement at all — your item quantities are forever the day you initially loaded them.

Manual count adjustments at month-end

When QBO inventory drifts from reality, the cleanup pass is a physical recount, then a journal entry to bring QBO into line. Every month. Not a sustainable workflow at any meaningful order volume.

How weintegrate Keeps Shopify Inventory Accurate in QuickBooks Online

Real-time decrement, refund restock, COGS per sale

Real-time inventory decrement on every sync

When unique item matching is enabled and the QBO product is configured as an inventory item, the order syncs to QBO and the quantity decrements instantly — not in tomorrow’s batch.

Refunds restock correctly

A Shopify refund creates a Refund Receipt — or a Credit Memo, depending on your WeIntegrate sync configuration — in QBO that increments the inventory count back up. Restocking happens automatically without a separate adjustment.

Bulk-item mode for non-inventory businesses

Service businesses, drop-shippers, and merchants who don't track inventory in QBO can route every Shopify product through a single bulk item — clean books, no inventory overhead.

Multi-store inventory stays separated

When you connect multiple Shopify stores to one QBO company, each store can map products to its own QBO items — no cross-store inventory pollution.

Cost of Goods Sold posts on every sale

Per-order Sales Receipts (or Invoices, depending on your sync configuration) trigger COGS journals against the inventory account on every order — your QBO P&L reflects margin in real time, not at month-end with a manual recalculation.

Audit-ready item history

Every inventory movement is tied to a Shopify order ID. When the count drifts, the cause is one click away — not a needle-in-a-haystack hunt across daily summary entries.

From Shopify Order to Decremented QBO Inventory — Three Steps

Real-time accuracy without nightly batches

1

Set Item Matching to Unique

In weintegrate 's settings, choose unique item matching (each Shopify product mapped to its own QBO item) and confirm your QBO items are configured as inventory items on QBO Plus or Advanced.

2

Sync as Normal

Every new Shopify order creates a QBO Sales Receipt — or an Invoice, depending on your WeIntegrate sync configuration — with the matched inventory items as line items. The instant that document posts, QBO decrements the inventory and posts COGS.

3

Refunds Restock Automatically

A Shopify refund triggers a QBO Refund Receipt (or Credit Memo, matching the document type used for the original order) that restocks the affected line items. The QBO inventory count and the actual on-hand quantity stay in sync without manual adjustments.

Ready for QBO Inventory That Stays Current?

15-day free trial. No credit card required. Setup takes under 10 minutes.

Start Free Trial

Best on QuickBooks Online Plus or Advanced (which support inventory)

weintegrate vs Other Shopify-to-QuickBooks Integrations on Inventory

Inventory accuracy is a clean test of whether an integration was built for real-time per-order syncing

Inventory Capability weintegrate Other Tools
Inventory decrements on every order, in real time ✓ Yes Daily batch (best case)
Refunds restock automatically ✓ Yes Manual adjustment
COGS posts on every sale ✓ Yes Aggregated or absent
Multi-store inventory separated by Shopify store ✓ Yes Often combined
Per-order audit trail tied to inventory movement ✓ Yes No
Bulk-item mode supported for non-inventory merchants ✓ Yes Varies

Shopify Inventory FAQ

Yes. Real-time inventory decrement requires unique item matching (each Shopify product mapped to its own QBO item) AND the QBO item configured as an inventory item. Bulk item mode is available for merchants who do not track inventory in QBO.

Inventory tracking in QBO requires QuickBooks Online Plus or Advanced — Simple Start and Essentials do not support inventory. WeIntegrate works with all QBO plans, but the inventory decrement only takes effect when QBO items are configured as inventory items, which requires Plus or Advanced.

Each Shopify variant maps to its own QBO item. Color/size combinations stay independently tracked, with each variant decrementing the right item.

A Shopify refund triggers a QBO Refund Receipt (or a Credit Memo, depending on whether your WeIntegrate sync configuration creates Sales Receipts or Invoices for the original order) that restocks the inventory count automatically. Partial refunds (refunding part of an order) restock only the refunded line items.

Not yet in general availability. Bi-directional synchronization and inventory management is currently in private preview with select customers. The default WeIntegrate sync is one-way: Shopify → QuickBooks Online, with Shopify as the source of truth for available-to-sell inventory and QBO recording the accounting view based on what synced. If you would like early access to bi-directional sync, contact us.

About 10 minutes end-to-end. Connect Shopify, connect QBO, set item matching mode to unique, ensure your QBO products are configured as inventory items (in QBO, not WeIntegrate), and inventory decrement starts on the next order to sync.

Stop Reconciling Inventory by Hand

15-day free trial. No credit card required. Connect Shopify and QuickBooks Online in under 10 minutes — real-time inventory decrement starts on the next order to sync.

Start Free Trial