0

I'm trying to remove all the attribute taxonomies, I used this to remove the products from those attributes, but the taxonomies still exist under Attributes. I have 1,243 I'd like to delete.

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);

How can I also delete the attributes from the database?

  • I know you can export a csv of product data and make alterations there and I think this updates the product database as well. – Nathaniel Flick Jan 17 at 3:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.