How To Delete Processing Orders From Admin

[ace21187]

Hello,

On my main admin page it says there are 10 Orders Processing. However, when I go into the order section to delete them it doesn't show any orders. This is because I was having a problem where no order number was assigned when a purchase was made.

 

Does anyone know how I can delete these 10 Orders? Is it possible to do it manually through the database? If so let me know.

 

Thanks,

Dan

[davidinottawa]

Does anyone know how I can delete these 10 Orders? Is it possible to do it manually through the database? If so let me know.

 

delete from orders where orders_status = 1

 

you can also verify your orders_status value by browsing the orders_status table

 

david

[ace21187]

delete from orders where orders_status = 1

 

you can also verify your orders_status value by browsing the orders_status table

 

david

 

 

David,

I see both the orders and order_status tables from MyPhPAdmin. What do I delete and do I have to then re-create it?

 

Thanks,

Dan

[davidinottawa]

David,

I see both the orders and order_status tables from MyPhPAdmin. What do I delete and do I have to then re-create it?

 

just go to your database, and hit the SQL window and run this command to verify what you are deleting :

select * from orders where orders_status = 1

 

you should see your ten orders.

 

now go back to the SQL window and delete these records using :

delete from orders where orders_status = 1

 

that's it. nothing else to do

 

If you do not see your ten orders with the select statement, then that means that you have the Processing set to something other than 1 in your orders_status table.

 

david

[ace21187]

David,

 

Thanks a lot!

 

Dan