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.
In Import Settings, choose Products, then you click Download Sample CSV as the image below:
In 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:
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.
Then if your CSV file has no errors, there will be a notified message like the image below:
Next, you just click the Import button. A successful notification will be shown:
Finally, go to the frontend to check how it works.
Besides, to import data into Magento 2 websites, there are some suggestions for you to take into consideration:
- Magento 2 Import Export Product Reviews Extension
- Magento 2 Import Export Product Attributes Extension
- Magento 2 Import Export URL Rewrites Extension
- Magento 2 Import Export Wishlist Item Extension
- Magento 2 Import Export Categories Extension
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.