Resolve inventory synchronization issues between ChannelAdvisor and QuickBooks Desktop
This article helps Webgility Desktop users troubleshoot and resolve inventory synchronization issues between ChannelAdvisor and QuickBooks Desktop that may occur after updating Webgility Desktop. It outlines the step-by-step process followed to identify the root cause and restore accurate inventory sync.
Overview
This article outlines the troubleshooting steps followed to resolve an inventory synchronization issue between ChannelAdvisor and QuickBooks Desktop after a Webgility Desktop update.
Resolution Steps
Step 1: Confirm Webgility Desktop Version
-
Open Webgility Desktop.
-
Go to Help > Terms & Privacy.
-
Note the current version and compare it with the latest available on the Webgility Downloads page.
Step 2: Verify Sales channel and Accounting Connections
-
Navigate to Connections > Sales channels > Manage sales channel > Action > Edit and click on Test Connection to confirm ChannelAdvisor is properly connected.
-
Navigate to Connections > Accounting/POS/ERP > Edit connection to confirm QuickBooks Desktop is connected and credentials are valid.
Step 3: Compare Inventory Quantities
-
In ChannelAdvisor:
-
Go to Inventory > Products.
-
Note down the quantities for sample SKUs.
-
-
In QuickBooks Desktop:
-
Open the Inventory Center.
-
Locate the same SKUs and compare stock levels.
-
-
Document any mismatches.
Step 4: Perform a Manual Inventory Sync
-
In Webgility Desktop, go to Products > Price/Quantity Out of Sync.
- Select the relevant items and click Sync to push the real-time sync.
-
Monitor the sync status and ensure it completes without any errors.
Step 5: Validate Inventory Update
-
After the sync, recheck inventory in both ChannelAdvisor and QuickBooks Desktop.
-
Confirm the SKUs are now showing the same quantities in both systems.