Need-Design Posted December 15, 2015 Share Posted December 15, 2015 (edited) Bonjour, Depuis la mise à jour de Prestashop 1.6.1.2, quand nous faisons un export de nos clients via "Clients -> "Exporter", Nous avons bien l'export qui se télécharge en CSV, mais pour autant nous n'avons plus le téléphone du client dans l'export. Comment faire pour modifier cette requête SQL ? Est-ce bien celle-ci ? Si oui, comment faire pour modifier cette requête. En vous remerciant par avance. (Voir image en PJ). SELECT a.`id_customer`, `firstname`, `lastname`, `email`, `company`, a.`active` AS `active`, `newsletter`, `optin` , a.date_add, gl.name as title, ( SELECT SUM(total_paid_real / conversion_rate) FROM ps_orders o WHERE o.id_customer = a.id_customer AND o.id_shop IN (1) AND o.valid = 1 ) as total_spent, ( SELECT c.date_add FROM ps_guest g LEFT JOIN ps_connections c ON c.id_guest = g.id_guest WHERE g.id_customer = a.id_customer ORDER BY c.date_add DESC LIMIT 1 ) as connect FROM `ps_customer` a LEFT JOIN ps_gender_lang gl ON (a.id_gender = gl.id_gender AND gl.id_lang = 1) WHERE 1 AND a.`deleted` = 0 ORDER BY `date_add` DESC LIMIT 0, 50 Edited December 15, 2015 by Need-Design (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now