Module For Deleting Abandoned Carts In 1.6 - I Have About 21.000 Abandoned Carts

[Gomlers]

Hi all.

 

Anyone know of a module or which sql to run, to clean abandoned carts which did not become an order?

 

Right now I have about 21.000 abandoned carts, and I guess it slows my page siteload a bit - even though I have an insane amount of recourses on my server.

 

If you know which sql query I can run, please help.

Or if you know of a module... (Sorry, I hate to say it - but a module like this I'm not interested to pay for - should definately be a corefunction of prestashop)

Edited March 3, 2016 by Gomlers (see edit history)

[Gomlers]

Ok, so there is no on at all in these forums who knows how to write a SQL to delete abandoned shoppingcarts?

[chatoxz]

Hello i need this too, please somebody help us.

thanks.

[Daresh]

Hi,

the Tidy module has an option to automatically delete old abandoned carts (and many more nice features)

[Gomlers]

6 hours ago, Daresh said:

Hi,

the Tidy module has an option to automatically delete old abandoned carts (and many more nice features)

I can confirm that this module works perfect, and does exactly what it is supposed to do - easy and simple to use.

Great work

[Caleydon]

Use the following SQL query

 

DELETE FROM `ps_cart` WHERE id_cart NOT IN (SELECT id_cart FROM `ps_orders`);
DELETE FROM `ps_cart_product` WHERE id_cart NOT IN (SELECT id_cart FROM `ps_orders`);