How to Remove SKU from WooCommerce Variations in Bulk

Effective inventory management is vital for eCommerce success, and the way you handle Stock Keeping Units (SKUs) can greatly impact your operations. By default, WooCommerce allows store owners to assign unique SKUs to both parent variable products and their individual variations. However, if your strategy shifts to tracking stock strictly at the parent product level, you’ll need to remove existing SKUs from your variations. Fortunately, the WP Sheet Editor plugin simplifies this process: it enables you to quickly isolate variations and apply a ‘clear value’ type of edit to the SKU field in bulk, ensuring your product listings remain organized and aligned with your inventory strategy.

If you have a large product catalog, removing SKUs from variations manually requires a repetitive workflow:

1. Navigate to Products > All Products in the WordPress dashboard.
2. Open a variable product.
3. Expand the Variations tab.
4. Edit each variation to delete the SKU field.
5. Save changes and repeat the process for the next product.

Because WooCommerce does not provide a native bulk action to target variation-level data specifically, this manual process is tedious and time-consuming. In this guide, you will learn how to bulk remove SKUs from your WooCommerce product variations using a spreadsheet interface.

Video Tutorial

Best Practice: Before running bulk modifications on your database, especially when altering post_meta values like SKUs, it is highly recommended to create a full backup of your WooCommerce store.

1. Open the WooCommerce Products Spreadsheet

To manage this process, we will use the WP Sheet Editor – Products Spreadsheet plugin. This tool loads your entire WooCommerce catalog into a single spreadsheet interface, allowing you to bypass standard WordPress loading screens and apply complex bulk edits directly to database fields.

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

Once activated, navigate to WP Sheet Editor > Edit products in the WordPress admin area. You will see a spreadsheet displaying all your products, variations, and their corresponding data columns.

2. Filter the Product Variations

Before applying a bulk edit, you must isolate the specific variations you want to modify. If you run a bulk edit without filtering, you risk removing SKUs from your simple products and parent variable products as well.

Open the Bulk Edit Tool

Click the Bulk Edit icon on the top toolbar of the plugin.

Launch the Search Tool

In the Bulk Edit modal, under the Select the rows that you want to update dropdown, choose I want to search rows to update. This opens the advanced search parameters.

Isolate Variations Using Filters

To ensure your bulk action only affects variation data, you must configure the search tool properly:

• Search on variations: Tick this checkbox. This is the most critical step, as it instructs the plugin to query variation-level data rather than parent products.
• Contains keyword: Enter a specific term if you only want to clear SKUs from variations matching a certain naming convention.
• Status: Filter variations by their current publishing status (e.g., Published, Draft, Scheduled).
• Enter Tags: Use this field to narrow down the query by native taxonomies, such as product categories, attributes (e.g., size or color), or shipping classes.

Once your parameters are set, click Run search to apply the filters.

3. Remove SKUs from the Selected Variations

With the variations correctly filtered, you can now clear the SKU field in bulk. The bulk editor will execute a database query to empty the _sku meta value for all matching variations.

Configure the Bulk Edit fields exactly as mapped below:

• Select rows that you want to update: I want to search rows to update (already selected from the previous step)
• What field do you want to edit: SKU
• Select type of edit: Clear value
• Confirm that the Edit Only Variations toggle is active
• Click Execute now.

Post-Execution and Troubleshooting Notes

• Server Processing: If you are updating thousands of variations, WP Sheet Editor processes the database modifications in background batches to prevent server timeouts. Keep the browser tab open until the progress bar completes.
• WooCommerce Transients: If the front-end of your store does not immediately display the parent product’s SKU after clearing the variation SKUs, navigate to WooCommerce > Status > Tools in your WordPress dashboard and click Clear transients. This forces WooCommerce to rebuild the product cache and reflect your database changes correctly.