How to import variable products into WooCommerce?

How to import variable products into WooCommerce?

As an eCommerce store owner, you may have various reasons to migrate variable products from your WooCommerce store. Having landed on this page means that you are looking for help to import variable products into WooCommerce.

Well, in that case, we are going to help you with that. So what you need is a plugin that does the same.

In this article, we will be showing you how to import variable products into WooCommerce.

Before we kick in, let’s make this clear.

To import variable products into WooCommerce you will need two things.

  1. An import file with all the variable products.
  2. WooCommerce import export products plugin by WebToffee.

After purchasing the plugin go to My Accounts > Downloads.

Download the plugin file, upload it to the WordPress plugin directory, and Activate the plugin.

That being said, let’s dive in.

Export WooCommerce variable products into a CSV/XML file

As said earlier, first you need an import file with all the variable products exported. It is recommended that you use the same plugin to export variable products from your WooCommerce store.

To export WooCommerce variable products

  • Go to WebToffee Import Export (Pro) > Export.
  • Select Product as the post type to export.
  • Choose Advanced export as the export method.
  • Select Variable product as the Product types.
Selecting variable products as the product type to export
  • Rename and reorder the columns as you want to be exported.
  • Enter a file name for the export file and select a file format (supports both CSV and XML).
  • Click Export and download the exported file.

Steps to import WooCommerce variable products

The following steps will guide you on how to import WooCommerce variable products.

Step 1: Select Product as the post type

Go to WebToffee Import Export (Pro) > Export.

Select Product as the post type to import.

Selecting Product as the post type

Proceed to the next step.

Step 2: Select an import method

Import method: Go for Advanced Import.

Import from: Select Local to import variable products from CSV stored in your local storage (there are also options to import from URL and FTP).

Upload the import file.

Select an import method

Proceed to the next step.

Step 3: Map import columns

Here you can map the columns in your CSV file against the corresponding WooCommerce product fields. If the CSV is exported by this plugin, you can skip this step as the columns will be mapped automatically.

Step 4: Advanced options/Batch import/Scheduling

Here are some advanced options that let you update existing products, set batch import count, or schedule an import. You also have the option to save these settings (as templates) for future imports, in case of requirements arise.

Since you are only importing variable products, you don’t have to bother with these options. Simply scroll to the end of the screen and click the import button. But if you don’t want to import now and schedule the import for another time, you can do it by simply clicking the schedule button.

Advanced Import options

You can schedule an import or directly import variable products into WooCommerce.

Step 5: Schedule an import

Select Schedule on the Schedule/Import button.

Choose a Schedule type.

  • WordPress Cron: It depends on WordPress for scheduling the import job at the specified time.
  • Server Cron: Use this option if you have a separate system to trigger the scheduled events.

Add an Interval and Start time.

Scheduling import with WordPress Cron

Click on Schedule Now.

Step 6: Directly import

Select Import on the Schedule/Import button.

Import Progress log

You can see an import progress log with the number of successful and failed imports (if any).

Previewing Imported Variable products in WooCommerce

Now let’s preview imported variable products in our WooCommerce store.

Go to Products > All Products.

Variable products imported in the WooCommerce product section

There you can see the newly imported variable products.

You can import any number of products this way in your store.

Final thoughts

If you sell variable products in your WooCommerce store, you may want to add new product variations to your store. Following are some other reasons why people consider importing variable products into WooCommerce.

  • Migrating variable products to another store.
  • Add variations to existing products.
  • Bulk update existing variable products.

The product import export plugin we discussed in this article has a free version available in the WordPress plugin library with basic functionalities. It lets you import products on WooCommerce from CSV or XML files.

We believe that this article has helped you in importing variable products into WooCommerce.

If you have any thoughts on your mind, let us know in the comments.