Abandoned Carts

[Jimbola]

Hi all,

 

I'l looking at the Customers>Carts screen on my admin, it used to show all the carts that had been generated but this became a huge list. Now it can't load the page.

 

Is there anyway in my Database that I can easily delete carts that are over say 1 year old? or manage the carts data in any way.

 

Thanks

[phrasespot]

Is there anyway in my Database that I can easily delete carts that are over say 1 year old?

 

Take a DB backup first

 

Assuming your table prefix is ps_ (modify accordingly if not) issue the following statement using PHPMyAdmin or similar

 

DELETE FROM `ps_cart`
WHERE `id_cart` NOT IN (SELECT `id_cart` from `ps_orders`)
AND `date_upd` < DATE_SUB(NOW(), INTERVAL 1 YEAR)

 

On re-consideration, this is a bad way to do it as it may, under some circumstances (e.g. when there are combinations for an item in a cart etc), leave your DB in an inconsistent state. Removing carts are quite a bit more involved than this, seek professional help.

Edited October 26, 2012 by phrasespot (see edit history)

[ipcomp1]

Hello

 

do you know if this compitable to version 1.5.1 ?

 

"DELETE FROM `ps_cart`

WHERE `id_cart` NOT IN (SELECT `id_cart` from `ps_orders`)

AND `date_upd` < DATE_SUB(NOW(), INTERVAL 1 YEAR)"