Remove all WooCommerce product categories and tags

remove-all-product-categories-tags.php

<?php

require dirname(__FILE__).'/wp-blog-header.php';

$wpdb->query("DELETE a,c FROM wp_terms AS a 
              LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
              LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
              WHERE c.taxonomy = 'product_tag'");
$wpdb->query("DELETE a,c FROM wp_terms AS a
              LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
              LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
              WHERE c.taxonomy = 'product_cat'");

remove-all-product-categories-tags.sql

DELETE a,c FROM wp_terms AS a 
LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
WHERE c.taxonomy = 'product_tag';

DELETE a,c FROM wp_terms AS a
LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
WHERE c.taxonomy = 'product_cat'