How to Resolve Duplicate Item Mappings in Webgility Desktop

Step 1: Identify Duplicate Mappings

To check for duplicate item mappings:

1. Open Webgility Desktop

2. Go to Products 

3. Look for:

   • Store items mapped to more than one QuickBooks product

   • Repeated SKUs or product names with different QuickBooks links

⚠️ Signs of duplicate mappings:

• Posting errors when syncing orders

• Mismatched inventory counts in QuickBooks

• Multiple entries for the same product

💾 Step 2: Backup Your Configuration

Before making any changes:

1. Go to System > Database > Backup

🗑️ Step 3: Remove Duplicate Mappings

Clean up the incorrect links:

1. In Product Mapping, locate items mapped to multiple QuickBooks products

2. Select the duplicate mappings

3. Click Remove Mapping

4. Confirm the deletion when prompted

Repeat this for all affected items.

🔄 Step 4: Refresh Items from QuickBooks and Store 

This will:

• • Import current QuickBooks product data

  • Clear out any outdated or obsolete items

🔗 Step 5: Remap Items Correctly

After cleanup:

1. Return to Products > Product Mapping

2. Find unmapped items from your store

3. Click Map to QuickBooks for each

4. Select the correct QuickBooks item from the list

5. Save the new mapping

💡 Tip: Ensure that SKUs or item names match across both systems to avoid future conflicts.

✅ Step 6: Test by Posting an Order

Verify that the mapping changes have resolved the issue:

1. Select an order that previously failed due to a mapping error

2. Click Post to QuickBooks

3. Confirm that the order processes successfully, with no item-related errors