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.