WooCommerce – How to Bulk Delete all Product Variations Quickly

In this tutorial, we will show you how to bulk delete WooCommerce product variations without removing the parent products. We’ll cover three options depending on how you want to select which variations to delete.

When you need to remove variations from variable products (whether to rebuild them from scratch, replace outdated size or color options, or convert variable products to simple products) the default WooCommerce interface requires you to open each product individually, delete each variation one by one, save, and repeat. Across a catalog with hundreds of variable products, that process can take hours.

To handle this in bulk, we’ll use the WP Sheet Editor – WooCommerce Products plugin. It displays all your products and variations in a spreadsheet inside your WordPress dashboard and includes a Bulk Edit tool that lets you delete variations across your entire catalog or a filtered subset without opening each product.

Once you have the plugin installed and activated, open the products spreadsheet by going to WP Sheet Editor > Edit Products. You’ll see all your WooCommerce products displayed as rows with their complete field data in columns.

To work with variations, click Display variations on the toolbar. This loads the product variations alongside their parent products in the spreadsheet, with each variation appearing as its own row.

With variations visible in the spreadsheet, choose one of the three options below depending on which variations you want to delete.

Option 1: Bulk Delete All Product Variations at Once

Use this option when you want to remove every variation from your entire WooCommerce catalog in a single operation.

Open the Bulk Edit tool from the toolbar.

Configure the following settings in the Bulk Edit tool:

• Select the rows that you want to update: Edit all the rows from my current search (including non-visible rows)
• What field do you want to edit: Status
• Select type of edit: Set value
• Replace existing value with this value: Delete completely
• Select Edit only variations.
• Click Execute Now.

The Edit only variations option is important here. It ensures the bulk delete targets variation rows only and does not affect the parent variable products.

Option 2: Manually Select Products and Delete Their Variations

Use this option when you want to delete variations from specific products rather than your entire catalog. This gives you full control over which parent products are affected.

In the spreadsheet, use the checkbox column on the left to select the parent products whose variations you want to delete. Then open the Bulk Edit tool.

Configure the following settings in the Bulk Edit tool:

• Select the rows that you want to update: Edit the rows that I selected manually in the spreadsheet
• What field do you want to edit: Status
• Select type of edit: Set value
• Replace existing value with this value: Delete completely
• Select Edit only variations.
• Click Execute Now.

The plugin will delete only the variations belonging to the products you selected. Parent products are not affected.

Option 3: Filter Products First, Then Delete Their Variations

Use this option when you want to target variations from a specific subset of products; for example, products in a particular category, products containing a specific keyword, or products assigned to a certain attribute or tag.

Before opening the Bulk Edit tool, use the Search tool to filter the parent products you want to target. You can filter by keyword, category, attribute, tag, price, stock status, or any combination of these. Once the search results are loaded in the spreadsheet, open the Bulk Edit tool and configure it the same way as Option 1, selecting Edit all the rows from my current search and Edit only variations.

For a detailed walkthrough of this filtering approach, see our guide on how to delete variations by keyword, attribute, and category.

As you’ve seen, bulk deleting WooCommerce product variations with WP Sheet Editor – WooCommerce Products involves opening the products spreadsheet, enabling the variation display, and then using the Bulk Edit tool with the Edit only variations option selected. The three options above cover different selection methods: deleting all variations across your catalog, deleting variations from manually selected products, and deleting variations from a filtered subset of products. In all cases, the parent variable products remain intact.