Magento Tutorials

How to Import Configurable Products in Magento 2

This guide will walk you through how to import configurable products in Magento 2 using CSV file.

Step 1: Prepare your CSV file

Go to your Magento Admin > System > Data Transfer > Import.

From the Entity Type drop-down selections, choose Products and make sure your File Format is CSV.

magento import configurable products

In Import Behavior, click and choose Add/Update.

import behaviour

After which, click on the Download sample file and you’ll receive a .CSV file containing the products whose SKUs you just put down.

Step 2: Complete the CSV file

Open your downloaded CSV file.

magento sample file

You’ll see that other fields in the CSV import file of configurable products are the same as the file of simple products. Yet, with configurable products, you’ll need to add some fields and follow the instructions:

additional columns
  1. List children products before configurable ones
  2. Make sure the value in the ‘attribute_set_code’ column matches the name of the Attribute Set.
  3. Add the ‘additional_attributes’ column and enumerate all the attribute set values for each child product. Put the attributes in the format as attribute_label=atrribute_value, separated by a comma.
  4. Add the ‘configurable_variations’ column and fill in the set of SKU and Option (only for the parent products). Put the products in the format as SKU = child_sku, attribute_label=attribute_value, separate by ‘|”. The value attribute must correspond to the product value.
  5. Add and check the correlation between the Attribute Code and the Label name in the ‘configurable_variation_labels’ column (only for the parent products). Here you’ll declare an attribute in the format as attribute_code=attribute_label, separated by a comma.

Step 3: Import CSV file

Go back to your Magento backend, go to System > Data Transfer > Import.

magento data import menu

Then go to File to Import > Select File to Import. Select the file you want to import into your Magento store system.

file to import

And click on Check Data on the right corner.

check data

You can leave other fields as they already are by default.

After the data checking process completes, you can proceed to import if the checking result is valid, else you need to edit your CSV file until it is free of error.

magento validation result

Click Import to start the import process. When everything’s done you will receive the below success message.

magento import success

Now you can go to your frontend to check the result.

Ideally, make your product stand out from the crowd by enhancing customer experience. Magento 2 Simple Details on Configurable Product extension will simplify your configurable products’ appearance. Thus, customers can easily find the child product based on colors, sizes, and other attributes.

Magento-2-configurable-product

>>> Enrich customer experience with Magento 2 Simple Details on Configurable Product

Dom

A knowledge craver who always strive to be wiser everyday.

Subscribe
Notify of
guest

8 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments
omnistore
omnistore
1 year ago

Is there a way to import products without first preparing the file? To be able to any files. by simply specifying column numbers, as is done here in opencart

geometry dash subzero

You can leave other fields as they already are by default.

arkadium word wipe
1 year ago

You can leave other fields as they already are by default.

Des Clement
Des Clement
6 months ago

Don’t forget to look for coupons when ordering from writemyessay4me coupon. Savings can make a real difference in a student’s budget!

Jonh
5 months ago

Should I buy from Dolphin Web Solution??

Osh University
2 months ago

Elevate your expertise with Osh University’s  postgraduate degree  programs. As a leader in education, Osh offers a transformative learning experience, empowering individuals to excel in their chosen fields.

Shalamar Hospital
2 months ago

Shalamar Hospital, with the  best skin specialist in Lahore , is committed to delivering top-quality dermatological care, prioritizing your skin’s health and well-being.

Jewel Galore
2 months ago

Jewelgalore offers a range of  stylish ring for men . Explore our collection of elegantly crafted pieces, each designed to add a touch of sophistication and charm to men’s fashion.