osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

Delete all Pending orders

This is a discussion on Delete all Pending orders within the osCommerce 2.2 Installation Help forums, part of the osCommerce 2.2 Forums category; Greetings- I've been running some test orders on the cart to verify my SSL stuff and troubleshooting in general. Now, ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Installation Help

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 12-21-2002, 03:42 PM
sheikyerbouti's Avatar
Member
 
Join Date: Oct 2002
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
sheikyerbouti
Default Delete all Pending orders

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 12-21-2002, 04:26 PM
Active Member
 
Join Date: Oct 2002
Location: Arkansas
Posts: 149
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
modom
Default

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.
__________________
Sincerely,
Melinda

www.designhosting.biz
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 12-21-2002, 04:50 PM
sheikyerbouti's Avatar
Member
 
Join Date: Oct 2002
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
sheikyerbouti
Default

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

-pete
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
HELP!!! Check Out - pending AdamElder osCMax v2 Customization/Mods 1 08-29-2006 02:57 PM
order statuses mismatch (pending vs cancelled) kfree osCommerce 2.2 Modification Help 0 04-16-2005 04:52 PM
Paypal orders status = pending pablovel osCommerce 2.2 Modification Help 2 12-30-2004 08:35 PM
Order Status: Pending twinklep osCommerce 2.2 Modification Help 0 10-12-2004 08:18 AM
Can not see Pending orders jdhunter osCommerce 2.2 Installation Help 8 06-12-2004 04:10 PM


All times are GMT -8. The time now is 09:38 PM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax