Resolving Inventory Synchronization Issues in Webgility Desktop: Item Mapping and Price Updates

Overview

This article provides step-by-step troubleshooting guidance for resolving inventory synchronization issues in Webgility Desktop, specifically focusing on item mapping inconsistencies and price update failures. These steps are designed to help you resolve mismatches between your QuickBooks inventory and your connected online sales channels, such as Shopify, Amazon, or eBay.

Common Causes of Inventory Sync Issues

• Unmapped or incorrectly mapped items between Webgility and the online store

• Recent SKU or product detail changes not updated across systems

• Price mismatches due to sync errors or manual overrides in QuickBooks or the store

Step 1: Review and Correct Item Mapping

1. Open Webgility Desktop.

2. Navigate to: "Products> Missing in Sales channel."

3. Review the list of mapped items across all connected channels.

4. Identify any:

   • Unmapped items

   • Incorrectly mapped SKUs

5. To remap items:

   • Go to Products > All products > Remove Mapping next to the affected item.

   • Use the search feature to locate the correct QuickBooks item.

   • Select the correct SKU and click Save Mapping.

Step 2: Sync or Update Price Information

1. Navigate to Products > Quantity/Price Out of Sync.
   
   

2. Use the Sync option to initiate pricing updates from QuickBooks to the online store (or vice versa, based on sync settings).

3. For individual SKUs with mismatches:

   • Filter and select the specific products.

   • Click sync option to sync manually.

Step 3: Validate Synchronization Results

1. Wait for the sync operation to complete.

2. Check for any errors or skipped items in the scheduler logs.
   C:\Webgility\UnifyEnterprise\SchedulerLog

3. Revisit the Item Mapping section to fix any.

4. Check:

   • Quantity in QuickBooks matches the sales channel.

   • Prices are reflected accurately in QuickBooks to match the sales channel.