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:
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:
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:
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.
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:
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:
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:
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:
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:
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:
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:
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:
- WooCommerce Bulk Edit Variable Products and Prices – A Step by Step Guide
- WooCommerce Bulk Edit Product Images – A Step by Step Guide
- WooCommerce Bulk Edit Product Categories – A Step by Step Guide
- WooCommerce Bulk Edit Product Short Description – A Step by Step Guide
- How to Bulk Edit Based on Stock Status on Your WooCommerce Site?
