How to Bulk Delete Out-of-Stock WooCommerce Variations

Managing a growing e-commerce store means constantly dealing with fluctuating inventory. Sometimes you or your client needs to aggressively clean up a store’s database and bulk delete all out-of-stock WooCommerce variations. If you sell apparel, electronics, or customizable goods, you likely have variable products with dozens of sizes, colors, or styles. Identifying and removing the exact product attributes that are no longer available—and will never be restocked—can be an incredibly painful and tedious task.

For example, imagine you run a clothing boutique. A specific summer dress might come in 5 sizes and 4 colors, creating 20 unique variations for just one product. If the “Small/Red” and “Large/Blue” combos are permanently sold out, leaving these dead variations active clutters your backend and bloats your database.

Related tutorial: Bulk disable WooCommerce variations; this post shows you how to bulk edit the Variation enabled field, which may be a great option instead of bulk removing out of stock variations.

The default WooCommerce product editor doesn’t give you any native tool to filter your variations globally and apply changes to hundreds of them at once. To do this manually, you would have to open every single parent product, navigate to the Variations tab, hunt down the specific out-of-stock items, delete them one by one, and save. If you have hundreds of variable products, this manual inventory management is a massive drain on your time and resources.

That is why in this tutorial, we will show you how to streamline your workflow and bulk delete all out-of-stock variations using WP Sheet Editor.

Step 1: Install WP Sheet Editor to manage your WooCommerce inventory

WP Sheet Editor is a powerful inventory management plugin that makes it simple to apply bulk updates to hundreds of products at once using a spreadsheet interface. It is specifically designed to help store owners make thousands of database changes with just a few clicks, completely bypassing the slow WordPress post editor.

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

Once you open the plugin by going to WP Sheet Editor > Edit Products, you’ll find an intuitive spreadsheet showing all your simple and variable products, along with their complete metadata, pricing, and stock status.

Step 2: Find and filter all out-of-stock variations

Before we can remove out-of-stock products, we need to isolate the exact variations that have zero inventory. Doing this manually is impossible at scale, but WP Sheet Editor includes an advanced filtering system.

First, open the Search tool located on the plugin’s toolbar.

After the search panel opens, enter the following values to scan your database exclusively for depleted variations. This ensures you do not accidentally delete parent products or simple products that are currently out of stock.

• Tick the Search on variations checkbox. (This tells the plugin to look inside variable products to find variations).
• Tick the Enable advanced filters checkbox.
• Field: Stock status (_stock_status)
• Operator: =
• Value: Select Out of stock
• Finally, click on Run search.

After the plugin processes your request, your spreadsheet will reload. Now, only the specific variations that meet your search criteria (those with absolutely zero inventory) will be displayed in the spreadsheet grid. Everything else is safely hidden from view.

Step 3: Bulk Delete the Filtered Discontinued Variations

Now that you have isolated the empty inventory, we will use the Bulk Edit tool to remove these discontinued items for good. This bulk update tool allows you to modify, trash, or permanently delete hundreds of products simultaneously.

Locate the Bulk Edit button on the plugin’s toolbar and click to open it.

Now, apply these exact values to bulk delete the filtered variations safely:

• Select the rows that you want to update: Edit all the rows from my current search
• What field do you want to edit: Status
• Select type of edit: Set value
• Replace existing value with this value: Select Delete completely or Trash.
  • (Note: If you think you might restock these items in the future, moving them to the “Trash” is a safe option. However, if these are permanently discontinued products, selecting “Delete completely” will wipe them from your server, optimizing your WooCommerce database and improving your website’s loading speed.)
  • Another option: Bulk disable WooCommerce variations
• Select Edit only variations from the dropdown to ensure no parent products are affected.
• Click on Execute now

As you can see, finding and bulk deleting out-of-stock WooCommerce variations is incredibly easy with WP Sheet Editor. Instead of wasting hours clicking through endless WooCommerce menus, you can clean up your store’s database, remove dead weight from your catalog, and drastically improve your overall inventory management in just a few clicks.