How To Export Order Details Including Items in CSV

[ruchin78]

Hi,

 

Is there any way that we can export an order line item (means item-wise) in CSV File?

 

 

Regards

Ruchin Sharma

[Scully]

You needed to write a small SQL statement which retrieves the data from the datatbase and run this query from backend -> advanced > database queries. From there you can also export the data.

Edited October 3, 2017 by Scully (see edit history)

[DataKick]

Well, you will most probably need a module. Alternatively you can use direct sql statements and query your database, but that requires quite a lot of knowledge.

 

My module can help you with that - you can export any data from your prestashop into csv or xml format, easily filter data, sort, etc... Look at the following video to see how your particular problem can be solved by this module:

 

[selectshop.at]

You can try this tool (free trial 30 days): https://addons.prestashop.com/en/modules-prestashop/2937-store-manager.html  It imports and exports whatever you want from/to Prestashop in format csv, xml and others.

 

Tutorial: http://store-manager-for-prestashop-documentation.emagicone.com/prestashop-customers-and-orders-management/prestashop-orders-management/export-orders

[Rizzzle]

On 10/4/2017 at 6:01 AM, selectshop.at said:

You can try this tool (free trial 30 days): https://addons.prestashop.com/en/modules-prestashop/2937-store-manager.html  It imports and exports whatever you want from/to Prestashop in format csv, xml and others.

 

Tutorial: http://store-manager-for-prestashop-documentation.emagicone.com/prestashop-customers-and-orders-management/prestashop-orders-management/export-orders

Hello,

Is this application able to export orders to CSV? (For integration with a shipping provider Royal Mail here in the UK)

Thanks,