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
Status values can be found at:-
These queries will then update the sales order and the order grid with the new status.
SET sales_flat_order.state = temp.status, sales_flat_order.state = temp.status
WHERE sales_flat_order.increment_id = temp.increment_id;
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.
[crayon-63d3e85382532678822356/] Using above fucntion Images can be imported directly from...
Override view block using di.xml and add the below code...
You can check a list of called layout XML for...
Follow the below steps to install and set up PWA...
If you want to remove all leading zero's from order,...