How to Resolve CSV Product Mapping Errors
This article helps Webgility Desktop in product mapping import via CSV file in Webgility Desktop. It addresses issues where items appear under the "Missing in QuickBooks" tab due to improper product mapping, incorrect or incomplete CSV formatting, or leftover mapping data from previous incorrect imports. The guide provides clear instructions to ensure accurate mapping and prevent common import errors.
This article will guide you with proper steps to follow for working product mapping import via CSV file.
Root Causes of the issues
Typical reasons for missing items in the Missing in QuickBooks tab include:
- Improper product mapping during or after import
- Incorrect or incomplete CSV formatting and data
- Residual mapping artifacts after previous incorrect mapping deletions
Steps to Troubleshoot & Resolve
1. Verify CSV Import Integrity
- Ensure the CSV file is correctly formatted with all required columns (e.g., SKU, Product Name).
- Check for duplicates or blank fields which might be blocking the mapping.
- Re-import the CSV and ensure import completes without error.
2. Validate Product Catalog Sync & Inspect Mapping.
- Go to Webgility > Product Catalog >Hit the refresh icon on the upper right-hand side
- Navigate to Product Mapping > Missing in QuickBooks tab.
- If the tab is empty, but missing products should appear:
- Confirm the imported products are not already mapped, using the Mapped Filter
- Review the Mapped and All tabs to ensure items haven't migrated due to previous partial mapping actions.
4. Remove Incorrect/Invalid Mappings
- In the Product Catalog >> All Products >> Click on the filter at the right-hand side and select Mapped from the dropdown
- Select the mapping type Invalid, bulk select the mapping you want to remove and click on Delete to clear them.
- After removal, return to Missing in QuickBooks and refresh.