How to get abandon cart details in custom module?

[powyaa]

Hi All,

 

How to get the abandon cart contents in the custom module. Is anyway please share the comments to get the details.

 

Any ideas??

 

Thanks in advance.

[NemoPS]

Hi there!

You can try something like

 

SELECT c,id_cart, o.id_order

FROM ps_cart c

LEFT JOIN ps_orders o ON (o,id_cart = c.id_cart)

WHERE o.id_order != NULL

 

 

DIdn't test it, but it...should! work

[vekia]

+ INNER JOIN ps_cart_products for cart contents (products)