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

How to solve SKU Mapping and Scheduler product Sync issues

This article helps Webgility Desktop users in addressing issues where product price and quantity fail to sync properly between WooCommerce channel and QuickBooks Desktop. It focuses on troubleshooting SKU mapping discrepancies and ensuring scheduled sync automation functions correctly.

This article documents the investigation and resolution workflow regarding issues with product price and quantity not syncing between a website and the underlying product management system, focusing on SKU mapping and scheduled sync automation using the WooCommerce plugin.

Troubleshooting Steps

1. Verify Product Synchronization: Confirm the scope: price, quantity, or both not updating.

2. Review SKU Mappings: 

  • Navigate to the WooCommerce Products listing.
  • For affected products, compare the SKU values in WooCommerce with the QuickBooks company file.
  • Correct any discrepancies, such as typos or mismatches in WooCommerce.

3. Correct SKU Mappings: 

  • Update affected products directly in WooCommerce:
    • Go to Products > Edit for each product in WooCommerce.
    • Update the SKU field to match the authoritative record from the external system.
    • Save changes after editing each SKU.

4. Test Manual Sync: 

  • Trigger a manual sync using the plugin or integration settings
  • Confirm that prices and quantities on the website reflect the latest data source values.

5. Activate & Verify Scheduler: 

  • If not active, enable automatic sync and adjust frequency as required (e.g., hourly, daily).
  • Monitor scheduled task logs to confirm automated updates are completing without error.
  • Review at least one scheduler cycle post-fix to ensure that corrections persist.