There are several reasons why the inventory sync is failing. The most common is the QuickBooks name field fails to match your product SKU field. Another issue is the inventory in QuickBooks was updated prior to the sync times.
Name and SKU
The QuickBooks item name and product SKU must match. Many customers have products without SKUs, so our software cannot match them. To find the QuickBooks item name, follow these steps:
- Open QuickBooks.
- Go to lists > item list.
- The name field is on the left:
- In your website, go to your product list and note the SKU field.
- In this example, black shoes has no SKU. Therefore, our system cannot update it:
- If you sell product variations, each variation has its own SKU. The parent product will have no SKU.
When Connex is set-up, it only syncs updates from the date of install going forwards. You can change the sync dates back 90 days to sync further back:
- Login to Connex.
- Click Configure under your existing connection.
- On the All Settings page, click the Sync Inventory from QuickBooks Manually tab.
- Change the Exported Before and After timers up to 90 days ago.
- Click Sync Now.
- Run the web connector.
The system will queue the updates. Wait about thirty minutes and check the transaction log here: