Web Analytics

Fill the form & Get Installation Support


    How To Update Magento Order Status In Mysql When Order Is Stuck?

    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.

      Recent Articles

      Author Info

      Author Image

      Eshika Is a bibliophile and conversationalist. Her life revolves around writing , photography, presentation and repeat. "go with the Flow" is her approach in life.

      Get a Free Quote


        (We Operate Globally)