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

Troubleshooting SKU Duplication Issues in Amazon and QuickBooks Online via Webgility Online

This article helps Webgility Online users address inventory mismatches and financial discrepancies caused by duplicate or similar SKUs in Amazon when only one version is recognized in QuickBooks Online. It explains the importance of accurate SKU mapping between Amazon and QuickBooks Online within the Webgility Online integration. Users will find a step-by-step guide to resolve SKU mapping issues and maintain consistent product tracking across platforms.

Causes of Issues

  • Duplicate SKUs in Amazon: Multiple listings for the same item with slight variations.

  • Mismatched SKU naming conventions: SKUs formatted differently between platforms.

  • Incorrect or outdated mapping: SKU mapping rules not updated after inventory changes.

Step-by-Step Instructions

1. Identify Affected SKUs

  • Log in to Amazon Seller Central and QuickBooks Online.

  • Cross-check product SKUs from Amazon’s Inventory Reports with the Products and Services list in QuickBooks Online.

2. Investigate the Source of the Discrepancy

  • In Amazon Seller Central, look for SKUs with:

    • Identical product names but different SKU codes.

    • Variations in formatting (e.g., hyphens, capitalization).

  • In Webgility Online, review the Products > Product Catalogs.

3. Coordinate on SKU Ownership

  • Review your duplicate SKUs and decide which version you want to keep.
  • If you're unsure, check with your inventory or catalog manager to confirm which SKU is accurate. Then, plan to remove the duplicate or incorrect versions. 

4. Remove Redundant SKUs from Amazon

  • Go to Inventory > Manage Inventory in Amazon Seller Central.

  • Locate and select duplicate SKUs.

  • Click Delete product and listing for the redundant SKU(s).

5. Download the Latest Data from QuickBooks Online in Webgility Online

  1. Go to Sync Settings > Products in Webgility Online.

  2. Click Refresh Settings on each tab to pull the latest data from QuickBooks.

  3. Under Product and Customer tabs, choose Refresh Latest Accounting Data or Download from Scratch (for a full redownload).

  4. Click Refresh Settings to begin the sync.

  5. Wait for the sync to complete—this may take a few minutes.

  6. A confirmation message will appear once the download is complete.

6. Verify Resolution

  • In QuickBooks Online, check the Products and Services section to ensure duplicate records are not present.

  • Confirm inventory quantities, pricing, and transactions are accurate.

  • Run a test order to verify posting completes without SKU-related errors.

Notes

  • Always maintain a backup of your product catalog before deleting SKUs.

  • After updates, allow a few minutes for synchronization to complete.

Best Practices

  • Standardize SKU formats across all platforms.

  • Use a single source of truth for SKU generation.

  • Perform monthly audits of product data across Amazon and QuickBooks Online.