The generic “Shopify Sales Item” in QuickBooks Online: how to get real products on your sales

Why sales land on one generic item

Intuit’s guide to the Shopify connector describes two cases where sales post to the default Shopify Sales Item instead of your products:

When Product Tracking is on, the connector tries to match each Shopify product to an existing QuickBooks item by SKU and name. Close matches appear in the For Review tab with suggested matches. If there’s no match, the connector doesn’t create the item for you.

So a store that never set up QuickBooks items, or whose SKUs differ between the two systems, ends up with most sales on the generic item, even with Product Tracking on.

Decide how much detail you need

Before you fix anything, decide what the books are for.

• Totals are enough if you or your accountant only need income, fees and tax per payout. Summary-level sales on one item can be perfectly good books, and payout-summary tools such as A2X or Link My Books work this way on purpose.
• You need real products if you want sales by product, margins per product, or inventory in QuickBooks. Then every Shopify variant needs a matching QuickBooks item.

If totals are enough, check that the tax codes and payouts are right (see our guide to the 2026 connector change) and stop here.

Get real products on new sales

1. Turn on Product Tracking. In QuickBooks Online, open the Shopify tile’s Settings. Intuit says the settings can be changed after setup.
2. Give every variant a SKU. In Shopify, each size or colour is a separate variant with its own SKU field. Intuit says matching uses SKU and name, so a variant without a SKU has less to match on.
3. Make the SKUs identical. Export your Shopify products and your QuickBooks Products and services list, and compare SKUs side by side. Fix differences in spacing, prefixes or capital letters in one system.
4. Create the missing items. For every Shopify SKU with no QuickBooks item, create the item in QuickBooks Online. You can import a list instead of typing each one.
5. Work through For Review. Accept or correct the suggested close matches before those sales go into your books.
6. Spot-check new sales. Open five sales from the next few days and check each line shows the real product.

When to use a different sync

Order-by-order syncs give you more control over matching. MyWorks Sync can map products automatically by name or SKU, and keeps a mapping once it’s made. Webgility recommends matching the Shopify SKU to the QuickBooks product name, and lets you match individual products by hand. Consider one if you have many variants, SKUs that differ between the systems, or need inventory to stay in step.

In our analysis of 155 merchant complaints about the Shopify–QuickBooks sync, 12 were about product or SKU mapping. It’s rarely the biggest problem in the books, but it’s the one that makes product reports useless.