Cannot Delete 'abandoned Carts'

General General Questions
1

I've been having this strange issue where I can delete abandoned/live carts if the cart has products in it, but I cannot delete them if the cart has 0 products. I have tried using "Delete All Found" and ticking them and then "Delete All Selected" but it doesn't delete the empty carts. Some of the carts are 3 weeks old now and it's getting annoying now.

Is there another way I can delete these carts?

Many thanks in advance

2

Try to run the following query in phpMyAdmin

DELETE FROM cscart_user_session_products WHERE timestamp < 1502371222;

It should delete all carts add before August, 10

3

Thanks for the reply. Unfortunately, this hasn't worked for me, but it's likely I haven't done something properly! I ran it as a SQL query in the database relating to my CS Cart installation; is this correct?

4

Thanks for the reply. Unfortunately, this hasn't worked for me, but it's likely I haven't done something properly! I ran it as a SQL query in the database relating to my CS Cart installation; is this correct?

Right, PM me temporary FTP access so that we can check the issue with empty carts