Support » Plugin: Woo Product Remover » Variable product type term is being deleted from DB

  • Resolved Trey


    Hi there.

    When I delete the products using this plugin, the “variable” product type term is being deleted from the “terms” database table – I have to deactivate and reactivate WooCommerce to fix it.

    Before delete all

    Before Delete All

    After delete all

    After Delete All

    The “delete all product relationships first” is the query that’s causing this issue.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author mcfarhat


    Hey Trey,

    Thanks again for reaching out.
    As I responded earlier via email, our plugin does not touch upon the variable product entry in the wp_terms table, which drives us to believe this is not related to our plugin.
    To confirm this, we performed some testing today, as follows:
    – we created a simple product
    – we created a variable product
    – we used Woo Product Remover plugin to remove all products. Products were removed.
    – we went to create a new product, the option variable was available. We went ahead and created a new variable product successfully.
    Which from our perspective confirms that the plugin is not affecting woocommerce’s variable product functionality.
    We also checked the availability of the variable product option in the wp_terms table, and it was there.
    Variable Product Showing in WP_Terms
    Feel free to let us know should you need further assistance, or if you have a more specific scenario where you believe this to be occurring.

    • This reply was modified 5 years, 5 months ago by mcfarhat.


    First of all, thank you for this almost perfect plugin.

    exactly the same problem here.

    After use the plugin, DB damaged.

    Yes, it deletes the term variable (after edit db and add this term all variable products passed from simple to variables).

    I use All Import to import products. Until use this plugin, no problems found.
    After the 1st use, this are the symptoms after the csv import:

    a) variable products assigned as simple
    b) all imported products don’t have any language assigned (using WPML)
    c) all attributes deleted (also translations)

    Just my input


    • This reply was modified 5 years, 4 months ago by goosept.
    Plugin Author mcfarhat


    Hey there,

    Thank you for the feedback.
    Even though we weren’t able to reproduce this issue through our testing, yet we have released a new version with a new functionality that allows you to avoid getting categories, tags, and taxonomies related to existing products from being deleted.
    This will be the standard behavior of the plugin unless the option to delete all is checked.
    We believe this will resolve your issue.

    Let us know if you still face issues with the new functionality

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Variable product type term is being deleted from DB’ is closed to new replies.