WooCommerce – How to Combine Simple Products into a Variable Product

In this tutorial, we’ll show you how to combine several simple products into a variable product. Basically, we’ll convert simple products into variations, and then we’ll merge them into a variable product.

Maybe you’ve decided to combine all small Nike shirts into a variable product called Nike Shirts, so the customers just select the variation they want, instead of opening several products.

For this, we’ll need to use the WooCommerce Products Spreadsheet plugin. It displays all your WooCommerce products on a spreadsheet and allows you to apply massive changes to them using the Bulk Edit tool.

Also, you can convert products into other post types and as you’ll see, you can convert simple products into variations and combine them into a variable product.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

Once installed and activated, follow these simple steps:

Step 1. Create global attributes for the products

You need to create product global attributes like colors, sizes, etc. Just go to Products > Attributes and create them.

For example, we’ve created three product Colors: Black, White, and Red.

Step 2. Open the products spreadsheet

You need to open the products spreadsheet by going to WP Sheet Editor > Edit Products.

You’ll see all your products and their complete information displayed on the spreadsheet.

Step 3. Create a new variable product

We’ll merge these three simple products into a variable product:

  • Black Shirt – Nike
  • White Shirt – Nike
  • Red Shirt – Nike

We need to create a new variable product. For that, select the number of rows you want to create and click on Add New on the toolbar. This will create a new row that we’ll configure as a variable product.

We’ll name this new product Nike Shirts.

Now select these values in the following columns:

  • Type: variable
  • Product Color: Black, White, Red
  • Click on Save to apply the changes

Step 4. Convert the simple products into variations

To convert the products into variations, you need to change the post type and select the parent product and their color.

  • Post Type: product_variation
  • Page Parent: Paste the title of the parent product; in this case, it’s Nike Shirts.
  • Product Color: Select the color for each variation
  • Click on Save to apply the changes.

Optional. Set the variation price, SKU, and stock

When you combine the products, the variations will continue using the old stock, price, SKU, and image from the product before the conversion.

However, you can add new stock, regular price, SKU, image, etc to the variations. You can edit all the information.

Finally, click on Save to apply the changes.


Once you save the changes, you can click on Display variations on the toolbar, and the spreadsheet will reload. The variations will be displayed next to the parent product.

This is how the customers will see the Nike Shirts product in the store.

It’s really simple to merge simple products into a variable product.

This process works for combining products in bulk. You can edit many rows at the same time or copy paste the changes into many cells to do it faster.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Read more

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.

Close Menu