Troubleshooting Amazon Product Mapping Issues in Webgility Desktop
This guide helps Webgility Desktop users resolve product mapping issues between their Amazon store and QuickBooks Desktop using Webgility Desktop. It focuses on common problems caused by mismatched product SKUs (Stock Keeping Units) and provides steps to ensure accurate synchronization between the two systems.
Why This Happens:
Product mapping may fail due to:
-
SKU Format Mismatch: Webgility uses the SKU as the key identifier to map products between Amazon and QuickBooks. Even small differences (such as spaces or symbols) can cause issues.
-
Missing Product in QuickBooks: If the product from your Amazon store doesn't exist in QuickBooks, Webgility cannot complete the mapping.
Steps to Resolve:
1. Verify SKU Consistency
-
Go to the Products tab in Webgility Desktop.
-
Check the SKU listed for your Amazon products.
-
Make sure the SKU exactly matches what's used in QuickBooks Desktop—including case, spacing, and characters.
2. Review Product Mapping
-
In Webgility Desktop, navigate to Products > All Products.
-
Switch the view to Mapped.
-
If a product is missing or incorrectly mapped, manually update the mapping to match the correct SKU in QuickBooks.
3. Check SKU Format
-
If mapping still fails, review the SKU for any special characters or formatting that may not be accepted by QuickBooks or Amazon.
4. Sync and Test
-
Once your mappings are updated, perform a product sync between Amazon and QuickBooks from within Webgility Desktop.
-
Process a test order to confirm the product links correctly into QuickBooks.
5. Maintain SKU Consistency
-
Regularly check for new or updated products in your Amazon store.
-
Ensure that any new listings use consistent SKUs to avoid mapping problems in the future.
Following these steps should help resolve product mapping issues.