Magento 2 Configurable Product Import in 3 Simple Steps

How to Import Configurable Product in Magento 2

Magento 2 Configurable Product Import in 3 Simple Steps

Are you looking for the best solution to import configurable products in Magento 2?

If you are moving or updating your site, you sure have to import your products data to your Magento store.

It’s not a problem to import single products to Magento 2, because you can find all the necessary tools under System -> Export. But moving configurable products may take a lot of time and effort.

However, you can simplify the importing Magento 2 configurable products.

In this article, we will show you the fastest and easiest way to import configurable products Magento 2.

READ MORE how to add new Magento 2 product attributes to optimize your work better!

What Are Configurable Products?

Configurable products are products with variable options for customers to choose in a dropdown menu. 

Not only do they allow customers to see all the options available of a product in one single product page, Magento 2 configurable products can benefit store owners too.

Creating configurable products in Magento 2 means giving each option a unique SKU. It will make it easier to track inventory for the product variation.

Therefore, the configurable product is the great choice for products with multiple options.

Import Configurable Products Magento 2 In 3 Simple Steps

Practice these 3 easy steps to import configurable products in Magento 2.

Step 1: Prepare a CSV file

Before we start, note that if you already have a sample CSV file, you can skip this step and move on to step 2 of Magento 2 configurable product import.

First, you need to login to the backend. Go to System > Import, choose Download Sample CSV.

import csv file

magento import settings

In Import Settings, choose Products, then you click Download Sample CSV as the image below:

import sample csvIn Import Behavior: choose Add/Update to import Magento 2 configurable products.

For all other configurations, you set it as available default.

Step 2: Fulfill the CSV file

Next, input Magento 2 configurable product and simple product:

input product in csv file

There are some NOTEs you need to know when filling in the CSV file of Magento 2 configurable product import:

  • First, all children products need to be listed before the Magento 2 configurable product;
  • Second, the value in the ‘attribute_set_code’ column must always match the Attribute Set’s name that contains the attributes assigned for the product;
  • Third, the value in the ‘additional_attributes’ column should list all the values of the attribute set for each child product (use,” if there is more than one attribute set for the product);
  • Also, the value in the ‘configurable_variations’ column should follow the pattern in the file as the set of SKU and Option;
  • Moreover, the value in the ‘configurable_variation_labels’ column gets the correlation between the Attribute code and the Label name.

Step 3: Import CSV file

Go to System>Import.

File to import:

Select a file to import: choose your CSV file.

– Click the Check Data button on the right corner.
check data when import csv

Then if your CSV file has no errors, there will be a notified message like the image below:check data successfull

Next, you just click the Import button. A successful notification will be shown:

import CSV file successfully

Finally, go to the frontend to check how it works.

Magento 2 Configurable Product extensions
Magento 2 Configurable Product extensions

Wrap Up

We ensure that if you follow these steps, you can easily import configurable products Magento 2 in no time.

Besides configurable product data, there is some other data that you should import into Magento 2 websites.

For example, given the fact that Customers’ Data are equally important factors, we recommend reading the article about how to quickly import/export customer data.

These are some suggestions for you to take into consideration:

Are you looking for a way to add a new Magento 2 category? Read this article to find out!

BSS Commerce is one of the leading Magento extension providers and web development services in the world. With experienced and certified Magento developers, we commit to bring high-quality products and services to optimize your business effectively. Furthermore, we offer FREE Installation – FREE 1-year Support and FREE Lifetime Update for every Magento extension.

CONTACT NOW to let us know your problems. We are willing to support you every time.

Write A Comment