How to Resolve Product Syncing Issues in Webgility Desktop
This article helps Webgility Desktop users in addressing product synchronization issues, ensuring inventory and pricing data remain accurate and current. Issues with product data failing to sync properly between the sales channel, Webgility Desktop, and QuickBooks Desktop are common, and this guide is designed to assist in identifying and addressing them effectively.
If you're experiencing issues with product data not syncing properly between your sales channel, Webgility Desktop, and QuickBooks, you're not alone. This article walks you through a step-by-step process to troubleshoot and resolve common product sync issues to ensure your inventory and pricing data stay accurate and up to date.
Step-by-Step Instructions
Step 1: Ensure Products Are Downloaded from Both Systems
Make sure Webgility has successfully downloaded items from both your sales channel and QuickBooks.
-
Navigate to Products > All Products in Webgility Desktop.
-
Click the Refresh icon on the top-right corner to reload the product list from the sales channel.
Missing Items from QuickBooks?
- Re-download items from QuickBooks:
Go to Connections > Get Latest Data and Settings, then select Download QuickBooks Data and Settings. -
Make sure QuickBooks is open in Admin mode and in Single-user mode.
-
Ensure the Scheduler is OFF during this process.
Missing Items from the Sales Channel?
-
Go to Products > All Products under your Sales Channel. Click the dropdown next to the Refresh icon in the top-right corner and select Download from Scratch to reload the full product list from your sales channel.
Step 2: Verify Product Matching and Mapping
Incorrect matching or mapping can block syncing and cause data discrepancies.
-
Go to Products > View > All Products
-
Click on Matching Products to verify SKU match logic (e.g., Product Name or Item Name/Number).
-
For mapped items, go to Mapped Products to review the linked products.
-
To remove incorrect mappings, select the product and click the Remove Mappings icon.
-
To map an item, go to the Missing in QuickBooks list, select the product, and click Map.
Step 3: Check Product Sync Settings
Navigate to Products > Settings > Sync Settings.
-
Confirm the Master Data source is correctly selected (either QuickBooks or Sales Channel).
-
Ensure syncing options such as Available Quantity or On Hand Quantity are properly configured under Automation Rules.
-
Check Item Settings to review any custom rules applied to specific SKUs.
Using Item Packs?
-
If item packs are defined, go to Products > Additional Mappings > Quantity/Weight.
-
Make sure the pack setting is not unintentionally adjusting quantities.
Step 4: Use the Out-of-Sync Tabs
Quickly identify products with syncing issues:
-
Navigate to Products.
-
Click on Quantity Out of Sync or Price Out of Sync to view affected items.
-
Adjust discrepancies accordingly before the next sync.
Notes:
-
Always keep QuickBooks in Admin and Single-user mode while performing data refreshes.
-
Disable the Webgility Scheduler during manual sync or troubleshooting to avoid conflicts.
-
Always test syncs with a few products before applying mass updates.
Reference Links