← Back to Blog
guide

Every New Shopify Product Gets Its Own QuickBooks Online Item — Automatically

By WeIntegrate Team March 13, 2024
Shopify merchant photographing a product with a smartphone for an online listing — WeIntegrate auto-creates new items in QuickBooks Online

Your Shopify product catalog changes. New products launch, variants get added, seasonal items come back. Every time a new product appears in a Shopify order and doesn’t yet have a matching item in QuickBooks Online (QBO), your integration faces a choice: fail the sync, fall back to a generic item, or create the right item automatically.

WeIntegrate chooses the right path. When a Shopify order line item can’t be matched to an existing QBO item, WeIntegrate creates the item in QuickBooks Online automatically — complete with the income account, expense account, inventory type, and tax settings you’ve configured once in your WeIntegrate settings. The order syncs. The item exists in QBO. Your catalog and your books stay in step without anyone touching QuickBooks.

Two Paths When No Match Is Found

WeIntegrate’s item auto-create configuration gives you control over what happens when a Shopify product can’t be found in QBO. Two options:

Create New — WeIntegrate creates a new item in QuickBooks Online using the Shopify product’s data and your configured defaults. The item is immediately available and used for the incoming order, and for every future order containing that product.

Use Default Item — The order line item is routed to a designated catch-all item in QBO instead. This is the fallback for merchants who’d rather consolidate unmatched products into a known account than have WeIntegrate create items automatically.

Auto-create is the option that keeps your QBO item list current as your Shopify catalog evolves. Every new product that enters an order gets its own QBO item — accurately mapped to the right accounts before the order finishes syncing.

The Settings That Determine What Gets Created

When auto-create is enabled, the following settings control how WeIntegrate builds each new QBO item:

Create Item as — choose between Inventory Item and Non-Inventory Item. This is the most consequential choice in the configuration. For merchants who want QBO to track stock levels per product, Inventory Item is the type that makes it happen. For merchants tracking products that don’t require inventory quantity management in QBO, Non-Inventory Item keeps things clean. Service-type items — for labor, consulting, or fee line items — are typically pre-created in QBO and matched via unique item matching rather than auto-created.

Income Account — the QBO account that receives revenue from sales of newly created items. Every auto-created item is linked to this account, so new product sales post to the right place from the first transaction.

Inventory Asset Account — for Inventory Item type, this account holds the value of your on-hand stock. Required for Inventory items in QBO.

Expense Account — the cost of goods sold (COGS) account linked to newly created items. For Inventory items, this is where the cost posts when a sale reduces your stock.

Set Sales Description as — choose whether the item’s sales description on QBO documents comes from the Shopify product’s item description or item name. Controls how the product appears on Sales Receipts in QBO.

Set Purchase Description as — the same choice for purchase-side documents.

Taxable — check this to mark newly created items as taxable in QBO, or leave unchecked for non-taxable items.

Assign Class to New Item — if you use QBO Classes for reporting, enable this to assign a class to every auto-created item. Classes and sub-classes are loaded from your QBO account.

Inventory Items: Where Auto-Create Gets Critical

For merchants running Inventory Item types in QBO, auto-create is more than a convenience — it’s what keeps your stock counts accurate.

When a Shopify order line item matches an Inventory-type item in QuickBooks Online, QBO automatically decrements the inventory quantity for that item. Every sale through Shopify reduces your QBO stock count in real time. Your on-hand quantities in QuickBooks reflect what actually shipped — not a number that hasn’t moved since your last manual count.

That only works if the line item is matched to an Inventory-type item. A product that falls through to a Non-Inventory catch-all item, or stays unmatched entirely, doesn’t trigger the inventory decrement. Auto-create with the Inventory Item type configured means new Shopify products get the right QBO item type from their first sale — and inventory movements stay accurate from day one.

The Failsafe That Prevents Sync Failures

QBO occasionally rejects a new item creation — most commonly when required matching data is missing from the Shopify order (a product with an empty SKU when SKU is your matching field, for example) or when a matching rule has a gap that produces no usable item data.

WeIntegrate handles this with a failsafe: you designate a default QBO item to receive the order line if creation fails. The order still syncs — it routes to the fallback item rather than failing outright. WeIntegrate flags these instances so you can trace the cause: missing product data on Shopify, a matching rule that needs adjustment, or a QBO configuration gap.

The fallback means a creation failure is a notification, not a blocked sync.

A QBO Item List That Keeps Up With Your Catalog

Without auto-create, every new Shopify product that enters an order creates a sync problem: manual item creation in QBO, or orders landing in a catch-all item that blurs your revenue by SKU. With auto-create enabled, your QBO item list and your Shopify product catalog evolve together — automatically, on every order, without per-product manual setup.

For merchants who track inventory in QBO, the stakes are even higher. An item that doesn’t get created as the right type means inventory counts that start wrong and accumulate drift. Auto-create with the right defaults configured from the start means that problem never materializes.


For related reading on how WeIntegrate’s item matching engine works — including bulk vs. unique matching, primary match fields, and when each approach makes sense — see how WeIntegrate’s item matching works.

For the customer side of the same automation — how WeIntegrate auto-creates new QBO customer records when a Shopify buyer isn’t found during matching — see how WeIntegrate auto-creates customers in QuickBooks Online.

If auto-creating individual item records isn’t the right structure for your store — if you’d rather route all unmatched Shopify products to a single designated QBO item — see how WeIntegrate’s default item routing works.

Start your free 15-day trial of WeIntegrate and configure your item auto-create settings as part of your 10-minute setup. No credit card required.

Ready to Get Started?

Connect Shopify to QuickBooks Online in 10 minutes with weintegrate .

Start Free Trial