automate delete abandoned Carts

[rb10]

Hi, there is a way to delete abandoned Carts after 48 hours ?

 

Thanks

[rb10]

Hi, im thinking about create a cron task, that delete directly in sql ? 

Could be possible?

[Guest]

Not sure about time scales, but there is a free module : https://mypresta.eu/modules/administration-tools/database-optimization.html

[rb10]

1 minute ago, haylau said:

Not sure about time scales, but there is a free module : https://mypresta.eu/modules/administration-tools/database-optimization.html

This have possibility to automate delete cart ?

[Guest]

I think that it is manual. But talk to the developer directly - there is a pro-version also

[Guest]

Actually the pro version does look automated

https://mypresta.eu/modules/administration-tools/database-optimization-pro.html

[rb10]

ok, thanks i ll try to contact him, 

[rb10]

meanwhile im wait reply, i have found this sql query

$sql = "DELETE psez_cart_product FROM psez_cart_product JOIN psez_cart ON psez_cart.id_cart = psez_cart_product.id_cart WHERE DATE(psez_cart.date_add) < DATE_SUB( NOW( ) , INTERVAL 48 HOUR)";

and 

$sql = "DELETE FROM psez_cart WHERE DATE(psez_cart.date_add) < DATE_SUB( NOW( ) , INTERVAL 48 HOUR)";

Could be correct? 

Could be  insert this inside a php script and do a cron task of this script ?

Thanks

[rb10]

Anyone thing this is correct?