2.3.5p1 Change Sales Order Status in database

[Sheba]

Using Magento 2.3.5p-1.

I changed the status of an order in sales_order AND sales_order_grid. 

Ran indexer command. 

Cleared cache and status of order did not change in admin or customer dashboard. 

What step am I missing?

[Vimal Kumar]

Hi @Sheba 

BTW direct database table changes are not recommenced.

It you are doing nay changes for testing.. then have you changed order "state" as well with order status in sales_order table.

You can match state with status in "sales_order_status" table.

I hope it will help you!

[Sunil Patel]

Hello @Sheba 

it is not right way to change order status.

If still want then you are good you need to do into two table

sales_order and sales_order_grid

make sure you are change state or status 

hope it will help you

[Sheba]

Thanks for your response.   I made change in those tables and it did not change status in admin or customer dashboard.