Victor Font Consulting Group, LLC

The DEX Intranet Specialists

WooCommerce 2.1 Breaks Quickbooks Plugin

By

WooCommerce-Quickbooks Integration Front CoverThe 2.1 update to WooCommerce breaks the WooCommerce-QuickBooks Integration plugin. After the update Sales Orders refuse to push through to QuickBooks. The errors are cryptic and don't seem to have anything to do with the actual problem.

The plugin author, 61extensions.com, has release version 1.2.27 of their plugin that fixes the problem with Sales Orders not pushing through. You must update your plugin to the latest version. There are no workarounds. To update the plugin:

  1. Login to your account at 61extensions.com
  2. Download the latest version of the plugin
  3. Deactivate the plugin in WordPress
  4. Access your server through FTP
  5. Navigate to the plugin directory
  6. Delete the plugin through
  7. Copy new plugin files through FTP
  8. Activate plugin in WordPress

Reactivating the plugin in WordPress may produce the following error:

The plugin generated 181 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin.

A review of the wp-admin error_log shows the following:

[03-Mar-2014 17:27:03 UTC] PHP Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /home/your-domain/public_html/wp-includes/wp-db.php on line 880

I opened a support ticket with the plugin author. This is the response I received:

Hi Victor,

Thanks for letting us know. That just occurs on activation and we'll correct in the next update. It doesn't affect the functionality of the plugin after activation.

Thanks,
Dan

Author's note: I have no affiliation whatsoever with 61extensions.com. The WooCommerce-QuickBooks plugin is a necessity for my site and I enjoy troubleshooting. If you are interested, I've written a troubleshooting guide that addresses all the problems I've encountered either on my own or by helping other people to solve. You can purchase it for instant download below.