Is there a way to purge all pending cart sales?

[Ripper]

I have a client who is running a special Black Friday sale. He says people are putting items in their cart already, and waiting until Friday to purchase. We wants to make sure they don't do that. What can he do so everyone has an equal playing field?

[Ripper]

Here is the sale page
http://www.vintagedoublehose.com/sto...index&cPath=36

[DrByte]

There are 2 tables which store customer shopping-basket details. You'll need to truncate both of those tables.
NOTE: Doing this will purge EVERYONE's shopping basket, including those who legitimately added stuff last week but haven't completed their decisions yet.

One way to do it quickly is to paste the following into the Admin SQL Patch tool and click send:

TRUNCATE TABLE customers_basket;
TRUNCATE TABLE customers_basket_attributes;

[Ripper]

Thanks for the help. Is there a way he can set up that sale page to avoid this? I am more of the behind the scenes guy, I have no idea how to actually use the cart on the retail side....

[DrByte]

You can't avoid people filling their carts.

But, you could maybe turn off the Multiple Add To Cart buttons at top and bottom, thus making the qty fields turn into buy-now buttons. And *that* might deter them slightly.
But, changing that will affect *all* product listings.

Admin->Configuration->Product Listing->Display Multiple Products Qty Box Status and Set Button Location --- set it to 0
And then after the sale is over, you can leave it at 0, or put it back to whatever you had it at (probably 3 right now).

[Ripper]

OK, thanks. I'll tell the cart owner what you said......

[Ripper]

The SQL patch didn't work. I put stuff in my cart, then added the 2 lines of code into the patch editor and the items were still in my cart after going back to the shopping cart page (after closing the window, then starting over)

[Ripper]

OK, I exported the two customer basket tables into an Excel document and it appears the tables are empty, yet I am still seeing these items in my cart. What am I doing wrong?

[DrByte]

Did you log out?
Does the store have any addons which change the core methods used by Zen Cart to handle cart contents?

[Ripper]

I wasn't logged in at the time.

Add-ons include Better Together Discount Module for Zen Cart 1.3 Version 2.0 and Quantity Discounts Module for Zen Cart 1.3.5 and above Version 1.10. The only other chages are cosmetic.