Csv Export columns

  • Posts: 16
  • Thank you received: 0
10 years 7 months ago #151360

Hi,
I create a csv after each order with fields "Name", "Product_id" and "orde_product_quantity"
Then a customer order 2 or more products i get this in my csv.

"name";"item1_product_id";"item1_order_product_quantity";"item2_product_id";"item2_order_product_quantity"
"test";1221259180;1;1221259170;1

Is it possible to get it line by line instead of item1, item2, item3.... like:
"name";"item_product_id";"item_order_product_quantity";
"test";1221259180;1;
"test";1221259170;1;
etc....

Tom

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

  • Posts: 13201
  • Thank you received: 2322
10 years 7 months ago #151375

Hi,

I don't really understand what you want.
Currently the csv looks indeed like:

"name";"item_product_id";"item_order_product_quantity";
"test";1221259180;1;
"test";1221259170;1;

If you want another display, the easiest way will be to use the mass actions and create your own plugin to add a specific export action in order to manage the display in the csv file.

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

  • Posts: 16
  • Thank you received: 0
10 years 7 months ago #151450

Hi,
I attached some files.
If the example i maked one order with 3 different products.
The h0958cc3.jpg are my settings
The h96b7ebd.csv is the file that i get with those settings when i create a order with a test customer.
The h5399f22.csv is what i need.

It's better for our erp package to import a file where i get it line by line instead of Item1, Item2, item3...

Maybe you understand better with the file? :-)

Friendly Regards,
Tom

Attachments:
Last edit: 10 years 7 months ago by Thunder1001.

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

  • Posts: 13201
  • Thank you received: 2322
10 years 7 months ago #151514

Hi,

Sorry but I'm not able to open your csv files, maybe they are corrupted.
Thanks to make screenshots.

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

  • Posts: 16
  • Thank you received: 0
10 years 7 months ago #151599

Hi,
strange cause i can download the files again but I maked a printscreen from the csv files.

The h8b8f910.jpg is the file that i get with those settings when i create a order with a test customer.
The hca038de.jpg is what i need.

Attachments:
Last edit: 10 years 7 months ago by Thunder1001.

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

  • Posts: 13201
  • Thank you received: 2322
10 years 7 months ago #151667

Hi,

Ok I see what you mean, and have reproduced the out on my end.

So that's actually the way it's working, to have another display, at this time you will have to create your own mass action plugin to define the layout for the csv export.
You can see how the current one is working in order to manage it as you want then.

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

  • Posts: 16
  • Thank you received: 0
10 years 7 months ago #151735

Hi,

Can you give me a little bit more info?
witch files do i need to manupilate to define my own layout?.

Greetz

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

  • Posts: 13201
  • Thank you received: 2322
10 years 7 months ago #151764

Hi,

Sorry I forgot the link, here is some documentation to create a mass action plugin:
www.hikashop.com/support/documentation/i...s-action-plugin.html

You can find the existing plugins in the folder "plugins/hikashop/massaction_xx"

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

Time to create page: 0.077 seconds
Powered by Kunena Forum