How to Import Configurable Products in Magento 2

Vanessa
Vanessa Updated: July 12, 2023

Share:

The Most Popular Extension Builder for Magento 2

With a big catalog of 234+ extensions for your online store

As far as we know, Magento 2 Configurable Products is a useful tool for both customers as well as store owners. If the products are configurable, it means that the customers can purchase them according to their needs, hobbies or the requirements from a list of available options easily. Thanks to it, there is a high chance that they make quicker purchase decisions, and stores can boost sales in no time.

Importing a single product in Magento 2 can be easy; however, the configurable products import process may seem more complicated to some businesses. Adding one by one is not a practical answer, so you still need a solution to help importing these data in bulk.

In this article, we will show you how to import configurable products in Magento 2. It is implemented according to three following steps.

3 Steps to Import Configurable Product in Magento 2, follow 3 steps:

Step 1: You need a CSV file to Import Configurable Product

You need your Magento 2 admin panel before downloading a sample CSV. Log into the backend and navigate to System > Import

need a CSV file to Import Configurable Product

In here, the Import Settings tab will be displayed

How to Import Configurable Product in Magento 2

In Import settings field, choose Products > click Download Sample CSV as image below:

How to Import Configurable Product in Magento 2

In the Import Behavior tab, choose Add/Update to import configurable products as the image above. All other configurations, set up as available default. In case you already have a CSV file, you can skip this step.

Step 2: Fulfill CSV file (Input your configurable product and simple product)

The sample configurable products after downloading:

3 Steps to Import Configurable Products in Magento 2

Some notes you need to know before filling in the CSV file

  • Need to list all children products before configurable product.
  • Make sure that the value in the ‘attribute_set_code’ column always matches the name of the Attribute Set.
  • You should list all the values of the attribute set for each child product from in the ‘additional_attributes’ column.
  • Follow the pattern in the file as the set of SKUs and Options in the ‘configurable_variations’ column.
  • Get the correlation between the Attribute code and the Label name in the ‘configurable_variation_labels’ column.

Step 3: Import CSV file

Now, navigate to System > Import. In the File to Import field, click on Choose File to upload your CSV file. Then, click on the Check Data button on the right corner.

3 Steps to Import Configurable Products in Magento 2

There will be a notified message if your CSV file has no errors like the image below:

3 Steps to Import Configurable Products in Magento 2

Next, click Import button, a successful notification will be shown as below:

How to Import Configurable Product in Magento 2

Finally, go to the frontend to check again.

Conclusion This is the fastest way to import configurable products in Magento 2. Be an intelligent store owner by meeting the satisfaction of the customers with only three simple steps. Do not hesitate anymore, follow those steps now!

Feel free to comment below or share it with your friends and business partners.

Import and Export Categories in Magento 2

Some related posts:

Looking for
Customization & Development Services?

8+ years of experiences in e-commerce & Magento has prepared us for any challenges, so that we can lead you to your success.

Get free consultant
development service


Vanessa
Vanessa
Vanessa is a content executive at Mageplaza. Cooking and reading books are her passion. Her particular hobby is travelling, helping her discover all around. She is an energetic marketer with the hope of making her words magical.

Explore Our Products:

People also searched for

Subscribe

Stay in the know

Get special offers on the latest news from Mageplaza.

Earn $10 in reward now!

Earn $10 in reward now!

comment
iphone
go up