• Resolved jcolman60

    (@jcolman60)


    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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi,

    I understand that you would like to remove all attributes.

    There is another method that you can try out, please check this thread.

    You can use a plugin like the https://ww.wp.xz.cn/plugins/wp-phpmyadmin-extension/ to perform the database query.

    Before moving forward, please be sure to back up your site.

    Hi,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

    Kind regards.

    Thread Starter jcolman60

    (@jcolman60)

    Thanks for the follow-up. Is it possible to delete the woocommerce-attributes-taxonomies file in phpmyadmin to get rid of all the duplicated terms?

    Hi,

    Is it possible to delete the woocommerce-attributes-taxonomies file in phpmyadmin to get rid of all the duplicated terms?

    I did not realize that this question is already replied in this forum thread:

    To avoid sending replies in both forums, I highly recommend continuing the troubleshooting in the forum above.

    We appreciate your understanding.

    Cheers.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Delete All WooCommerce Attributes’ is closed to new replies.