Magento 2 import configurable products in CSV

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

Field separators can vary, you can find which one to use in your case in the Imported file:

separator-import-file-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

Pin It on Pinterest