View Order State - not status

[metalmattlee11]

Someone has previously made a mess of my order State//Status. Shame on me for giving them the access to do this.

I need to clean this up and in order to do that, I need to see both the order State and status. The Status is easily viewable on the Orders screen and the individual order. I don't see how I can view the State and status so I can start to see what I need to do to move orders to appropriate State and then status. Once I see this, I can figure out what temporary and permanent changes I need to make to delete the unneeded Statuses, since right now, there's a flood of orders in the wrong State and Status.

Thanks.

[Ankit Jasani]

Hi @metalmattlee11 ,

SELECT entity_id AS order_id, state, status, increment_id, created_at FROM sales_order ORDER BY created_at DESC LIMIT 100

Thanks,

Ankit

[metalmattlee11]

Thanks @Ankit Jasani. The next question is how can I change/fix these - I assume a direct change of state in this table will create a problem for the system? I see several other tables where the status is listed, and I don't want to corrupt my database by having a state changed when theres no appropriate status in the table for it, and/or it doesn't match the status in the other tables like sales_order_grid.