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

Fixing Duplicate Product Issues Caused by Sync Errors in Webgility Online

This article helps Webgility Online users resolve duplicate product listings in their catalog caused by improper product data matching during synchronization between sales channels (e.g., Shopify, WooCommerce) and QuickBooks Online. It provides steps to remove duplicates and prevent them from reoccurring in future syncs.

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 duplicates on the sales channel, then delete the duplicate product on the 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.

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.