Is it possible to achieve this easilly with updating the sales_flat_order status info? Or is this information defined in other db tables?


You can update values using

UPDATE `sales_flat_order` SET `status` = 'Your status code here' WHERE `entity_id` = 99;

But for consistency you have to change the value of status in the sales_flat_order_grid table also. That one is used to display the orders grid.

But be careful. You may have to change the state field also. The status may depend on the state field. Each status is allowed for one specific state.
You can check the relations between state and status from System->Order statuses.
Before changing anything I recommend a backup.

| improve this answer | |
  • I would forgot the sales_flat_order_grid without your advice. Thank you. – DarkCowboy Oct 16 '14 at 5:47
  • Also remember that this will not trigger any Magento logic that's usually called when the status changes, but this is probably what you want. – Fabian Schmengler Feb 23 '15 at 7:57
  • @marius: after changed order status from canceled to processing, can't able to do take invoice. how can I get the invoice? – zus Nov 27 '17 at 9:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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