WooCommerce – Remove SKU from Product Variations

posted in: Guides | 0

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:

- or - 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

The “Apply changes in bulk” tool doesn’t just help you modify all products but also specific ones. For example, you can modify all products within a category, products containing an attribute or tag, and all downloadable products.

In this section we show you how to find them in two ways, you chose the one you need.

a) Open the “Bulk Edit” tool.

Just click the button in the above part of the spreadsheet.

b) Hit the “Select rows” button.

This button helps you filter your products in different ways.

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. For example, you can filter your products by keyword, category, attribute or tag just by writing them in the correct fields.

If you want to look for all products containing a keyword, write that keyword in the “Contains keyword” field.

If you want to look for all products by category, attribute, or tag, write it in the “Enter Product category…” field.

After that, just hit the “Run search” button and your products will be filtered.

I’s important that you check the “Search on product variations” checkbox because otherwise you’ll edit all main products and not their variations.

d) Filter all downloadable products.

With WP Sheet editor you can also find all downloadable products to remove their variations SKUs. For that you need to hit the “Select Rows” button and then just follow this:

  • Check the “Search on variations” checkbox.
  • Check the “Enable advanced filters” checkbox
  • Write “_downloadable” in “Field key”
  • Choose the equality sign in “Operator”
  • Check de “Value” checkbox.

3- Remove SKUs from product variations.

Once you’ve filtered your products, you need to set these values in order to remove SKUs from the variations.

  • Check the “I understand it will update the posts from my search” checkbox.
  • Select “SKU” as the field you want to edit.
  • Select “Clear value” as the type of edit you’ll apply.
  • Hit the “Execute now” button.

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.

You can download the plugin here:

- or - Read more about it

Leave a Reply