Delete all WooCommerce products, terms, postmeta and relationships #wp #wpdb #intermediary

WooCommerce.sql

-- Delete all WooCommerce products
DELETE FROM wpcl_term_relationships WHERE object_id IN (SELECT ID FROM wpcl_posts WHERE post_type IN ('product','product_variation'));
DELETE FROM wpcl_postmeta WHERE post_id IN (SELECT ID FROM wpcl_posts WHERE post_type IN ('product','product_variation'));
DELETE FROM wpcl_posts WHERE post_type IN ('product','product_variation'); 
-- Delete all WooCommerce terms
DELETE a,c FROM wpcl_terms AS a 
LEFT JOIN wpcl_term_taxonomy AS c ON a.term_id = c.term_id
LEFT JOIN wpcl_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
WHERE c.taxonomy = 'product_tag';
-- Delete All WooCommerce relationships
DELETE a,c FROM wpcl_terms AS a
LEFT JOIN wpcl_term_taxonomy AS c ON a.term_id = c.term_id
LEFT JOIN wpcl_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
WHERE c.taxonomy = 'product_cat'