When your order is stuck and you want to update your Magento order status in my SQL then for that you have to create a temporary table called temp with 2 columns, increment_id and status.
Fill this table with orders numbers that need to be updated and the new status
e.g. canceled.
Status values can be found at:-
SELECT *
FROM `sales_order_status_state`
These queries will then update the sales order and the order grid with the new status.
UPDATE `sales_flat_order`, temp
SET sales_flat_order.state = temp.status, sales_flat_order.state = temp.status
WHERE sales_flat_order.increment_id = temp.increment_id;
UPDATE `sales_flat_order_grid`, temp
SET sales_flat_order_grid.status = temp.status
WHERE sales_flat_order_grid.increment_id = temp.increment_id
Hope your query is solved now. Do share in your views and experiences in the comment section below.
