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.
[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,...
Let our Magento expert connect to discuss your requirement.
We offer Magento
certified developers.
Our Magento clientele
is 500+.
We sign NDA for the
security of your projects.
We’ve performed 100+
Magento migration projects.
Free quotation
on your project.
Three months warranty on
code developed by us.