WooCommerce – Bulk Edit Products Missing Attributes and Variations

In this tutorial, we will show you how to bulk edit WooCommerce products missing variations.

First, we’ll show you how to find products without attributes and variations, and then we will show you how to bulk update those products.

Sometimes when you’re creating a WooCommerce store, you lose track of the complete products and the products missing information.

For whatever reason, you might want to find products missing attributes and variations to add the missing information.

When that happens, it can be really difficult to find those products, especially if you have hundreds of products in your WooCommerce store.

So in this entry, we’ll show you how to find, erase or edit all your products without variations and attributes.

Install WP Sheet Editor

WP Sheet Editor was designed to help you manage your WooCommerce store by applying changes to thousands of products at once, so it will make your life easier.

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

When you open the spreadsheet at WP Sheet Editor > Edit products, you’ll see all your products and their information.

1. Search for products missing variations

Before removing products or making any changes, you need to find the ones you’ll modify.

In this case, we want to find the products missing attributes and variations.

We need to start by opening the Search tool.

Key point: WooCommerce variable products require attributes to have variations. Attributes like size, color, and material are necessary for defining the variations of a variable product.

To identify products without variations, we need to search for variable products by their type and ensure these products have no attributes (i.e., product attributes are empty).

On the Search tool, you just have to select these values:

• Enter product type: Variable
• Tick the Enable advanced filters checkbox.
• Field: Product Attributes
• Operator: =
• Value: Leave this field empty.
• Click on Run search.

Once you complete the search for products lacking attributes, the spreadsheet will show all these products.

As noted earlier, products without attributes are the same as products without variations.

To verify that the filtered products have no variations, use the “Display variations” tool.

You’ll observe that only the products are listed, with no variations displayed.

If you searched for products containing attributes, and then clicked the “Display variations” button, you would see that the variations are displayed next to their parent products.

2- Bulk edit WooCommerce products missing variations

After filtering the products that have no variations, you can proceed to edit them in bulk.

Here are some options that you have to bulk update variable products missing variations:

a) Bulk delete variable products missing variations

Open the Bulk Edit tool.

Select these values in the Bulk Edit tool in order to bulk remove the products without variations:

• 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: Delete completely
• Select the Edit only parent products option.
• Click on Execute Now.

b) Create WooCommerce variations in bulk

With WP Sheet Editor, you can create variations for hundreds of products.

Here is a tutorial on how to do it.

c) Copy variations from one product to 100 products

If you want to copy product attributes and variations from one product to hundreds of products, saving a lot of time, you can follow this tutorial.

d) More tutorials on bulk managing WooCommerce variations

Here are other ways in which you can bulk edit WooCommerce variations using WP Sheet Editor:

• Bulk edit variation prices
• Delete WooCommerce variations in bulk
• Remove SKU from product variations in bulk
• Delete duplicate variations in bulk
• Set the same image to all variations
• Bulk delete out of stock variations

With WP Sheet Editor, it’s really easy to find and edit products without attributes or variations.