Order Export Error (QuickBooks plugin)

-- HikaShop version -- : 2.2.1
-- Joomla version -- : 3.1.5

I've installed the QB plugin available from www.hikashop.com/component/updateme/ctrl...uickbooksexport.html

When I go to Orders | Export, I get the following error:
1054 Unknown column 'a.all' in 'where clause' SQL=SELECT * FROM vy2dr_hikashop_field as a WHERE a.`field_published` = 1 AND a.`all`=1 AND a.field_table='order' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') ORDER BY a.`field_ordering` ASC

NOTE: I tried disabling the QB plugin and received the same error.

Hi,

It's a problem linked with the export, not with the quickbooks plugin.
Please see the fixing patch here:
www.hikashop.com/forum/import-export-csv...commande.html#123774

This patch will be include in the next HikaShop release : 2.2.2

Regards,

Were can I find the Hikashop quickbooks plugin ?

The link above doesn't work.

Hi,

You can find it here:
www.hikashop.com/component/updateme/ctrl...uickbooksexport.html

OK perfect. Tnx

Two questions:
1. Is it possible to include a column with manufacturer name of the product ? in the QuickBooks plugin ?

2. I have a custom field in Table: product with column name: tester. Is it possible to include a column with this custom field in the QuickBooks plugin ?

Hi,

There are no options in the plugin to do that. But you can customize the code of the plugin in order to do that if you want.

ok tnx for reply.

Any advice of what line of code to implement in the quickbooksexport.php file in order to get a column with manufacturer name of the product that have been ordered ?

Hi,

Well, it's not that easy as you first need to load the data of the manufacturers of the products which will require two MySQL queries and then you need to add the data to the product data exported in the CSV.
If you're a skilled developer, an afternoon should be enough to implement that, but it's not something I can do for you here.