Export via Mass action ends up in blank screen

  • Posts: 27
  • Thank you received: 0
  • Hikashop Essential
1 year 10 months ago #342530

-- HikaShop version -- : 4.6.0
-- Joomla version -- : 2.5.28
-- PHP version -- : 5.6.40
-- Browser(s) name and version -- : Firefox 100.0.|1

Hi,
I would love to see the creation date for all orders in the standard export but as I can't see it's there, I have tried to create a Mass Action process to export a list, including order_created.

For some reason the process just ends up in a blank screen. Potentially happening because of the unfortunate combination of my Joomla version and the latest Hikashop version but still wish to get the dates showing in an exported list ;)

Thanks,

Andor

P.S. Would adding the date_created in the standard export require much work?

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
1 year 10 months ago #342538

Hi,

The order_created column is already in the standard export:
i.imgur.com/sU5QJpd.png

Regarding the blank page when you do the mass action, please activate the "error reporting" and "debug mode" of the Joomla configuration and try again. That should display an error message which should help us understand what's going on.

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

  • Posts: 27
  • Thank you received: 0
  • Hikashop Essential
1 year 10 months ago #342541

Thanks for your quick response.

My standard export doesn't look like that and doesn't include the order_created field. I suppose it's better then for me to focus on getting the standard export right instead of creating a mass action process.

Where do I edit the columns to add the order_created to the standard export? In a php file or is it available directly in the backend admin?

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
1 year 10 months ago #342544

Hi,

There is actually no way to remove columns from the standard export. It's supposed to contain all the columns, including the order_created column.
The only way to not have that column would be to purposefully modify the order / export view file to add custom PHP code to remove it.

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

  • Posts: 27
  • Thank you received: 0
  • Hikashop Essential
1 year 10 months ago #342552

Strange - the export.php file in \views\order\tmpl has not been changed and when I look at the code, the date should show up in the export.

When I run the standard export process, no errors. When trying the Mass Action, I get:

Fatal error: Class 'dbug' not found in .../administrator/components/com_hikashop/classes/massaction.php on line 2797

However, if we find out what's wrong with the standard export, I won't need the Mass Action process.

What do you suggest?

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
1 year 10 months ago #342554

Hi,

Well, if you didn't customize the export, then the column has to be in the CSV.
Can you double check ?
Could you provide a copy of the CSV ?

Regarding the error with the mass action, download again the install package on our website and install it on yours and it should remove it.

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

  • Posts: 27
  • Thank you received: 0
  • Hikashop Essential
1 year 10 months ago #342577

These are the headings from my standard export:

Attachments:

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
1 year 10 months ago #342582

Hi,

I think you must be using the QuickBooks Export plugin:
www.hikashop.com/marketplace/product/216...port-by-obsidev.html
That plugin modifies the format of the CSV export on the fly so that it matches with what QuickBooks need.
So edit the file plugins/hikashop/quickbooksexport/quickbooksexport.php and add the order_created column in the list of columns in the code of the plugin and you'll get that extra column.

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

  • Posts: 27
  • Thank you received: 0
  • Hikashop Essential
1 year 10 months ago #342587

Hi again,

Something really odd happened: I added the QuickBooks Export plugin last week, since the date hasn't showed up over the last months.

I just deactivated the plugin and now the standard export shows more fields/columns than ever, including the order_created.

Problem solved (for some reason :) )

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

  • Posts: 27
  • Thank you received: 0
  • Hikashop Essential
1 year 10 months ago #342704

Hi again,

Back to square 1.5: exported today and got the following:

  • All orders, without order lines, on top of the csv - the last field/column: item6_order_product_discount_info
  • Below the orders, all the order lines

Combining these two sets of data works for me. However, the next export just showed the top part, i.e. all the orders but no order lines.

What do you suggest to do to get it right?

Thanks,

Andor






Thought that was

All orders, with columns up to field item8_order_product_discount_info, without any data in the "items columns"

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
1 year 10 months ago #342707

Hi,

I'm sorry but I don't understand what you mean.
Could you provide some screenshots to illustrate the issue ?

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

  • Posts: 27
  • Thank you received: 0
  • Hikashop Essential
1 year 10 months ago #342714

Hi,
The file I'm attaching is what I get now when exporting, i.e. a list of orders but no order items.

File Attachment:

File Name: 00Testexport.csv
File Size:8 KB

Attachments:

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
1 year 9 months ago #342756

Hi,

Thank you. I was able to reproduce the issue. It comes from a change made in the 4.5.1 which break the system adding the product data to the CSV.
I've added a patch on our end to fix that.
Download again the install package of the 4.6.0 on our website and install it on yours and you'll have the patch.

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

  • Posts: 27
  • Thank you received: 0
  • Hikashop Essential
1 year 9 months ago #342764

Hi,

Thanks for the update - it works now.

However, the data in some of the export fields contain html and other code, e.g.:

  • Feld 'item_1_order_product_name': <span class="hikashop_product_variant_subname">
  • Field 'item_1_order_product_options':{s:25:"variant_characteristic_id";s:2:"45";s:18:"variant_product_id";s:3:"461";s:8:"ordering";s:1:"0";s:17:"characteristic_id";s:2:"45";s:24:"characteristic_parent_id";s:2:"44";s:20:"characteristic_value";s:11:"

It seems as if this happens when I have product variants.

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

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
1 year 9 months ago #342769

Hi,

That's indeed the case.
The name of a variant contains first the name of the main product and then the generated name with the characteristic values with an HTML tag around it.
And the "options" setting indeed contains a serialized object of data relative to the characteristic used / variant / option.
This has always been like that as that's what's saved in the database.

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

Time to create page: 0.095 seconds
Powered by Kunena Forum