How To Display Sub Categories On A Category Page In Magento?

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.