how to delete completed orders in woocommerce using a my sql query

Question

I want to delete completed all orders in woocommerce by using a single my sql query. Because, I'm having a problem with my WordPress Dashboard. I can't view the completed orders from the back-end. It's getting blank. I have 7,823 Completed Orders. I hope that's why I seen white page when I'm going to view the Completed Orders.

Is there have a way to, That I can delete all Completed Orders using MySQL query. So, that I can run it in PHPMYADMIN.

Have any suggestions.

Answer 1

My solution would be just deleting all the orders (If you're moving from a shop with demo data to your new site). You can do this using the following SQL-queries.

DELETE FROM wp_woocommerce_order_itemmeta;
DELETE FROM wp_woocommerce_order_items;
DELETE FROM wp_comments WHERE comment_type = 'order_note';
DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_order' );
DELETE FROM wp_posts WHERE post_type = 'shop_order';

Answer 2

To use the native Woocommerce functionality by the maximum, you can do it following way. Move all orders to trash with SQL:

UPDATE wp_posts SET post_status = 'trash' WHERE post_type = 'shop_order';

And then go to Woocommerce -> Orders -> Trash and click Empty Trash.