How to delete a specific category of products in woocommerce efficiently?

  • bigbig

    (@bigbig)


    9 years, 9 months ago

    Anyone know how to delete a specific category of products in woocommerce efficiently? It is way too slow to do that page by page on woocommerce admin page and it always return timeout if I choose to delete more than 50 products a time.

    I found a SQL query to delete all products in woocommerce but I just want to delete a specific category. Does anyone know how to do this?

    Below is the SQL query post by someone I found:

    DELETE FROM wp_postmeta
    WHERE post_id IN(SELECT ID FROM wp_posts WHERE post_type = ‘product’);

    DELETE FROM wp_posts WHERE post_type = ‘product’;

    Mandy thanks!

    https://wordpress.org/plugins/woocommerce/

  • The topic ‘How to delete a specific category of products in woocommerce efficiently?’ is closed to new replies.