Order Export Error (QuickBooks plugin)

  • Posts: 96
  • Thank you received: 0
11 years 8 months ago #125281

-- 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.

Last edit: 8 years 6 months ago by nicolas.

Please Log in or Create an account to join the conversation.

  • Posts: 26251
  • Thank you received: 4039
  • MODERATOR
11 years 8 months ago #125284

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,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 344
  • Thank you received: 3
8 years 6 months ago #254652

Were can I find the Hikashop quickbooks plugin ?

The link above doesn't work.

Please Log in or Create an account to join the conversation.

  • Posts: 83932
  • Thank you received: 13588
  • MODERATOR
8 years 6 months ago #254690

Hi,

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

Please Log in or Create an account to join the conversation.

  • Posts: 344
  • Thank you received: 3
8 years 6 months ago #254699

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 ?

Please Log in or Create an account to join the conversation.

  • Posts: 83932
  • Thank you received: 13588
  • MODERATOR
8 years 6 months ago #254704

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.

Please Log in or Create an account to join the conversation.

  • Posts: 344
  • Thank you received: 3
8 years 6 months ago #255789

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 ?

Please Log in or Create an account to join the conversation.

  • Posts: 83932
  • Thank you received: 13588
  • MODERATOR
8 years 6 months ago #255794

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.078 seconds
Powered by Kunena Forum