Skip to content
  • There are no suggestions because the search field is empty.

How to Resolve Item Mapping Issues by downloading the updated item list from scratch in Webgility Desktop

This article helps Webgility Desktop users resolve item mapping issues. It outlines how to download item data from scratch from both sales channel and QuickBooks Desktop and complete the mapping process ensuring efficient resolution and accurate inventory synchronization with connected sales channels.

Prerequisites

  • Access to Webgility Desktop with primary user.

  • Permissions to download item data and modify item mappings.

Step-by-Step Resolution

1. Verify the Item Mapping

  • Go to Products > Under Sales Channel All Products > Click on the View dropdown and select Mapped.

  • Identify the impacted SKUs by reviewing the Order History tab details.

2. Download Item Data

  1. Navigate to Connections > Sales Channels > Advanced Settings.

  2. Click Clear for both:

    • Last Download Date for QuickBooks Items

    • Last Download Date for QuickBooks Customers

  3. Click Save and Close.

  1. Go to Connections > Get Latest Data & Settings.

  2. Click the drop-down next to Download Data and select Re-Download All Data.

  3. Wait for the process to complete—it may take a few minutes based on your data size.

  4. If sales channel data appears outdated, click the Download Data button again to refresh settings.

4. Perform Item Mapping

  • Navigate to Product > Missing in QuickBooks.

  • Select the products you want to map and click Map Product.

  • In the pop-up, choose either One Click Mapping or Auto-recommendation.

    • For One Click Mapping, select the appropriate QuickBooks field (e.g., Manufacturer Part#, Barcode, Sub-Item) that matches your store SKU, then click Continue.

    • If mapping is successful, choose to continue mapping other products or skip for now.

    • For Auto-Recommendation, review the suggested matches from QuickBooks, select the correct item, and click Map Product.

    • If no match is found, use Manual Mapping by clicking Search for correct match, find the correct QuickBooks item, and map it.

5. Verify and Finalize Mapping

  • After completing the mapping, navigate to Products > All Products > Mapped filter..

  • Confirm that all items are properly mapped and visible in the system.

  • Run a test sync or transaction to ensure that item data flows correctly between Webgility and your sales channel.

Tips for Efficient Mapping Support

  • Track and document any recurring mapping issues to help improve the process over time.