Order-Export. Defining fields to be exported

  • Posts: 39
  • Thank you received: 4
  • Hikamarket Frontedition Hikashop Business
1 week 8 hours ago #369630

-- HikaShop version -- : 6.1.1

1. Where can I specify which fields are exported? If i exporting Orders to .xls, countless fields are exported that I don't need.

2. Also, umlauts are displayed incorrectly, so I think the format is wrong. Österreich = Österreich

3. Exported Products looks like that: 20.8. Bad Radkersburg Jufa<span class="hikashop_product_variant_subname">: Einzelzimmer</span>
Also not good.

Where can I set that?

Thanks in Advance

Last edit: 1 week 8 hours ago by spike252.

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

  • Posts: 26297
  • Thank you received: 4048
  • MODERATOR
6 days 22 hours ago #369633

Hello,

Where are you performing the export.
From the HikaShop backend interface or from the HikaMarket frontend interface?

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: 39
  • Thank you received: 4
  • Hikamarket Frontedition Hikashop Business
6 days 21 hours ago #369641

Hello Jerome,
thx for help. From the Frontend.

Best regards

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

  • Posts: 26297
  • Thank you received: 4048
  • MODERATOR
6 days 8 hours ago #369643

Hello,

Here two forum threads which should help you with your need.
www.hikashop.com/forum/import-export-csv...v-change-header.html
www.hikashop.com/forum/23-market-how-to/...et-order-export.html

The HikaMarket order export works the same than the HikaShop order export.
The order product name is not altered, so the HTML tag added for options is not striped.
Regarding the "umlauts", I do have the felling that the issue is more regarding the UTF-8 encoding. Please perform a test with a CSV export and open the file with a text editor where you can see/set the encoding.

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: 39
  • Thank you received: 4
  • Hikamarket Frontedition Hikashop Business
6 days 8 hours ago #369646

Thanks for the reply, but I can't identify individual fields that shouldn't be exported in the export.php file.

And the HTML tag for variants cannot be removed either?

Or is the only option to write a Hikashop plugin onBeforeOrderExport that takes over these functions?

Or have I misunderstood something?

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

  • Posts: 26297
  • Thank you received: 4048
  • MODERATOR
3 days 8 hours ago #369660

Hello,

The order export customization is the same for HikaShop and HikaMarket.
It is possible to use "view overrides" or " plugin trigger".

The two forum threads are talking about the two solutions ; but you can find more threads in this forum with more example and maybe some PHP code which will suits your needs.

The idea behind the view override is to allow you to add some PHP code to remove content in the " $row " array, so these entries won't be exported.
As you can see in the view, 3 entries are modified before the "writeLine($row)" to improve the display of some date variables.

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.
The following user(s) said Thank You: spike252

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

Moderators: Obsidev
Time to create page: 0.051 seconds
Powered by Kunena Forum