Jump to content

export order details by SQL manager Prestasho 1.7.6


rayleic

Recommended Posts

hello friends,

There is export function of prestashop default system and here is the offcial docs http://doc.prestashop.com/display/PS17/SQL+Manager
I am trying to export below order details from date ** to date **. How to use SQL manager to do this? I followed the offcial docs but not working. Can anyone help?

Firstname,
Lastname,
Address1,
Address2,
City,
Zip code,
Country,
Product_name, 
TEL,
Reference,
SKU,
Quantity,
Order ID,

SELECT o.`id_order` AS `id`,
    CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `Customer`,
    ca.`name` AS `Carrier`,
    cu.`name` AS `Currency`,
    o.`payment`, CONCAT(o.`total_paid_real`, ' ', cu.`sign`) AS `Total`,
    o.`date_add` AS `Date`
FROM `ps_orders` o
LEFT JOIN `ps_customer` c ON (o.`id_customer` = c.`id_customer`)
LEFT JOIN `ps_carrier` ca ON (o.id_carrier = ca.id_carrier)
LEFT JOIN `ps_currency` cu ON (o.`id_currency` = cu.`id_currency`)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...