Magento – force magento order status complete

order-status

I have looked at this answer: Force an order to go to the status complete, but it doesn't apply to me. Due to a crash in our system we've lost an order that was further administratively taken care of.
Now I have created the order manually. Invoice and such has already been sent, so I don't want to do this. Instead I tried updating the order status in sales_flat_order, but this doesn't reflect in the admin panel. How can I solve this?

Best Answer

Alter this query to include the order ID or IDs and the status to what you would like to set:

https://gist.github.com/reidblomquist/aa9df1581a7ee8c82910

WARNING: Be sure to create a complete backup of your DB before directly querying!

Related Topic