cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
fedelohigorryobrien
Level 1

if the app shopify doesnt match with quickbooks what should I do?

sku from quickbooks donesnt match shopify
1 Comment 1
FaithA
QuickBooks Team

if the app shopify doesnt match with quickbooks what should I do?

Hello, Fede.

 

To resolve the issue where the SKUs in QuickBooks don’t match with those in Shopify, you’ll need to check and correct the mapping settings. Let me share more information on this.

 

First, it's important to note that QuickBooks Online (QBO) depends on the data that Shopify shares. How you set up the mapping is crucial for proper synchronization and ensures that inventory and sales data align accurately between Shopify and QuickBooks, preventing discrepancies and ensuring smooth operations.

 

You will need to contact Shopify customer support to confirm and correct the integration mapping settings. They can assist you in navigating to the integration settings in Shopify and reviewing the product matching setup.

 

There are two ways to configure product matching:

 

  • Name Matching: This matches the product's SKU field from Shopify to the product's NAME field in QuickBooks Online.
  • SKU Matching: This matches the product's SKU field from Shopify to the product's SKU field in QuickBooks Online.

 

It's likely that when you initially set up the integration, the product matching option was configured to Name instead of SKU. Ensure that you have selected the appropriate matching option for your setup. It's also essential to verify that all your Shopify items have unique SKUs, as QBO relies on this data for accurate synchronization.

 

For more information, you can refer to this article: Shopify and QuickBooks Online Integration Guide.

 

Furthermore, you can view this helpful article to run a report on the status of your inventory in QBO: Use reports to see your sales and inventory status in QuickBooks Online.

 

Please feel welcome to reply to this thread if you have additional queries about matching your Shopify info to QBO. The Community team will be eager to loop back and assist you.