Magento 2 Import Configurable Products

To simply create and import configurable products without time loss follow the three clear steps.

Magento 2 import configurable products in CSV:

Step 1: Find a CSV file

¡In case you have already downloaded the sample file, skip the step! 

  • Log in to your Admin Panel and navigate to System>Import:

admin-system-import-magento

  • Make the next changes in the Import Settings tab: 
  1. Entity Type - Products;
  2. Import Behavior - Add/Update:

settings-import-magento

  • Click the Download Sample File option and save the CSV file on your computer.

Step 2: Fulfill the CSV file

  • Once downloaded, open the file:

csv-file-magento-2

  • Check you know these rules before filling in the CSV file:
  1. list children products before configurable ones;
  2. prove the value in the ‘attribute_set_code’ column matches the name of the Attribute Set;
  3. enumerate all the attribute set values for each child product in the ‘additional_attributes’ column;
  4. fill in the set of SKU and Option in the ‘configuable_variations’ column;
  5. check the correlation between the Attribute Code and the Label name in the ‘configurable_variation_labels’ column.

Step 3: Import CSV file

  • Get back to the Admin Panel>System>Import>Import Settings. In the Select File to Import field click the Choose File option, select your CSV file and click the Check Data button:

import-csv-file-magento

  • You will get a validation result in case everything is correct:

import-validation-results-magento

  • Click the Import button and get one more validation notification:

validation-import-magento

  • Go to the frontend to make sure everything works the way you needed.
Rate the answer?