Have you ever wondered about other ways to get configurable products in your Magento site? Have you known the method of importing configurable product?
Please follow us in this article to find out the fastest way to import configurable product in Magento 2.
Step 1: You need a CSV file
In this step, if you already have a sample CSV file, you can skip this step and move on to the step 2.
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 image below:
In Import Behavior: choose Add/Update to import configurable products.
All other configurations, set as available default.
Step 2: Fulfill CSV file
Input your configurable product and simple product
There are some NOTE you need to know when filling in the CSV file
- All children products need to be listed before configurable product.
- The value in the 'attribute_set_code' column must always match the name of the Attribute Set that contains the attributes which are set for the product
- 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).
- The value in the 'configurable_variations' column should follow as the pattern in the file as the set of SKU and Option.
- The value in the 'configurable_variation_labels' column get the correlation between the Attribute code and the Label name.
Step 3: Import CSV file
Go to System>Import.
File to import:
- Select 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 Import button. A successful notification will be shown:
Then you go to the frontend to check.
Magento 2 Configurable Product extensionsMAGENTO 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:
