WordPress.org

Ready to get started?Download WordPress

Forums

Woocommerce CSV importer
Option that delete all products and categories (9 posts)

  1. nalehir
    Member
    Posted 1 year ago #

    Hi...can you make an option that delete all products and categories before importing a csv? thx

    http://wordpress.org/extend/plugins/woocommerce-csvimport/

  2. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    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!

  3. nalehir
    Member
    Posted 1 year ago #

    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

  4. allaerd
    Member
    Plugin Author

    Posted 1 year ago #

    hehehehe....sounds familiar!

    I can share you my clean up sql's :D

    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

  5. JudgeFredd
    Member
    Posted 1 year ago #

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

  6. Ciprian Popescu
    Member
    Posted 1 year ago #

    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.

  7. bradyso
    Member
    Posted 1 year ago #

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

  8. Ciprian Popescu
    Member
    Posted 1 year ago #

    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.

  9. molinnov
    Member
    Posted 11 months ago #

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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.