Delete all Pending orders

[sheikyerbouti]

Greetings-

I've been running some test orders on the cart to verify my SSL stuff and troubleshooting in general. Now, from the Admin page i find that i have 28 orders with the Pending status. I know that i could go through the process of deleting all 28 (one-by-one), but what i'm looking to do is delete all 28 in one fell swoop. Is there a way to do that from the admin page or admin side of the cart?? Otherwise, could someone walk me through the process of doing it with phpMyAdmin? I'm not very accomplished at phpMyAdmin, so i need some detailed instructions if we're going to do it that way. I have this huge fear of wiping out my entire cart via phpMyAdmin.....

Thanks,
Pete

[modom]

Hi Pete,

Do this:
Log into phpmyadmin
Click on the db on the left side
Click on "Structure" on the right side at the top unless already showing
Check the "orders_products" box and empty it (link to the right)...do not "drop" it or you will lose the table.

You may have to do orders, orders_total, or some other ones but do the same way.

If you want to see what is in each table click on the individual table on the right side and click "Browse" at the top.

[sheikyerbouti]

Thanks! That was a piece of cake..... chocolate!

-pete