Deleting all Woocommerce products with a database query

The following queries will delete Woocommerce Products in WordPress.

Replace the wp_ database prefix accordingly.

Query to delete products from the WordPress database:

DELETE FROM wp_posts WHERE post_type = 'product';

Query to delete product post meta data from the WordPress database:

DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT id FROM wp_posts);

Query to delete product relationship data from the WordPress database:

DELETE FROM wp_term_relationships WHERE object_id NOT IN (SELECT id FROM wp_posts);