We all want to save a lot of time. Our time is literally worth a lot of money. That means that the hours we could normally spend editing thousands of products to activate the “It visible” option for all our WooCommerce product attributes will cause us losses and discomfort. It’s tedious and time-consuming.
Fortunately, we have the best solution to that dilemma that we may encounter at any time. We want to show you how to activate the “Is visible” option in all your WooCommerce product attributes.
For this we are going to use the WooCommerce Products Spreadsheet plugin. This is a powerful tool that shows you all WooCommerce products in one spreadsheet. You can use the “Search” tool to filter thousands of products in various ways. In addition, with the Bulk Edit tool you can apply changes massively to thousands of products.
You can download the plugin here: Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Once installed and activated, you need to go to Sheet Editor > Edit Products.
Now just follow these simple steps.
1- Open the “Bulk Edit” tool
The Bulk Edit tool, you can apply changes to thousands of products. You can edit any of your product fields’ values. Change titles, edit short description, replace content, etc. In this case, you’ll be able to mark the Is visible option on all your product attributes.
Open the tool by clicking on Bulk Edit on the plugin’s toolbar.
2- Mark the “Is visible” option for all your products
In order to enable the Is visible option for all your product attributes, you need to select these values in the Bulk Edit tool.
Option 1: Mark “Is visible” for all attributes
- Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
- What field do you want to edit: Product attributes
- Select type of edit: Change attribute settings
- What settings do you want to change: Is visible?
- New value: Yes
- What attribute do you want to edit: All
- Click on Execute now to apply the changes.
Option 2: Mark “Is visible” for specific attributes
- Select the rows that you want to update: Edit all the rows from my current search (even non-visible rows)
- What field do you want to edit: Product attributes
- Select type of edit: Change attribute settings
- What settings do you want to change: Is visible?
- New value: Yes
- What attribute do you want to edit: Here you need to select the attribute you want to edit: color, country, size, etc. For example, you can select pa_color, pa_size, etc.
- Click on Execute now to apply the changes.
A piece of cake!
As you can see, you don’t need to waste so many hours to activate the visibility option for your product attributes. You just need to take these simple steps.
You can download the plugin here: Download WooCommerce Products Spreadsheet Plugin - or - Check the features