How to solve WooCommerce Order Download and Sales Tax Mapping Issues in Webgility Desktop
This article helps Webgility Desktop users address issues with WooCommerce order downloads and sales tax mapping in Webgility Desktop. It covers managing application versions, verifying sales channel connection, configuring sales tax settings, and resolving common connection problems such as blocked IP addresses, incorrect URLs, and version mismatches.
Overview
This article provides steps for troubleshooting issues with WooCommerce order downloads and sales tax mapping in Webgility Desktop. It covers how to handle application versioning, store credentials, sales tax configuration, and how to resolve common connection problems like blocked IP addresses, incorrect URLs, and version mismatches.
Issue Summary
You might be unable to download WooCommerce orders due to credential errors, limited order history, or issues with sales tax. This guide will help you address these common problems.
Step-by-Step Troubleshooting
- Verify Store Credentials
Accurate login details are essential for Webgility to connect to your WooCommerce store.
- Ensure the WooCommerce admin username and password you are using in Webgility Desktop are correct.
- If access fails, you may need to reset the password directly in your WooCommerce admin panel.
- Check WooCommerce Application Version
Keeping your WooCommerce platform updated helps prevent compatibility issues.
- Log in to your WordPress dashboard.
- Navigate to WooCommerce > Status.
- Confirm that the installed WooCommerce version is current (at least 9.6.6 is recommended for compatibility).
- If your WooCommerce version is outdated, perform an upgrade:
- Backup your site before proceeding with any updates.
- Update WooCommerce via Plugins > Installed Plugins > Update Now on WooCommerce in your WordPress dashboard.
- Evaluate Order Download Issues
After confirming your credentials and WooCommerce version, test the order download.
Attempt to download orders in Webgility Desktop (Get Orders).
- If the download still fails, recheck your credentials and ensure the WooCommerce user has appropriate permissions (e.g., Administrator role).
- If possible, test connecting with a different admin account in WooCommerce.
- Analyze Sales Tax Mapping via CSV File
If you're facing issues with sales tax mapping, especially for multi-state taxes, you'll need to review your data and settings.
- If you have a provided sales tax CSV file, open it in spreadsheet software.
- Check for proper alignment of state codes, order values, and tax amounts.
- Validate if sales tax is computed for each relevant state in the CSV.
- If mapping is incorrect:
- Reconcile order data fields (e.g., shipping address state vs. tax applied) in the CSV.
- Cross-check tax rates against your WooCommerce Tax settings (WooCommerce > Settings > Tax).
- Also, check your Webgility sales tax settings under Connections > Accounting > Sync settings > Sales tax.
- Compare the order tax displayed in Webgility Desktop with the actual tax on the corresponding order in WooCommerce.
Other Common Connection Issues & Troubleshooting
Beyond version and credential checks, other factors can affect your connection.
Blocked Webgility Extension Access
Your WooCommerce store's security settings might be blocking Webgility from connecting.
- Solution: Whitelist Webgility IPs Please whitelist the following IP addresses in your WooCommerce hosting environment. This allows Webgility to communicate with your store securely:
- 183.182.84.170
- 111.118.255.21
- 54.69.99.71
Incorrect Webgility Extension URL
Using the wrong URL when setting up the connection can cause problems.
- Double-check that you're entering the correct Webgility Extension URL.
- For detailed connection steps for your platform:
Incorrect WooCommerce Admin Credentials
Always make sure you are entering your accurate WooCommerce admin username and password when connecting your store in Webgility.
Outdated Webgility Extension
If your WooCommerce store has been updated but your Webgility Extension has not, you might see errors like:
- 403 Forbidden
- 500 Internal Server Error
To update your Webgility Desktop application:
- If you're already logged in: Click Help > Check for Updates > Update within Webgility Desktop.
- If you're unable to log in: Download and install the latest version from portal.webgility.com.
To update your Webgility WooCommerce Connector plugin:
- Download the latest Webgility/WooCommerce integration plugin. The latest version is available from your Webgility account portal. Log in to portal.webgility.com and navigate to the Downloads section to find the WooCommerce plugin file.
- Log in to your WooCommerce admin panel.
- Go to Plugins > Add New > Upload Plugin and select the update package you downloaded.
- Click Install Now, and then Activate the updated module.
- Confirm the successful update under your Plugins list.
Troubleshooting Error Messages (General)
When you test your store connection in Webgility Desktop (Go to Connections > Sales Channels > Manage Sales Channel > Edit Connection > Test Store Connection), you might see messages like:
- "We are facing an issue while processing your request. Please try again later."
- "The remote server returned an error. (501) Service Temporarily Unavailable."
- "Not able to connect to WooCommerce."
🛠 How to Fix These Errors
Step 1: Test Extension URL in Browser Paste your Webgility Extension URL into your browser. If it returns an error such as:
- 403 Forbidden
- Page Not Found
- Access Denied
Continue with the checklist below.
Step 2: Checklist to Resolve Access Errors
- Ensure the following IPs are whitelisted: 183.182.84.170, 111.118.255.21, 54.69.99.71
- Confirm that your Webgility files on your hosting server have Read/Write/Modify permissions.
- Make sure you're using the latest version of Webgility Desktop. (Help > Check for Updates > Update)
- Upgrade to the latest Webgility Extension for WooCommerce if needed (download from portal.webgility.com).
Verifying Webgility Extension Version Paste the Webgility Extension URL into your browser. The version number will be visible at the top of the page. Ensure it matches the latest release available from portal.webgility.com.
Connection Tips
If you're still having trouble connecting:
- Try modifying the URL format:
- Add or remove www
- Switch from http to https or vice versa
Additional Recommendations
- Regularly update your WooCommerce and WordPress core alongside your Webgility Desktop application.
- Always ensure you're using compatible versions of plugins and Webgility Desktop.