Created
April 6, 2024 19:14
-
-
Save maagmirror/56420511e6f856c6825074fb995fe09b to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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_%'; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment