WooCommerce – Remove SKU from Product Variations in Bulk

In this tutorial, you’ll learn how to remove SKUs from WooCommerce variations in bulk.

The SKU (Stock Keeping Unit) is a code, usually, an 8-digit alphanumeric code, used to identify products and keep track of inventory levels.

Many store administrators set an SKU for parent products, and others set SKUs for both parent products and variations in WooCommerce.

However, you may have set up variation SKUs when you created the variations, and now you need to remove the SKU from all the variations, so that they use the parent product’s SKU instead.

If you do it manually, removing the SKUs from the WooCommerce variations would require a BORING PROCESS like this:

1. Go to the Products page in wp-admin.
2. Open a variable product from which you want to remove the variation SKUs.
3. Edit each variation.
4. Save the changes.
5. Repeat.

This is time-consuming because you have to EDIT THE PRODUCTS AND VARIATIONS ONE AT A TIME.

That’s why we want to show you how to bulk remove SKUs from your WooCommerce product variations by using an easy spreadsheet bulk editor inside WordPress.

Just follow these simple steps:

1. Install WP Sheet Editor – WooCommerce Products

This plugin creates an intuitive spreadsheet to manage WooCommerce products and variations. It allows advanced search, bulk edit, export, and import.

You can skip this step if you have the plugin installed and activated.

Once you open the plugin, go to Sheet Editor > Edit products in wp-admin, and you’ll see a spreadsheet with all your products and their complete information.

2. Find the variable products to remove SKUs from variations in bulk

To delete SKUs from hundreds of variations, you need to follow these simple steps.

a) Open the “Bulk Edit” tool.

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

Tick the Search on variations’ checkbox to filter only variations. If not, you’ll filter parent products.

You can also combine that search filter with others to find product variations by keyword, status, tags, categories, attributes, etc.

• 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, etc.

Once you set up the search filters, click on Run search.

3. Remove SKUs from the filtered variations

Once you’ve filtered your products, you need to set these values in order to delete 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
• Edit Only Variations
• Click on Execute now

Did you notice how simple it is to bulk remove variations from your WooCommerce variations?

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.