Home > Docs > Product Import Export Plugin for WooCommerce > Bulk Upload Variable Products In WooCommerce

Bulk Upload Variable Products In WooCommerce

Last updated on September 26, 2023

If you have different variations of a product in your WooCommerce store, instead of creating multiple single products, WooCommerce allows you to create a variable product with all the variations. You can create attributes with different values for the product. However, it is not very easy to upload products and their variations manually to the store.

The Product Import Export Plugin for WooCommerce by WebToffee allows you to upload variable products in bulk to your WooCommerce store in the easiest possible way. Begin by installing and activating the plugin. To upload the variable products into your WooCommerce store:

  1. Select the post type as Product.
  2. Select an import method.
  3. Map the import columns.
  4. Use advanced options and click on Import.

Bulk Upload Variable Products

The plugin takes a UTF-8 encoded CSV, XML, TSV, XLS, and XLSX files as input. It then imports the products to the WooCommerce store without any difficulty with all the variable products and product details. So, in order to upload all the variable products using the plugin, you must have a CSV, XML, TSV, XLS, or XLSX file with all your variable products and the product data.

Sample screenshot of variable products in CSV
Sample screenshot of variable products in CSV

In the given CSV, the variable product is a T-shirt, with two attributes size and color. Each variation of the product has different SKUs but is connected to the original product using the parent_SKU. Once you have the CSV file prepared, import the variable products to the store.

From the WordPress admin panel where you need to upload the variable products, go to WebToffee Import Export (Pro) > Import menu.

Steps to import variable products

  1. Select Products under post type.
Selecting post type as Product
Selecting post type as Product
  1. Select an import method: Quick import, Pre-saved template and Advanced import are the provided import methods. Pre-saved template import option will be available only if you have saved the template file during previous advanced imports.
Uploading input file
Uploading input file
  1. Map import columns: To map import columns. Here, you can map the commercial names to WooCommerce columns.
Map import columns
Map import columns
  1. Advanced Options/Batch Import: Provides advanced options for scheduling and import.
Advanced options during import
Advanced options during import

On successful import, the variable products will appear as:

Variable products imported successfully
Variable products imported successfully

For a step-wise procedure of import operation, refer to How to import WooCommerce products.

Variable products in WooCommerce store

We can view the imported products in the WordPress admin panel and in the WooCommerce store.

  • To view the imported products in the WordPress dashboard, click on Products > All Products.
Product
Product
  • To view its variations, click on the product and move to the Variations section.
Variations
Variations
  • The color variations in the product page will appear as shown below.
Colour variations
Colour variations
  • The size variations in the product page will appear as shown below.
Size Variations
Size Variations