En este tutorial te enseñamos cómo puedes exportar fácilmente los teléfonos de tus clientes en PrestaShop 1.6. Aprende más sobre PrestaShop en https://www.PrestaRadio.com
El Código de la Consulta a usar es:
SELECT c.firstname AS “Nombre”, c.lastname AS “Apellidos”, c.email AS “Email”, c.birthday AS “Fecha de nacimiento”, GROUP_CONCAT(a.phone SEPARATOR ‘ | ‘) AS “Teléfonos”, IF(c.newsletter, “Sí”, “No”) AS “¿Suscrito a la newsletter?”, IF(c.is_guest, “No”, “Sí”) AS “¿Está registrado?”
FROM `ps_customer` AS c INNER JOIN `ps_address` AS a ON a.id_customer = c.id_customer
WHERE c.deleted = 0 GROUP BY c.id_customer
Deja un comentario