Woocommerce bulk change order status

Viewed 3599

I'm currently having some issues with a WooCommerce site. There are thousands of old orders that are stuck on the status "processing". These orders have received payment and products have been shipped.

I would like to mark these orders as complete without sending completed order E-mails. I'd like to use the following SQL Query to achieve this.

update wp_posts set post_status = 'wc-completed' where post_type = 'shop_order' and post_status ='wc-processing' ;

Do I need to change other tables too or would this work?

Thanks

Edit: The above code worked perfectly for me.

1 Answers
Related