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

How to Resolve Duplicate Product Listings in Webgility Online Catalog

This article helps Webgility Online users resolve duplicate product listings in their catalog, which occur when product data isn’t properly matched in Webgility Online application during sync between sales channel (ex. Shopify, WooCommerce, etc) and QuickBooks Online. It provides steps to remove duplicates and prevent them from reappearing in future synchronizations.

 

Overview

Are you seeing the same product listed more than once in your Webgility Online catalog? This can happen when product data isn’t matched correctly during syncs. This guide will help you remove duplicate entries and prevent them from reappearing.

✅ Step 1: Remove Duplicate Products

  • Open your Product Catalog in Webgility Online.

  • Identify duplicates by comparing Product Name, SKU, or Product ID.

  • Verify if the products are duplicate on Sales channel then delete the duplicate product on Sales channel.

✅ Step 2: Update Product Matching Rules

To avoid future duplicates, make sure Webgility matches products by a unique identifier like SKU.

How to update matching settings:

 Go to Settings > Product Matching. 

Once done, resync your catalog to apply the updated matching logic.

✅ Step 3: Download the Latest Data from QuickBooks

Ensure your catalog is pulling the most up-to-date product and customer data from QuickBooks.

Steps:

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

  2. On every tab, click Refresh Settings to download the latest data from QuickBooks.

  3. Under the Product and Customer tabs, you’ll find a drop-down with these options:

    • Refresh Latest Accounting Data – Updates only recent changes.

    • Download from Scratch – Fully re-downloads all product and customer data.

🔁 Use Download from Scratch if changes from QuickBooks aren’t appearing in Webgility even after refreshing.

✅ Step 4: Downloading Sales Channel Data (from Scratch)

You normally won’t need to perform this step, as Webgility automatically updates data when you click Refresh in Step 3.

However, if sales channel data isn’t updating correctly, follow these troubleshooting steps:

  1. Go to Connections.

  2. Click on Preferences, then select Product Settings.

  3. Open the drop-down and select Scratch.

  4. Click Continue when the confirmation popup appears.

  5. Click Save to complete the process.

🔄 This will redownload all product information from your connected sales channel.

🧠 Best Practices

  • Use unique SKUs in your product catalog across all systems.

  • Regularly refresh data from QuickBooks and your sales channel.

  • Review product matching rules after major changes to your product list or connected systems.