Delete All WooCommerce Attributes
-
Importing all my eBay listings using WP-Lister resulted in the creation of thousands of attributes with many duplicates of each one. What is the best way to delete all these attributes? I’ve tried the following code which didn’t result in deletion:
DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE ‘pa_%’); DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE ‘pa_%’; DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy); DELETE FROM wp_woocommerce_attribute_taxonomies; DELETE FROM wp_termmeta WHERE meta_key like ‘order_pa_%’; DELETE FROM wp_options WHERE option_name LIKE (‘_transient_wc_%’);
Can anyone suggest another method? I just want to erase all of them.
Thanks,
Jim
The topic ‘Delete All WooCommerce Attributes’ is closed to new replies.