I ran into a case today where an order got miss-marked in Magneto as being shipped. The Magento Admin (CE 1.6) doesn’t have an option to change this status back to processed. So sadly, to get this corrected, you need to go into your database and manually modify two columns.
If you aren’t familiar with manual DB edit and/or the potential risk that could come from doing this, consider this your fair warning to tread lightly in here. You can create more issues quickly than you fix if you make a mistake.
With that weak disclaimer out there, let’s move forward. Since all hosting environments are a bit different, it’s up to you to know how to get into your Database, but I generally use PHP MyAdmin.
Once in, go to the following two tables:
- sales_flat_order
- sales_flat_order_grid
In both of these tables, find the record that matches your order. In my case, I was able to do a search by the increment_id using the order number.
Edit the row for that order, changing the status field to the appropriate value:
- processing (new order)
- canceled (canceled order)
- processed (payment processed, order not shipped)
- complete (order shipped)
In my case, to remove the shipped status, I simply had to change complete to processed in both tables and all was set.
I hope this helps!
