How to Create Variations in Bulk on Your WooCommerce Site | Blog banner

How to Create Variations in Bulk on Your WooCommerce Site?

A variable product is a product type in WooCommerce that allows you to offer different variations of a specific product with control over color, price, size, etc. For example, if you buy a shirt, you can find Small, Medium, and Large variations from which you can choose one according to your need.

As a WooCommerce store owner, you need to feed your product details frequently according to the stock and availability of them to sell. When it comes to variable products, you may need to create variations in bulk for hundreds or thousands of products together, or you may need to change their regular price and sale price in bulk. Since WooCommerce does not have any default option to bulk update these, you need to adopt a plugin for doing the task.

You can easily create all combinations of variations for an individual product in just one click using WooCommerce’s default option. But, you cannot manage this for multiple products using WooCommerce.

In this article, let us check how to create variations in bulk using a WooCommerce bulk edit plugin – ELEX WooCommerce Advanced Bulk Edit Products, Prices & Attributes.

Before getting into the part, let us check how to generate product variations in bulk for individual products using WooCommerce’s default option.

Create variations from all attributes for individual products

First, you need to go to the product page dashboard for which you need to create the variations. Go to the Product data meta box part on the dashboard. If it is a single product, choose it as a variable product. Check the screenshot below:

How to Create Variations in Bulk on Your WooCommerce Site? | product data metabox

After that, choose the Variations tab. There, you can choose the option Create variations from all attributes from the drop-down pick-up list. Then click Go. Check the screenshot below:

How to Create Variations in Bulk on Your WooCommerce Site? | create variations from all attributes

You will see a message that the variations have created. All available combinations of attribute values will be used to create the product variations. Check the screenshot below:

How to Create Variations in Bulk on Your WooCommerce Site? | generated all variations

In this example, 15 variations have been generated with 2 attributes – size and color.

You can click each variation and enter details separately such as their prices, stock details, etc. This is how you can create all combinations of product variations in just one click for individual products.

After saving the changes, the customers can choose their variation from the drop-down lists on the product page. Check the screenshot below:

Based on the prices you have provided, it will display the minimum and maximum amount as the product price as displayed in the screenshot above.

Now, let us check how to create variations in bulk for multiple products using the bulk edit plugin.

Create variations in bulk using ELEX WooCommerce Advanced Bulk Edit Products, Prices & Attributes Plugin

ELEX WooCommerce Advanced Bulk Edit Products, Prices & Attributes plugin is an advanced WooCommerce bulk edit plugin that allows you to bulk update product attributes based on a large number of filters. You can bulk update simple, variable, and external products with this plugin. Also, you can schedule the bulk edit for a future date and time. And, there is an option to add scheduled refresh by setting a frequency such as daily, weekly, or monthly. If you need to bulk edit a custom product attribute that is added by a third-party plugin or extension, you can apply that with this plugin.

ELEX WooCommerce Advanced Bulk Edit Products, Prices & Attributes

You can filter the products based on the following attributes:

  • Product Title
  • Product Tags
  • Product Types
  • Stock Status
  • Product Categories
  • Product Regular Price
  • Description
  • Short Description
  • Product Attributes
  • Custom Attributes

You can bulk edit the following product attributes with this plugin:

  • Product title
  • Product SKU
  • Product Visibility
  • Featured Product
  • Product Type
  • Shipping class
  • Product Visibility Status
  • Sale Price and Regular Price
  • Managing stocks
  • Stock quantity
  • Allowing backorders
  • Stock status
  • Product Length, Width, Height, and Weight
  • Global product attributes
  • Product variations
  • Featured Product
  • Description Action
  • Short Description Action
  • Product Image
  • Product Gallery Images Action
  • Tax Status & Tax Class
  • Interchange Attribute Values of Product Variations
  • Create Variations from All Attributes
  • Delete Action

To know more about this plugin and how to bulk edit each product attribute, refer to the article – How to set up ELEX Bulk Edit Products, Prices & Attributes for WooCommerce plugin?

Refer to the article mentioned above to know how to subscribe, install and activate the plugin on your WooCommerce store.

After the installation, go to the plugin settings and filter Variable products. You can apply additional filters according to your requirements. Check the screenshot below:

How to Create Variations in Bulk on Your WooCommerce Site? | filter the variable products

After adding the required filters click Preview Filtered Products. 

All variable products will be listed in the Preview tab from where you can remove some products if required. Check the screenshot below:

How to Create Variations in Bulk on Your WooCommerce Site? | Preview

If you are satisfied with the list, you can proceed to the next step. There you can apply the bulk edit on product attributes.

You can go to the Create variations section in the opened tab. Check the screenshot below:

How to Create Variations in Bulk on Your WooCommerce Site? | Enable create variations

You can enable the option to create variations from all attributes as in the screenshot above. If you enable the option, another option to add regular price and sale price for the variations will appear. You can add the regular price and sale price if required, and proceed with the next step. Check the screenshot below:

How to Create Variations in Bulk on Your WooCommerce Site? | bulk editing regular price and sale price of variable products

As you can see, I have added 40 as the regular price and 30 as the sale price. All the product variations which have been created will be available at these prices.

After entering other required updates, you can proceed to the next step. Check the screenshot below:

How to Create Variations in Bulk on Your WooCommerce Site? | execute bulk edit

This step is to execute the bulk edit immediately. You can enter the name of the update if required. Also, you can enable it to save as a job, make the Undo option available, and create a log file if required. Then you can click Finish.

You can also schedule the bulk update if required. For that, choose to Schedule it for later. And, enter the date and time at which the bulk update must be executed, revert the attribute values, and choose a frequency to refresh the schedule. You can also add a name for the update and choose to create a log file. Check the screenshot below:

How to Create Variations in Bulk on Your WooCommerce Site? | schedule update

After completing the bulk edit, you can check the variable products’ dashboard. All available variations will be generated with the regular price and sale price you have added. Check the screenshot below:

How to Create Variations in Bulk on Your WooCommerce Site? | Example of bulk edited variation

The product variations have been created for all products, and the regular price and sale price got updated for each variation as shown in the screenshot above.

This is how you can create variations in bulk using the plugin.

Wrap Up

ELEX Advanced Bulk Edit Products Prices Attributes for WooCommerce is a simple and robust plugin that will help you bulk edit any product attributes seamlessly. You can create product variations with all combinations of attributes in bulk in a couple of clicks with this plugin.

 

Further Reading:

    Leave a Reply

    WordPress Image Lightbox Plugin