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