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

Item Mapping & Matching Discrepancies Caused by Duplicate SKUs in QuickBooks in Webgility Online

This article helps Webgility Online users resolve inventory reconciliation discrepancies in Webgility Online when the total number of mapped and matched items exceeds the actual count of store items. It specifically addresses how duplicate SKUs in QuickBooks Online can lead to these matching issues.

Overview

This article addresses scenarios where the total Mapped and Matched items in inventory reconciliation exceeds the count of store items, focusing specifically on how duplicate SKUs in QuickBooks can cause matching discrepancies.

Common Symptoms

  • The sum of Mapped and Matched items is greater than the sales channel item count.
  • Repeated or unexpected item matching in Webgility Online.

Root Cause Analysis

Duplicate SKUs within the QuickBooks item list are a primary factor in such discrepancies. When Webgility Online attempts to map sales channel items to QuickBooks, each instance of an SKU—even if identical—can be independently matched, resulting in more matched items than unique items in the sales channel.

Example Scenario

  • Store item count: 100
  • QuickBooks SKUs: Includes several duplicates (e.g., SKU001 appears three times)
  • Mapped + Matched items: 105

    Investigative Steps

      1. Identify Mismatched Counts:
     2. Export SKU Lists:
    • Export the QuickBooks item list and store item list to CSV or Excel.
    • Use filtering/sorting to identify duplicate SKUs in the QuickBooks file.

    Resolution Steps

     1. Remove or merge duplicates in QuickBooks: