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

How to Fix the “Invalid Column Name” Error During Order Downloads in Webgility Desktop

This article helps Webgility Desktop users troubleshoot and resolve the “Invalid Column Name” error in Webgility Desktop encountered during order downloads, often caused by outdated application versions or changes in order data structure. It guides users through updating the application, disabling automated schedulers, and removing duplicate entries from manual processing.

Root Cause

This error typically occurs due to one or more of the following reasons:

  • You're using an outdated version of Webgility Desktop that no longer matches the current data format used by your sales channels.

  • You’ve manually posted orders while leaving the scheduler enabled, which can result in duplicates or sync conflicts.

Step-by-Step Resolution 

Step 1: Check and Update Webgility Desktop

  1. Open Webgility Desktop.

Navigate to:

Help > Check for Updates

  1. Check your current version number.

  2. If you're not on the latest version, download the latest release from the Webgility Portal.

  3. Install the update and restart the application.

  4. Try downloading orders again to check if the issue is resolved.

Step 2: Disable the Scheduler (If You Use Manual Order Posting)

To avoid duplicate orders, if you prefer manual control, stop the scheduler from the system tray.

Step 3: Perform Manual Download & Remove Duplicates

If you've already posted some orders manually:

  1. Manually download any new orders.

  2. Review downloaded orders and compare with those already posted to QuickBooks.

  3. Delete any duplicate entries from Webgility Desktop and QuickBooks Desktop if necessary.

Pro Tip:
 To maintain accuracy and avoid errors, reconcile orders manually regularly, especially if you're not using automation.