Understanding Sync Issues: Missing New Products in QuickBooks

Overview:

Once you subscribe to the Inventory Sync add-on feature, our app will automatically sync all active products from your Shopify store to QuickBooks. This sync takes place regardless of whether or not any orders have been processed for those specific products.

The synchronization follows the product matching criteria you have selected in the app's settings—such as SKU or product name—ensuring consistency between both platforms.

However, it's important to note that some products may not sync successfully due to errors returned by QuickBooks. These exceptions can occur for a variety of reasons, which we will discuss in more detail below.

Detailed Information:

Understanding SKU Matching Criteria for Shopify–QuickBooks Sync

When you subscribe to the add-on feature “Inventory Sync”, it's important to understand how products are mapped—specifically based on SKU values. This article explains the importance of SKU assignment and uniqueness to ensure a smooth sync process.

If a product in Shopify does not have a SKU assigned, it will not be synced to QuickBooks immediately. Instead, it will only sync once an order involving that product is processed. This is why, before enabling the inventory sync feature, you must ensure that every product you wish to sync has a unique SKU assigned in Shopify.

It’s also crucial that both the SKU and the product name are unique across your catalog in both systems. For example, consider a product named “Apple” that exists in both Shopify and QuickBooks. If the SKUs for “Apple” differ in the two systems, and you’ve set the matching criteria to be based on SKU, our app will treat these as separate products. Since it can't find a matching SKU in QuickBooks, it will attempt to create a new product using the Shopify name and SKU.

However, QuickBooks uses the product name as a unique identifier. If a product with the name “Apple” already exists in QuickBooks, the system will return an error while creating the product with the same name, even if the SKU is different. This leads to a sync failure due to a naming conflict.