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

How to Fix Missing Product Sync Issues in Webgility Desktop with Large Shopify Catalogs

This article helps Webgility Desktop users troubleshoot product sync issues in Webgility Desktop when connected to Shopify with more than 9K products. In large catalogs, newly added products may not appear immediately after syncing. The guide offers step-by-step instructions to manually sync products and ensure complete catalog visibility in Webgility Desktop.

Causes of Issues

  • Shopify product catalog exceeds 9,999 items, causing longer sync durations.

  • Product sync settings may exclude unpublished, hidden, or filtered-out products.

  • Partial sync or incomplete downloads during initial attempt.


Step-by-Step Instructions

1. Verify Inventory Size

  • Log in to your Shopify admin panel.

  • Confirm that your product count exceeds 9,999 items.

  • Understand that syncing a large catalog may take additional time in Webgility Desktop.

2. Check Product Sync Filters

  • Open Webgility Desktop.

  • Go to Products > Settings > Sync Settings.

  • Review sync rules and settings to ensure they don’t exclude new products (e.g., visibility or published status).

3. Download Latest Online Sales Channel Data

  1. Clear Download Dates:
    Go to Integrations > Stores > Advanced Settings > Application tab, and click Clear for "Last download date for Store Item." Save and close.

  2. Refresh Settings:
    Navigate to Integrations > Get Latest Data & Settings.

  3. Download Data:
    In the popup, go to Download online store settings, then click Download Data to refresh from scratch.

  4. Refresh Product List:
    Go to Products > All Products, click the Refresh icon, and wait for the download to complete.


4. Download Latest Accounting Data from Scratch

  1. Clear Accounting Download Dates:
    Navigate to Connections > Sales Channels > Advanced Settings. Clear the "Last Download Date" for both QuickBooks items and QuickBooks Customers, then Save and Close.

  2. Re-Download All Data:
    Go to Connections > Get Latest Data & Settings, click the Download Data dropdown, and select Re-Download All Data.

  3. Download Items from Scratch:
    Open the Products tab, go to QuickBooks > All Products, then click the Download Products from Scratch icon.

5. Check for Product Visibility in Shopify

  • Go to your Shopify Admin.

  • Ensure the newly added products are published and visible to all sales channels.

  • Confirm that each item has a valid SKU and inventory settings.

5. Validate API Connection in Webgility

  • In Webgility Desktop, go to Connections > Sales Channel > Manage Sales Channel > Edit Connection.

  • Re-test the connection to verify that the API is properly linked to your Shopify account.


Notes

  • Products added to Shopify during the sync process may require a second download to appear in Webgility Desktop.

  • For catalogs over 10,000 items, syncs may take several minutes. Avoid interrupting the process.