cancel
Showing results for 
Search instead for 
Did you mean: 

How to generate/export a custom format of CSV file?

How to generate/export a custom format of CSV file?

Hi there.

I hope some one can help me.

 

Now, I want to generate a csv file about my sales order, but I think existing magento 2 csv format is not my expectation.

Could anyone can help me how to generate the below CSV file format through magento 2 admin export function. 

 

The below image is my expect result: 

ExportCustomCSV.jpg

 

1 REPLY

Re: How to generate/export a custom format of CSV file?

In Sales -> Orders section of Magento 2  you can export to get the CSV file with predefined set of columns.

 

magento export orders.png

 

Unfortunately, there is no default means export ordered items and their qty (as in your screenshot). So you need to use some script to select out info or extension.

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.