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

Have you ever wondered about other ways to get configurable products in Magento site? Have you known the method of importing Magento 2 configurable products? If you’re still unclear about this, why don’t you practice these 3 easy steps on Magento 2 configurable product import?

LEARN MORE about Magento 2 configurable product to be excel at creating this product type. 

Now, let us walk you through this article to find out the fastest way to import configurable products in Magento 2.

Step 1: You need 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.

At first, you need to login 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 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 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

MAGENTO 1 EXTENSION | MAGENTO 2 EXTENSION | WEBSITE DEVELOPMENT SERVICE

Besides, to import data into Magento 2 websites, there are some suggestions for you to take into consideration:

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

Name

( 2 ) Comments

  • Karen Abrahams

    We’ve just started using your software & I need to understand how do you view all products
    uploaded on one complete spead-sheet .

    • admin

      Hi Karen,

      Thank you for your comment!

      Could you please specify more requirements and send us via email: [email protected].com
      We are happy to support you.