A shop_order is a custom post type so they are stored in the wp_posts table, post_status field.
However, changing the post status directly in the table would bypass any checks and validations that are done when the status is updated on the relevant admin page, so that sounds like a real bad idea.
Regarding new statuses, have a look at:
https://wordpress.org/plugins/order-tracking/
I’ve not tried it myself.
If not, checkout woocommerce.com & codecanyon.net for premium plugins that might do what you want.
Hi there,
It sounds like you’re trying to create custom order statuses – if that’s indeed the case, have a look at the following extension to help with that: https://woocommerce.com/products/woocommerce-order-status-control/
Creating custom status is exactly what I needed. Should have simply asked that so many thanks for reading between the lines.
Any recommendations for something free.
I would need the service for 3 sites now and a further 3 in a few months.
I would consider these service subscriptions if they weren’t ongoing annual payments.
Need to keep payments to the bare minimum especially on startup.
Thanks again for your time.
Hi @bootifel,
It’s been a while since we heard from you, so I’m marking this thread resolved. Hopefully, you’ve been able to resolve this, but if you haven’t, please let open up a new topic and we’ll be happy to help out.
