How can I delete all existing product tags from my woocommerce?

  • Hello guys!.
    I made a mistake by creating many product tags in my Woocommerce and now I would take an infinitely large time erasing one by one manually. I need a SQL code to completely delete all the product tags from my woocommerce, and also all its associations with the products.

    I need something that makes those product tags seem never to have existed in my life, lol.

    Note: Categories need to continue. Normal post blog tags too.

    Sorry for my bad english.

    I am very grateful to anyone who can help me.

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

  • I dont think you need SQL request unless you have thousands of these tags. Go to Products > Tags, on top of screen choose ‘screen options’, increase the number of results to be shown on page, then select all with checkbox and delete.

    Thread Starter nicolefrancis22

    (@nicolefrancis22)

    superkot, thanks for reply.
    Yes, i need SQL request. I have 350.000 tags… I made a error.

    Please, help me. =)

    Sorry for my mad English

    Hello,

    try this SQL query to delete all product tags:

    DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy = 'product_tag');
DELETE FROM wp_term_taxonomy WHERE taxonomy = 'product_tag';
DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);

    Make sure to make a bckup before running this query.

    Thread Starter nicolefrancis22

    (@nicolefrancis22)

    Ospiotr, this is PERFECT !!!! WORKSSSS!!! WHOAAAAAA
    All tags is deleted for all woocommerce pages.

    THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    You save my time!

    KISSEEEEES!!!! KISSESS ! KISSESSS!!! AND SORRY FOR MY BAD ENGLISH!

    HAVE A NICEEE DAY, WEEEEK, MONTH , YEARRR, LIFEEEEEE !!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘How can I delete all existing product tags from my woocommerce?’ is closed to new replies.