Jump to content

SQL : Retrouver les paniers abandonnés


Recommended Posts

Hello,

 

J'ai pensé a cette requetes pour retrouver tous les paniers abandonnés, qu'en pensez vous ?

J'ai visiblement bien les bons paniers... :)

SELECT * FROM (

SELECT
CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) `customer`, a.id_cart total, ca.name carrier, 
		IF (IFNULL(o.id_order, 'Non ordered') = 'Non ordered', IF(TIME_TO_SEC(TIMEDIFF('2015-06-23 13:44:00', a.`date_add`)) > 86400, 'Abandoned cart', 'Non ordered'), o.id_order) id_order, IF(o.id_order, 1, 0) badge_success, IF(o.id_order, 0, 1) badge_danger, IF(co.id_guest, 1, 0) id_guest
FROM ps_cart a  
LEFT JOIN ps_customer c ON (c.id_customer = a.id_customer)
		LEFT JOIN ps_currency cu ON (cu.id_currency = a.id_currency)
		LEFT JOIN ps_carrier ca ON (ca.id_carrier = a.id_carrier)
		LEFT JOIN ps_orders o ON (o.id_cart = a.id_cart)
		LEFT JOIN `ps_connections` co ON (a.id_guest = co.id_guest AND TIME_TO_SEC(TIMEDIFF('2015-06-23 13:44:00', co.`date_add`)) < 1800)
) AS toto WHERE id_order='Abandoned cart'
  • Like 1
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...