Let’s learn how to bulk edit Iconic Show Single Variations settings using an intuitive spreadsheet for WooCommerce products inside WordPress.
Normally, if you want to edit show single variations settings for a hundred products, you’d have to:
- Go to Products > All Products.
- Open a variable product to edit it.
- Edit the show single variations field for each product variation.
- Repeat the same process for all the products you need to edit.
No doubt, this would take hours and hours if you have hundreds of variable products to edit.
Fortunately, with WP Sheet Editor, you can easily bulk update all show single variations fields with just a few clicks.
Here are some of the things you can do with this plugin regarding product variations:
- Display all product variations next to the parent products with one click.
- Search for product variations only and display them on the spreadsheet.
- Edit any of your product variations fields in bulk.
- Bulk edit all fields added by other plugins such as Show Single Variations.
- Export or import Show Single Variations settings.
Using WP Sheet Editor, you can see all the variations in a table where you can edit easily.
You can download the plugin here: Download WooCommerce Products Spreadsheet Plugin - or - Check the features
Once you install and activate the WP Sheet Editor plugin, you need to download and install the Iconic Show Single Variations Extension for WP Sheet Editor – Show Single Variations full compatibility.
After installing and activating both the plugin and the free extension, you can proceed to follow the steps in the sections below to learn how to bulk edit Show Single Variations settings.
1- How do Show Single Variations fields appear in the spreadsheet?
The Show Single Variations fields will appear as checkboxes in the spreadsheet. Each Show Single Variations column will have SSV before the field name. See below.
- SSV: Show in Search Results
- SSV: Show in Filtered Results
- SSV: Show in Catalog
- SSV: Listings Only
- SSV: Disable Add to Cart
Tip
- You see we’ve sorted the columns so we only see the Show Single Variations and related fields.
- You can do the same using the Columns Manager that is on the top toolbar.
2- How to manually edit show single variations settings in the spreadsheet
To update the show single variations settings in the spreadsheet, you need to be able to see the product variations. And we have a great, easy way to do that: click Display Variations.
Once you click Display Variations, you’ll see all the variations next to their parent products.
Now you need to start editing the Show Single Variations settings by ticking the checkboxes you want to enable and unticking the ones you want to disable.
Once you’re done with that, click Save.
3- How to search for variations by keyword, category, attribute, tag
In this section, we want to show you how to search for your product variations by keyword, category, attribute, or tag. Then, we’ll show you how to bulk update the show single variations visibility for all the search results. This is a great way to edit massive numbers of product variations.
Open the Search tool.
Now you’ll see the following fields you can use:
- Contains keyword – Enter any keyword and the plugin will search for all products/variations that contain it in their titles.
- Enter Product type, Product visibility, Product Categories, Product tags, Product shipping classes, or Product attributes – You can enter any of these search terms to filter your products.
- Search on variations – Yes. This will filter variations, not just simple products.
- Run Search – Click.
Now all the product variations that meet the search filters will be displayed in the spreadsheet.
You can see the search filters you applied above the spreadsheet.
Tips
- You can combine search terms to make more specific searches.
- You can disable a search filter by clicking it once the search has been completed.
4- How to bulk edit show single variations settings
Once your variations have been displayed in the spreadsheet as search results, you can bulk update them all.
However, if you don’t want to edit all the search results, you can even pick the variations you want to edit using the Checkbox picker that is in the first column.
Open the Bulk Edit tool.
Once you open the bulk edit tool, you can use any of the sections below to bulk edit show single variations visibility on the cart, search results, product listings, etc.
a) How to bulk edit show single variations visibility on the shop catalog
These are the values you need to select in the Bulk Edit tool in order to bulk edit show single variations visibility in the shop catalog.
- Select the rows that you want to update: Edit all the rows from my current search
- What field do you want to edit: SSV: Show in Catalog
- Select type of edit: Set value
- Replace existing value with this value: yes/no
- Click Execute Now.
With these simple values, you’ll have enabled or disabled the show in the catalog option.
b) How to bulk enable or disable the “Show in Filtered Results” option
You need to select these values if you want to bulk enable/disable the “Show in Filtered Results” option:
- Select the rows that you want to update: Edit all the rows from my current search
- What field do you want to edit: SSV: Show in Filtered Results
- Select type of edit: Set value
- Replace existing value with this value: yes/no
- Click Execute Now.
c) How to bulk show all selected variations in search results
Select these values to show all the selected variations in search results:
- Select the rows that you want to update: Edit all the rows from my current search
- What field do you want to edit: SSV: Show in Search Results
- Select type of edit: Set value
- Replace existing value with this value: yes
- Click Execute Now.
d) How to bulk enable the “Show Listings Only” feature
You need to select the following values in order to enable the Show Listings Only feature for all the selected variations:
- Select the rows that you want to update: Edit all the rows from my current search
- What field do you want to edit: SSV: Listings Only
- Select type of edit: Set value
- Replace existing value with this value: yes
- Click Execute Now.
e) How to bulk disable add to cart for all selected variations
If you want to disable add to cart for all the selected product variations, you need to select the following values:
- Select the rows that you want to update: Edit all the rows from my current search
- What field do you want to edit: SSV: Disable Add to Cart
- Select type of edit: Set value
- Replace existing value with this value: yes
- Click Execute Now.
Bulk managing Show Single Variations settings is really simple with WP Sheet Editor!
As you see, you don’t have to worry anymore to bulk update Show Single Variations visibility and other settings for hundreds of even thousands of variations. You just need some simple clicks and the changes will be applied without problems.
You can edit hundreds of variations from the spreadsheet, or you can use the powerful Bulk Edit tool to edit massive numbers of variations.
You can also read:
You can download the plugin here: Download WooCommerce Products Spreadsheet Plugin - or - Check the features