Delete abandoned carts prestashop 1.6

[chatoxz]

Hi want to delete abandoned carts, i came out with a mysql code after studying the db, can someone tell if it is right?

 

DELETE FROM cart_product

WHERE id_address_delivery = 0;

 

DELETE FROM cart

WHERE id_address_delivery = 0;

 

 

i have to delete something else? i run it on me test environment and works fine.

Greetings

[Daresh]

Having address 0 doesn't mean that the cart is abandoned. Abandoned cart is every cart that didn't turn into an order. I am currently working on a module that will allow to delete old abandoned carts with one click or a cron task, it should be ready tomorrow.

[chatoxz]

Hi thanks for the answer, i know address 0 doesn't mean that the cart is abandoed but what other condition should i check or maybe i not looking at the problem in the right angle.

[Daresh]

You should rather write some script in PHP to iterate carts and delete them, the module I mentioned doing this is ready and available here: Prestashop Tidy