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'

To be honest, as i understand the docs

The docs on the database are few and far between, IIRC.

The solution here leaves orphans in other tables, so is not complete. The orhpans should be perhaps have been linked via a foreign key by the original programmers to prevent such issues, but we are where we are.

I am actually woking on a project, where i need a good bunch of cleanup sql-queries, to get rid of all product, attribute category etc and also orders and customers. but the article below seems outdated:
https://www.businessbloomer.com/woocommerce-database-explained-how-it-works-and-where-to-find-data/

simply by looking i found **wc_product_attributes_lookup ** also worth for cleaning :(

if i finish the cleanup, ill try to summarize it