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?


2 Answers 2


The following SQL queries should set an orders status

UPDATE sales_flat_order_grid SET status = 'complete';  
UPDATE sales_flat_order SET state = 'complete', status = 'complete';

Of course, if you wanted to update specific records, you'd add WHERE entity_id = '1245' or whatever to the end of the query.

UPDATE sales_flat_order SET state = 'completed', status = 'completed' WHERE increment_id IN (order#1,order#2,etc);

UPDATE sales_flat_order_grid SET status = 'completed' WHERE increment_id IN (order#1,order#2,etc);

And always backup the database before you run any queries like the above!

  • thank you, I was able to manually edit the order statuses with your first method.
    – Mithu Kuna
    Feb 25, 2016 at 21:49

If you're trying to modify the status on a Magento 2 instance the tables have changed. sales_flat_order_grid is now sales_order_grid and sales_flat_order is now sales_order

  • Not an answer ... question was tag with magento-1.9
    – sv3n
    May 18, 2017 at 21:10
  • please check the version it belongs to magento-1 but answer belongs to magento-2 May 19, 2017 at 6:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.