Delete WooCommerce Variations by Category, Attribute, Keyword, etc.

Managing a large WooCommerce catalog often requires clearing out old inventory. While deleting a simple product is straightforward, removing product variations is much more difficult. Variations are technically stored as child posts attached to a parent product. Natively, WooCommerce forces you to open each parent product, navigate to the Variations tab, and manually delete the individual variations one by one.

If you need to remove hundreds of discontinued variations, clean up a faulty CSV import, or clear out out-of-stock items across your entire store, doing this manually could take days.

In this tutorial, you will learn how to efficiently bulk delete WooCommerce product variations based on specific conditions like category, attribute, tag, or keyword, without deleting the parent products.

We will use the WP Sheet Editor – WooCommerce Products Spreadsheet plugin to locate and remove these variations in bulk.

Video Tutorial

1. Open the WooCommerce Products Spreadsheet

Once you have installed and activated WP Sheet Editor, you can access your catalog in a continuous spreadsheet view.

Navigate to WP Sheet Editor > Edit products in your WordPress dashboard.

Instead of the standard paginated WooCommerce list, you will see every product in your store displayed as a row, with all product data fields represented as editable columns.

2. Search for the Specific Variations You Want to Delete

Before deleting anything from your database, you must isolate the exact variations you want to target. This prevents you from accidentally removing active inventory.

Open the Search tool located on the top toolbar.

The Search tool allows you to filter your catalog using highly specific parameters. Below are the most common practical scenarios for filtering variations before deletion.

Option 1: Find variations by keyword

This method is useful if you need to delete variations containing specific text, such as a discontinued model year (e.g., “2021”) or a specific label.

• Contains keyword: Enter the specific word you are targeting.
• Search on variations?: Tick this checkbox to ensure the tool searches the child variations, not just the parent products.
• Click Run search.

The spreadsheet will refresh to show only the variable products and variations containing that exact keyword.

Option 2: Filter variations by category, attribute, or tag

If you are clearing out an entire department (like a specific clothing category) or removing all variations of a specific color or material, use the taxonomy filter.

• Enter the target category, attribute, or tag in the Enter Product Categories, Product tags, or Product attributes field.
• Enable the Search on variations? option.
• Click Run Search.

You will now only see the variations attached to that specific taxonomy.

Option 3: Search for variations by date range

This option is incredibly helpful if you recently ran a CSV import that generated thousands of broken or incorrect variations. You can isolate variations created on a specific date to delete them and start over.

• Enable the Search on variations? option.
• Tick the Enable advanced filters box.
• Enter the exact date range using the YYYY-MM-DD or MM/DD/YYYY format provided by your system settings.
• Click Run search.

The spreadsheet will display only the variations created during that specific timeframe.

Option 4: Find variations by exact price

If you need to delete a specific pricing tier across your catalog (for example, removing all $19.99 variations), configure the advanced filters as follows:

• Enable the Search on variations? and Enable advanced filters checkboxes.
• Field: Regular price (_regular_price)
• Operator: =
• Value: Enter the target price (e.g., 19.99)
• Click Run search.

You will now see all variations matching that exact price point.

Option 5: Identify variations missing a featured image

Incomplete variations can harm user experience. If you want to audit and delete variations that lack an assigned image, you can search for empty image fields.

• Enable the Search on variations? and Enable advanced filters checkboxes.
• Field: Featured image (_featured_image)
• Operator: =
• Value: Leave this field completely empty.
• Click Run search.

This isolated list shows all incomplete variations.

Note: If you decide you would rather fix these variations instead of deleting them, you can follow our guide on how to bulk upload images to variations.

3. Delete the Filtered WooCommerce Variations

Once you have successfully filtered your catalog using any of the methods above, you have two practical options for executing the deletion.

Option A: Delete variations manually in the spreadsheet

If you want to review the filtered list and perform a surgical cleanup, you can delete specific variations directly from the grid.

Scroll to the Status column. For any variation you want to remove, click the dropdown and select Delete completely (or ‘Trash’ if you want a recovery option). Once you have marked the specific rows, click the Save button on the toolbar to apply the deletions.

Option B: Bulk delete all filtered variations at once

If you are confident in your search filters and want to delete the entire batch of variations simultaneously, use the bulk deletion tool.

Hover over the Bulk Edit menu on the top toolbar and click on the Delete option.

Configure the delete tool carefully to ensure you only remove the variations and not the parent products:

• Select the rows that you want to update: Edit all the rows from my current search
• Critically important: Ensure you select Edit only variations. This protects your main parent products from being deleted.

Click Execute Now.

Keep Your WooCommerce Database Clean

By executing this process, you will successfully clear out all the targeted variations from your database while leaving the parent products perfectly intact.

Removing obsolete variation data keeps your store running fast and prevents your database from bloating over time. With WP Sheet Editor, you can manage complex product architecture confidently without writing custom SQL queries or wasting hours inside the native WooCommerce editor.