When you create product variations, those variations can have different SKUs. However, that can be a problem if you decide to use the parent products SKU later.
That’s why in this article we’ll show you how to remove SKUs from product variations, so they automatically use the parent products SKU, by filtering products by categories, attributes, tags, and downloadable products.
1. Install WP Sheet Editor
The first thing you need to do is to install WP sheet editor. This plugin helps you apply changes to thousands of products at once with just some clicks, something you can’t do with the normal WP editor.
You can skip this step if you have the plugin installed and activated.
You can download the plugin here:Read more about it
Once you open the plugin you’ll see a spreadsheet with all your products and their complete information for you to make changes easily.
2- Find the products to remove SKUs
To remove SKUs from hundreds of variations, you need to follow these simple steps.
a) Open the “Bulk Edit” tool.
Just click the button in the above part of the spreadsheet.
b) Open the Search tool
Select the I want to search rows to update option in the Select the rows that you want to update dropdown.
c) Filter products by keyword, category, attribute or tag
One of the advantages WP Sheet Editor offers is that you can filter products in different ways by using just some fields.
- Contains keyword: Write any keyword to filter all the variations containing it.
- Status: Draft, Published, Scheduled, etc.
- Enter Tags: In this field you can enter categories, attributes, tags, shipping classes.
IMPORTANT: Whatever field you choose, you need to tick the Search on variations checkbox to filter only variations. If not, you’ll filter parent products.
3- Remove SKUs from the filtered variations
Once you’ve filtered your products, you need to set these values in order to remove SKUs from the variations.
- Select rows that you want to update: I want to select rows to update
- What field do you want to edit: SKU
- Select type of edit: Clear value
- Click on Execute now
That’s really simple!
Did you notice how simple it is? It’s a matter of deciding which products you want to look for and setting the values to remove their variation SKUs.
With WP Sheet Editor it’s really easy to apply these and a multitude of other changes with just some clicks.