Module needed for exporting orders shipping adress

[DARKF3D3]

Hi all, I need to automatize the creation of the delivery label, to do this my carrier ask for a csv file with all the order addresses.

There's a module that allow to do this? 

I need to have the possibility to chose a list of orders ready for shipping based on order state or id range.

 

Do you know something that allow this? 

 

PS: It will be a good thing if this module allow also to customize the csv file with the cosen field.

 

 

 

My store uses PS1.6.0.9

[gonebdg - webindoshop.com]

Basically you can do that with Prestashop SQL Manager

Back Office > Advance Parameter >  SQL Manager

 

for example, you can use following SQL query

SELECT o.id_order, o.reference, a.firstname, a.lastname, a.address1, a.address2, a.postcode, a.city, s.name as state, cl.name as country
FROM  ps_address a
LEFT JOIN  ps_orders o ON (o.id_address_delivery = a. id_address)
LEFT JOIN ps_state s ON (s.id_state = a.id_state)
LEFT JOIN ps_country_lang cl ON (cl.id_country = a.id_country)
WHERE a.active = 1 AND a.deleted = 0 AND cl.id_lang = 1 AND o.current_state = 2

Note:

in here the prefix database is ps_

[DARKF3D3]

Thanks for the help, but I'm looking for something more integrated on the website; Something like a module that allow me to chose the order (by order status or chosing them with a checkbox) and then it generate a csv file with my orders addresses and other infos.

 

Maybe you there's someone that can do this by fee?