Jump to content
rayleic

export order details by SQL manager Prestasho 1.7.6

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`)

Share this post


Link to post
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...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More