Delete attribute completely in bulk

  • Resolved Sam

    (@xumbrella)


    2 years, 10 months ago

    Hello, I have a product attribute that has 1000’s of terms. Obviously, this was not what attributes were designed for so I want to clean things up.

    We are going to migrate the terms to a custom meta field for each product. Once I have done that, what is the safest way to delete an attribute? Obviously, it will take me forever to edit each product and remove each one.

    Can I go to Products >> Attributes and just click delete on the attribute I want to delete?

    Will that clear everything? Or will it cause problems with my products? I have over 4000 products so will be a nightmare to unpick if I get it wrong!

    Any help appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Amir A. (woo-hc)

    (@amiralifarooq)

    2 years, 10 months ago

    Hi @xumbrella

    Yes, deleting an attribute through the “Products > Attributes” section in the WordPress dashboard will remove the attribute and all its associated terms. No data from the products will be removed, except for the attribute and its terms. Since you already plan to migrate the terms to custom meta fields, deleting the attribute should not cause any issues.

    Here’s the step-by-step process:

    1. First, make sure you have successfully migrated all the terms to custom meta fields and have verified that the migration process was completed accurately.

    2. Next, go to your WordPress dashboard and navigate to “Products > Attributes”.

    3. Find the attribute you want to delete, and click on the “Delete” link under the attribute name. A confirmation popup will appear.

    4. Click “OK” on the confirmation popup to delete the attribute. All associated terms will also be deleted. This action is irreversible, so ensure that you have backed up your data before taking this step.

    Since you have a large number of products, it’s a good idea to perform this process on a staging environment first to ensure there are no unexpected issues. After you’ve verified that everything works as expected, you can proceed with the changes on your live site.

    Remember to perform a complete backup of your website before making any significant changes, so you have a safe point to revert to if something goes wrong. Using a backup plugin like UpdraftPlus ocan help you create and manage backups easily.

    Thread Starter Sam

    (@xumbrella)

    2 years, 10 months ago

    Hello, thanks for the advice. I did test it on my staging site and it timed out (i had over 7000 terms!!!). For my live site I will manually delete the terms first in batches and then delete the attribute itself.

    Given the huge numbers of terms for this taxonomy, is it likely that this could have been causing performance issues on the front end of my site?

    thanks

    xue28 (woo-hc)

    (@xue28)

    2 years, 10 months ago

    HI @xumbrella

    I did test it on my staging site and it timed out (i had over 7000 terms!!!). For my live site I will manually delete the terms first in batches and then delete the attribute itself.

    Performing the process on a staging site would be the best idea since you will be able to check if there will be issues along the way. I’d recommend cloning your site to a staging environment without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

    I also would like to add that you can check the premium plugin Bulk Edit Products, Prices, and Attributes that easily bulk edits any WooCommerce product fields and meta values.

    Given the huge numbers of terms for this taxonomy, is it likely that this could have been causing performance issues on the front end of my site?

    I cannot say this for sure as there are several factors to consider regarding the performance issues of your site.

    To check this further, can you please share with us further information about the performance issues you are experiencing on your site?

    If a screenshot would be helpful, I’d recommend using https://snipboard.io. You can share the direct link to the image as a response to this topic.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Delete attribute completely in bulk’ is closed to new replies.