Orders not visible in admin section

[steveprice1]

Hellp.

 

I tried to delete my old orders from my oscommerce site. I used phpmyadmin. :thumbsup:

 

I went to the orders tables (there are several of them including orders_status and orders_status_history) and emptied all of the tables (not deleted - just emptied). Bingo!! all the old orders dissapeared. :-"

 

The site still works now. Customers can place orders and receive the correct notification etc. i.e all the order information is being stored in the database. The problem is that the "orders" section of the admin page no longer works. There are no orders available to view and the pending or completed links don't show up. :'(

 

I'm fairly sure that the "orders_status and orders_status_history" should not have been emptied and are the cause of the problem. :blush:

 

Does anyone know what information I need to get back into these tables or have any other good suggestions? (other then "if it works - don't mend it!!) :rolleyes:

 

Thanks & best regards

 

Steve (UK)

[Nullachtfuffzehn]

If you emptied the orders_status table you need to create new statuses in order to make the orders displaying again, cause that's a criteria to fetch the orders from the database tables. You can add them under admin->languages/currencies->order status. In addition you may edit the orders table and set the status manually there for the existing orders, so they will show up again.