Skip to main content

Csv Export columns

12 years 6 months ago #151360 by Thunder1001
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.

12 years 6 months ago #151375 by Xavier
Replied by Xavier on topic Csv Export columns
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.

12 years 6 months ago - 12 years 6 months ago #151450 by Thunder1001
Replied by Thunder1001 on topic Csv Export columns
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
Last edit: 12 years 6 months ago by Thunder1001.

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

12 years 6 months ago #151514 by Xavier
Replied by Xavier on topic Csv Export columns
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.

12 years 6 months ago - 12 years 6 months ago #151599 by Thunder1001
Replied by Thunder1001 on topic Csv Export columns
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.
Last edit: 12 years 6 months ago by Thunder1001.

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

12 years 6 months ago #151667 by Xavier
Replied by Xavier on topic Csv Export columns
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.

12 years 6 months ago #151735 by Thunder1001
Replied by Thunder1001 on topic Csv Export columns
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.

12 years 6 months ago #151764 by Xavier
Replied by Xavier on topic Csv Export columns
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.091 seconds
Powered by Kunena Forum