I created an invoice for an order, then created a shipment from my magento admin and I encountered a rare problem, for some reason when I pressed "Submit Shipment" the website went to a 404 page, server side issues, being looked at separately. Now the order has an invoice and shipment, literally the order is complete but the status still remains as processing. when I check the invoices tab, the invoice is there, when I check shipment tab the shipment is there. has anyone else ever encountered this?
I believe when the system crashed it recorded the shipment however didn't change the status to "Complete" So is there a way to manually change the status to "Complete"? Perhaps from the database?
thanks
Best Answer
The following SQL queries should set an orders status
Of course, if you wanted to update specific records, you'd add WHERE entity_id = '1245' or whatever to the end of the query.
OR
And always backup the database before you run any queries like the above!