delete_all_wooc.sql

-- Borrar todos los productos y datos relacionados
DELETE FROM wp_postmeta WHERE post_id IN (SELECT id FROM wp_posts WHERE post_type IN ('product', 'product_variation'));
DELETE FROM wp_term_relationships WHERE object_id IN (SELECT id FROM wp_posts WHERE post_type IN ('product', 'product_variation'));
DELETE FROM wp_posts WHERE post_type IN ('product', 'product_variation');

-- Borrar todas las categorías de productos (y cualquier término en la taxonomía 'product_cat')
DELETE FROM wp_term_taxonomy WHERE taxonomy IN ('product_cat', 'product_tag', 'product_type', 'product_shipping_class');
DELETE FROM wp_terms WHERE term_id NOT IN (SELECT term_id FROM wp_term_taxonomy);

-- Borrar todos los atributos de productos
DELETE FROM wp_woocommerce_attribute_taxonomies;
DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%';
DELETE FROM wp_terms WHERE term_id NOT IN (SELECT term_id FROM wp_term_taxonomy);
DELETE FROM wp_termmeta WHERE term_id NOT IN (SELECT term_id FROM wp_terms);

-- Borrar meta adicional relacionada
DELETE FROM wp_postmeta WHERE meta_key LIKE 'attribute_%';