Troubleshooting stock level discrepancies between QuickBooks Desktop and Shopify
This article helps Webgility Desktop users troubleshoot and resolve stock level discrepancies between QuickBooks and Shopify caused by inventory sync issues in the Webgility Desktop. It provides step-by-step guidance to ensure accurate inventory data and prevent missed sales or customer dissatisfaction.
Overview
Stock level discrepancies between QuickBooks and Shopify can result in inaccurate inventory, missed sales, and customer dissatisfaction. This article outlines the troubleshooting steps for resolving inventory sync issues between QuickBooks and Shopify via Webgility Desktop integration.
Common Causes
- Temporary sync failures or service outages
- Outdated Webgility connectors
- Manual product or inventory updates outside of automated workflows
Step-by-Step Resolution
1. Confirm the Reported Discrepancy
- Review reported product count mismatches in both Shopify and QuickBooks (e.g., 256 products out of sync).
- Check logs in Webgility for recent sync errors or warnings.
2. Update Webgility Application
- Ensure that Webgility is updated to the latest version:
- In Webgility, go to Help > Check for Updates.
- Download and install any available updates.
- Restart the Webgility application.
3. Perform Fresh Product Download
- In Webgility, navigate to Products.
- Use the Download Products feature to fetch the latest product information from both sales channel.
- Navigate to Connections > Get Latest data and Settings to download the latest QuickBooks data.
4. Manually Sync Inventory Quantities
- In Webgility, select affected products under the Out of Sync tab.
- Use Sync Now button to align stock levels between QuickBooks and Shopify.
- Confirm the sync operation completes successfully without errors.
5. Restart and Monitor Sync Scheduler
- Restart the Webgility Scheduler:
- Go to Scheduler Settings and click Restart Scheduler.
- Monitor subsequent automated syncs.
- Review follow-up logs and confirm resolution of discrepancies.