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

How to Fix SKU Mismatches and Posting Failures for WooCommerce Orders in Webgility Desktop

This guide helps Webgility Desktop users troubleshoot issues where product SKUs appear missing or incorrect in WooCommerce orders, or when such orders fail to post to QuickBooks Desktop. It outlines common causes like SKU mismatches, sync errors, plugin conflicts, and integration misconfigurations, providing targeted solutions to resolve these problems effectively.

Symptoms

You may be affected by this issue if:

  • Product SKUs are incorrect or missing in WooCommerce orders.

  • Orders fail to post from Webgility to QuickBooks Desktop.

  • Certain orders return errors during posting despite prior fixes.

Step-by-Step Troubleshooting

1. Confirm the Issue

  • Open Webgility Desktop and review recent sync errors (via the Error tab).

  • Look for error messages tied to SKU mismatches or posting failures.

  • Note any error codes, product references, or order IDs for further analysis.

2. Check SKU Consistency Across Platforms

In WooCommerce (WordPress):

  • Log in to your WordPress Admin Dashboard.

  • Go to Products > All Products.

  • Ensure each product has a unique, valid SKU.

In Webgility Desktop:

  • Make sure Webgility is updated:

    • Go to Help > Check for Updates > Update.

    • If you cannot log in, download the latest version from portal.webgility.com.

  • Ensure the Webgility WooCommerce Connector plugin is updated:

    • Download the latest plugin from the Webgility portal.

    • In WordPress, go to Plugins > Add New > Upload Plugin and install the new file.

    • Activate the plugin after installation.

Trigger Manual SKU Sync:

  • In Webgility Desktop, go to Products > Get Products to pull updated product data from WooCommerce.

3. Investigate Order Posting Failures

  • In Webgility Desktop, go to the Error tab, open a failed order, and click View History.

  • Review error details:

    • Are they related to SKUs?

    • Are there issues with customers, taxes, or item mappings?

4. Apply Fixes Based on Findings

Fix SKUs in WooCommerce:

  • Correct missing or duplicate SKUs in the WordPress product settings.

  • Use WooCommerce’s import/export feature for bulk SKU updates.

Reconnect QuickBooks Integration:

  • In Webgility Desktop, go to:

    • Connections > Accounting / POS > Manage Accounting / POS > Edit.

  • Reconnect your QuickBooks company file:

    • Click Test Connection or Reconnect.

    • Confirm item mappings recognize the correct SKUs.

Verify WooCommerce Connector Plugin Activation:

  • In WordPress, go to Plugins > Installed Plugins.

  • Make sure the Webgility Connector is active and up to date.

5. Test & Validate

  • Place one or more test orders in WooCommerce.

  • In Webgility Desktop, post these test orders to QuickBooks.

  • Confirm successful posting with no errors.

  • Monitor for ongoing issues, especially those tied to:

    • Item mappings

    • Tax configurations

    • Customer records

General WooCommerce Integration Issues & Fixes

Blocked Webgility Access

Your host’s firewall might block Webgility’s connection to WooCommerce.

Solution: Whitelist the following IPs:

  • 183.182.84.170

  • 111.118.255.21

  • 54.69.99.71

Incorrect Extension URL

If you entered the wrong extension URL, the integration may fail.

  • Ensure the Webgility Extension URL is correct.

  • Modify the format if needed:

    • Add/remove www

    • Switch between http and https

Incorrect Admin Credentials

  • Always use valid WooCommerce admin credentials when connecting in Webgility.

Outdated Webgility WooCommerce Plugin

Errors such as 403 Forbidden or 500 Internal Server Error may indicate an outdated connector.

To update:

  1. Download the latest plugin from the Webgility Portal.

  2. Log into WordPress > Plugins > Add New > Upload Plugin.

  3. Install and Activate.

  4. Confirm version under Plugins list.

Troubleshooting Error Messages

Common Errors:

  • “We are facing an issue while processing your request.”

  • “The remote server returned an error. (501) Service Temporarily Unavailable.”

  • “Not able to connect to WooCommerce.”

Fixes:

Step 1: Test Extension URL

  • Paste your Webgility Extension URL into a browser.

  • If it returns:

    • 403 Forbidden

    • Page Not Found

    • Access Denied

...proceed to Step 2.

Step 2: Troubleshooting Checklist

  • Whitelist the following IPs: 183.182.84.170, 111.118.255.21, 54.69.99.71

  • Ensure plugin files on your hosting server have read/write/modify permissions

  • Use the latest version of Webgility Desktop and the WooCommerce plugin

  • Paste your extension URL into a browser—confirm that the version number displayed matches the current release in the Webgility portal