Support » Plugin: Woocommerce CSV importer » Option that delete all products and categories

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author allaerd


    well….this is a bit tricky…i would rather have this as option in woocommerce it self…..

    For me to better understand you’re request…why would you need it. The plugin updates the fields for products as well as categories. If you want to delete them you can goto the product section and delete them manual.

    Also when you have woocommerce multilanguage….you must delete a whole lot more!

    if i have csv with 1000 or more products and want to delete some of them, its much easier sort them in excel and delete them. Further becuause somethimes my categories does not match. Must delete all products with smart manager and categories and then import again

    Plugin Author allaerd


    hehehehe….sounds familiar!

    I can share you my clean up sql’s 😀

    I think i will make another plugin called CleanUpWoo. Think it will be there in a few days

    Drop me a mail at to receive the sql’s

    Hi how did it go with the CleanUpWoo plugin? 🙂
    I am having a similar problem, with deleting multiple products.



    Hey @judgefredd, execute this query in your database:

    DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');
    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';

    It should delete all your products.

    sorry for my ignorance, but how to i execute a database query?



    You need to use phpMyAdmin either from your cPanel or by using it as a plugin – – from the SQL tab.



    @ciprian Popescu do you have a query that can delete all categories also? Thanks.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Option that delete all products and categories’ is closed to new replies.