How to Fix Incorrect Product Mapping During Order Sync or Posting
This article helps Webgility Desktop users diagnose and resolve product mapping issues that cause order posting failures or mismatched items during order processing between the connected sales channel and QuickBooks Desktop. It provides step-by-step guidance to ensure accurate mapping, smooth order syncing, and correct inventory updates.
Step-by-Step Guide to Fix Product Mapping Issues
1. Review Product Mapping
Check if the affected product is currently mapped:
-
In Webgility Desktop, go to:
Products > Missing in QuickBooks or Product Mapping -
Look for:
-
Unmapped items (products from the store that don’t have a QuickBooks counterpart)
-
Invalid mappings (highlighted in red)
-
2. Download the Latest Product Data
Make sure the latest product lists have been pulled into Webgility: Download Items from Scratch from Both QuickBooks & Sales Channel
Wait for the process to finish, then confirm that the missing or mismapped product appears in the updated product list.
3. Map or Remap the Product
Once the product data is current, map the store product to the correct QuickBooks item:
-
Go to Products > Missing in QuickBooks or Product Mapping
-
Select the unmatched product
-
Use one of the following mapping methods:
A. One-Click Mapping
Automatically match the store’s SKU to a field in QuickBooks:
-
Item Name/Number
-
Manufacturer Part #
-
Barcode
B. Auto-Recommendation
Webgility suggests possible matches from QuickBooks based on SKU, name, or barcode.
C. Manual Mapping
Search for the correct product in QuickBooks by name or SKU, and manually link it.
💡 To remove incorrect mappings:
Go to Products > All Products > Filter: Mapped, then click the Remove Mapping icon on the product.