WordPress.org

Support

Support » Plugins and Hacks » Woocommerce CSV importer » Option that delete all products and categories

Option that delete all products and categories

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

    @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

    @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 info@allaerd.org to receive the sql’s

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

    Ciprian

    @butterflymedia

    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?

    Ciprian

    @butterflymedia

    You need to use phpMyAdmin either from your cPanel or by using it as a plugin – http://wordpress.org/extend/plugins/portable-phpmyadmin/ – 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.
Skip to toolbar