Erase everyones basket

[poil11]

How would i go about erasing what everyone put into there basket. What sql command would i have to do to do this?

[Ajeh]

If you want to remove *ALL* customer saved shopping carts ...

You need to empty the tables:
customers_basket
customers_basket_attributes

This can be done via phpMyAdmin ...

NOTE: might want to ensure no one is shopping when you go to do this ...

[poil11]

perfect, thats exaclty what i needed.

Because products sell out so fast in my shopping cart that people are starting to complain that they can't check out because the poster that they put in there cart last week was still in there cart. So i am just going to do that after every week, so ease the customers stupidity