Blog

How to bulk delete WooCommerce product attributes? (With SQL and plugin)

bulk delete product attributes in WooCommerce
Table of Contents

Managing an online store can be a challenging task, especially when you have hundreds or even thousands of products with different attributes. Bulk deleting WooCommerce product attributes is an efficient solution to simplify your store management processes, which is possible with two methods: SQL code and WooCommerce variations bulk edit plugin.

In this article, we will discuss how to remove the WooCommerce attribute of multiple products with these two methods. In addition, we introduce the WooCommerce variations bulk edit plugin and describe how it can improve your e-commerce product management.

Method 1: bulk delete WooCommerce product attributes by SQL

Running SQL queries for removing attributes WooCommerce is useful if you have enough knowledge about WordPress database management. 

To bulk delete all WooCommerce product attributes, you can insert the below SQL code in MySQL and run it.

DELETE FROM wp_terms
WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%');

DELETE FROM wp_term_taxonomy 
WHERE taxonomy LIKE 'pa_%';

DELETE FROM wp_term_relationships 
WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);

The easiest way to run a SQL query is to use phpMyAdmin. However, we recommend you let an expert do this task for you and don’t forget to back up your database before running any query.

If you are an expert in writing SQL codes, you still need a more flexible solution for managing your product attributes. This is a very time-consuming task, especially when you want to filter some products regularly, and then bulk remove their attributes in your store.

To solve this problem, you can install the WooCommerce variations bulk edit plugin on your WordPress website and enjoy managing your attributes with its user-friendly filter form and easy-to-use bulk edit tool.

Continue reading to learn more about the amazing features of this plugin for bulk deleting WooCommerce product attributes.

Method 2: Bulk removing product attributes by WooCommerce variations bulk edit plugin

The WooCommerce variations bulk edit plugin is a powerful tool that allows you to edit multiple product attributes at once. This plugin eliminates the need to manually edit or remove each product feature individually, resulting in saving you valuable time and effort.

With a straightforward interface, this plugin allows you to effortlessly select multiple products and change or remove various features with just a few clicks.

Its powerful features and user-friendly interface allow online store managers to quickly bulk delete product attributes with the following three simple steps:

Step 1: Install the plugin

To use this simple and practical plugin, you must download and install WooCommerce variations bulk edit plugin on your WordPress site.

Then, by going to the following address in the WordPress dashboard, you can view the main page of this plugin and follow the next steps for bulk delete WooCommerce product attributes.

iT Bulk Editing > Woo Variations

select woo variations menu in bulk editing WooCommerce

Step 2: Filter products

WooCommerce bulk variations editing plugin offers advanced filtering options that allow you to filter your product based on any field in WooCommerce. You can filter products by categories, features, tags, and more, making it easier to target specific groups of products for bulk removing attributes.

To use the comprehensive filter form of the WooCommerce bulk variations editing plugin, first, click on the Filter icon at the top of the page as illustrated below:

select filter icon in WooCommerce variation bulk edit plugin to filter desired products

In this form, you can see that all WooCommerce fields are divided into seven categories to help you find what you need more conveniently.

select general tab in filter form on WooCommerce variations bulk edit plugin

After specifying product filters, you can click on Get Products to see a list of filtered products in the table.

Step 3: Mark products and bulk delete product attributes 

To use the bulk edit form, first mark some products in the table, then press the Bulk Edit icon on the toolbar as shown below:

mark products and click bulk edit icon for bulk edit product attributes

In the bulk edit form, you can find all product attributes in the Categories/Tags/ Taxonomies tab.

Every attribute you have assigned to your WooCommerce products is listed under the Attribute section. To bulk delete any attribute, follow the below instructions:

  • Find any attribute you want to bulk delete its items like color, size, etc.
  • Open the dropdown list in front of it and choose the Delete option among the operators. 
  • Click on the attribute items box to see the list of items related to that attribute.
  • Choose one or more items from the list.
  • Click on Do bulk delete. 
select delete option for product size attribute for bulk delete WooCommerce product attributes

There is no need to mention that the nice and easy process of filtering and bulk removing WooCommerce product attributes by this plugin has no complications.

However, to show you the powerful features of this plugin, let’s make some examples.

Example 1: Bulk delete WooCommerce attributes of downloadable products 

In this example, let’s suppose that you want to bulk delete all sizes you have assigned as attributes to the downloadable products in your store. To do this, try the following instructions:

  • Go to Filter Form and find the Downloadable field in the Type tab.
  • Choose Yes in the dropdown list of the Downloadable field.
select yes option for downloadable field in type tab filter form
  • After marking the products in the table, open the Bulk Edit form and go to the Categories/Tags/Taxonomies tab.
  • Find Product Size under the Attribute section.
  • Choose Delete for the first box, then select all sizes in the next box. 
  • Click on the Do bulk edit button to remove WooCommerce attributes.
select attribute you want to bulk delete from WooCommerce products

Example 2: Bulk delete WooCommerce attributes of variable products with a keyword

Suppose that you added some shirts as variable products to your online store, and you want to bulk delete their colors by this plugin.

In the WooCommerce variations bulk edit plugin, the bulk editing attributes for variable products are as easy as simple products. You just need to follow the below instructions:

  • Go to Filter Form and find the Product Title field in the General tab.
  • Open the dropdown list and choose Like from the list.
  • Type Shirt in the textbox next to it.
select like option for product title field in general tab of filter form
  • Click on Get Products to see the list of Shirts in the table.
  • Mark all of them by selecting the checkbox next to the ID at the top of the table.
  • Click on the Manage Variations option, as illustrated below.
select manage variations option in toolbar of WooCommerce variations bulk edit plugin
  • In the Variations Bulk Edit form, go to Delete Variations. 
  • From the combo box of Delete type, choose Delete the products variations according to the combination of the attributes. 
  • Open the dropdown list of Select attributes and choose Color.
  • Set All for the Select Term field.
  • Click on Submit button. 
select delete type field in delete variations tab of WooCommerce variations bulk edit plugin

Now, you have successfully bulk removed all items of color attribute assigned to the shirts in your WooCommerce store.

Why bulk delete attributes of WooCommerce products is important?

One of the most common problems that online stores face is the regular change of products and their attributes, which causes store managers to have to remove or replace them constantly.

Of course, editing simple and variable products individually can be very complicated and time-consuming, and it can take days to apply the necessary changes to all your products.

On the other hand, by default, WordPress does not allow you to bulk edit or bulk delete the attributes of your products very easily. Therefore, your ultimate solution is to use the WooCommerce variations bulk edit plugin.

With the help of this plugin, you no longer need to open the product pages one by one, but you can remove all the features of the products at once with one click. 

Bulk delete product attributes are important for store managers because they can save their time and let them manage their store much faster and more efficiently.

Conclusion

Bulk delete WooCommerce product attributes allows you to delete the attributes of all your selected products at once. You have two ways to do this task. The first way is to remove all the attributes with SQL, and the second way is to remove them with the help of the WooCommerce plugin. In this article, we explained both methods to you completely.

If your store has a large number of products, editing, updating, and removing the attributes of the products individually is very difficult. In this case, you can use the WooCommerce variations bulk edit plugin. This plugin helps you to easily make bulk changes to all the features of your products with just a few clicks.

To learn more about this plugin, click on this link.

Leave a Reply

Your email address will not be published. Required fields are marked *

Shopping cart
Sign in

No account yet?

We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies.

Start typing to see products you are looking for.