[Solved] How to generate a Delivery Slip CSV report

[Flatstanley]

Hello,

Does any one know of a report that can generate a CSV file of all orders that have delivery Carrier details on it.

Eg.
Order #5, Home Delivery
Order #6, Pickup

etc.

[shokinro]

I think you can use database tool to export the table ps_orders in CSV/XLS format.
At least PhpMyAdmin can do this.

but because database ps_orders only saves IDs, you need to convert ID to name of carrier.

id_order, is_carrier

Or maybe you can find some free/paid modules to do that.

[Flatstanley]

Thank you for your information.

I have inspected the database as per your recommendation.

[shokinro]

if you know how to use SQL statement, then it is much more easy.

Here is the SQL statement that will return OrderID,CarrierID,CarrierName

SELECT id_order,c.id_carrier,C.name FROM `ps_orders` O LEFT JOIN ps_carrier C on O.id_carrier=C.id_carrier