How to Delete All WooCommerce Orders

# delete orders and orders data
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';
# delete order notes which are comments
DELETE FROM wp_comments WHERE comment_type = 'order_note';
# delete order items
DELETE FROM wp_woocommerce_order_itemmeta;
DELETE FROM wp_woocommerce_order_items;

# delete order data
DELETE FROM wp_wc_orders;
DELETE FROM wp_wc_order_addresses;
DELETE FROM wp_wc_order_operational_data;
DELETE FROM wp_wc_orders_meta;
# don't forget about order placeholders
DELETE FROM wp_posts WHERE post_type = 'shop_order_placehold';
# delete order notes
DELETE FROM wp_comments WHERE comment_type = 'order_note';
# delete order items
DELETE FROM wp_woocommerce_order_itemmeta;
DELETE FROM wp_woocommerce_order_items;
# delete WooCommerce analytics data
DELETE FROM wp_wc_order_stats;

<?php
/*
 * Plugin name: WooCommerce Delete All Orders
 * Description: Allows to delete all WooCommerce orders in one click
 * Author: Misha Rudrastyh
 * Author URI: https://rudrastyh.com
 * Plugin URI: https://rudrastyh.com/woocommerce/delete-all-orders.html#wordpress-plugin
 * Version: 1.0
 */

// we need this namespace to check whether HPOS is in use
use Automattic\WooCommerce\Utilities\OrderUtil;

// for legacy orders
add_action( 'manage_posts_extra_tablenav', function( $which ) {

	$screen = get_current_screen();

	if( 'shop_order' !== $screen->post_type || 'top' !== $which ) {
		return;
	}

	rudr_display_delete_all_orders_btn();

}, 25 );

// for HPOS orders
add_action( 'woocommerce_order_list_table_extra_tablenav', function( $post_type, $which ) {

	if( 'shop_order' !== $post_type || 'top' !== $which ) {
		return;
	}

	rudr_display_delete_all_orders_btn();

}, 25, 2 );

// display HTML for the "Delete All Orders" link
function rudr_display_delete_all_orders_btn(){

	printf(
		'<a href="%s" class="button" style="height:32px">%s</a>',
		add_query_arg(
			array(
				'action' => 'delete_all_orders_now',
				'_wpnonce' => wp_create_nonce( 'mishatest' ),
			),
			admin_url( 'admin-post.php' )
		),
		esc_html__( 'Delete All Orders', 'woocommerce' )
	);

}

// process order deletion with the hook admin_post_{$action}
add_action( 'admin_post_delete_all_orders_now', function() {

	global $wpdb;

	check_admin_referer( 'mishatest' );

	if( OrderUtil::custom_orders_table_usage_is_enabled() ) {

		$count = $wpdb->get_var(
			"
			SELECT COUNT(*)
			FROM {$wpdb->prefix}wc_orders
			"
		);

		$queries = array(
			"DELETE FROM {$wpdb->prefix}wc_orders",
			"DELETE FROM {$wpdb->prefix}wc_order_addresses",
			"DELETE FROM {$wpdb->prefix}wc_order_operational_data",
			"DELETE FROM {$wpdb->prefix}wc_orders_meta",
			"DELETE FROM {$wpdb->posts} WHERE post_type = 'shop_order_placehold'",
			"DELETE FROM {$wpdb->comments} WHERE comment_type = 'order_note'",
			"DELETE FROM {$wpdb->prefix}woocommerce_order_itemmeta",
			"DELETE FROM {$wpdb->prefix}woocommerce_order_items",
			"DELETE FROM {$wpdb->prefix}wc_order_stats",
		);

		foreach( $queries as $query ) {
			$wpdb->query( $query );
		}

		wp_safe_redirect(
			add_query_arg(
				array(
					'page' => 'wc-orders',
					'deleted' => $count,
				),
				'admin.php'
			)
		);

	} else {

		$count = $wpdb->get_var(
			"
			SELECT COUNT(*)
			FROM {$wpdb->posts}
			WHERE post_type = 'shop_order'
			"
		);

		$queries = array(
			"DELETE FROM {$wpdb->postmeta} WHERE post_id IN ( SELECT ID FROM {$wpdb->posts} WHERE post_type = 'shop_order' )",
			"DELETE FROM {$wpdb->posts} WHERE post_type = 'shop_order'",
			"DELETE FROM {$wpdb->comments} WHERE comment_type = 'order_note'",
			"DELETE FROM {$wpdb->prefix}woocommerce_order_itemmeta",
			"DELETE FROM {$wpdb->prefix}woocommerce_order_items",
			"DELETE FROM {$wpdb->prefix}wc_order_stats",
		);

		foreach( $queries as $query ) {
			$wpdb->query( $query );
		}

		wp_safe_redirect(
			add_query_arg(
				array(
					'post_type' => 'shop_order',
					'deleted' => $count,
				),
				'edit.php'
			)
		);

	}

	exit;

} );