cancel
Showing results for 
Search instead for 
Did you mean: 

How to import configurable products from CSV file to Magento 2?

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

How to import configurable products from CSV file to Magento 2?

Hi guys,

I am having problem importing configurable products from CSV files,. E.g. I have 2 simple products and a configurable product that links the 2 simple products, I have 2 custom configurable attributes: "Make" and "Model". 

Please take a look at the file below:

sku,supplier_number,genuine,brand,name,url_key,short_description,description,specifications,categories,make,model,year_from,year_to,weight,length,width,height,price,product_type,product_websites,attribute_set_code,configurable_variations,configurable_variation_labels,visibility
10100033-Mercedes-Sprinter,BSG90900010,,BSG,"Mercedes Sprinter, VW Crafter, Mirror, RH Door, Complete asembly, long wire, 10/2006>",,"Mercedes Sprinter, VW Crafter, Mirror, RH Door, Complete asembly, long wire, 10/2006>",,,Category/Replacement Parts/Body Parts,Mercedes,Sprinter,2006,2016,2.2,35,43,25,200.00,simple,base,Default,,,Not Visible Individually
10100033-VW-Crafter,BSG90900010,,BSG,"Mercedes Sprinter, VW Crafter, Mirror, RH Door, Complete asembly, long wire, 10/2006>",,"Mercedes Sprinter, VW Crafter, Mirror, RH Door, Complete asembly, long wire, 10/2006>",,,Category/Replacement Parts/Body Parts,VW,Crafter,2006,2016,2.2,35,43,25,200.00,simple,base,Default,,,Not Visible Individually
10100033,,,,"Mercedes Sprinter, VW Crafter, Mirror, RH Door, Complete asembly, long wire, 10/2006>",mercedes-sprinter-vw-crafter-mirror-rh-door-complete-asembly-long-wire-10-2006-10100033,"Mercedes Sprinter, VW Crafter, Mirror, RH Door, Complete asembly, long wire, 10/2006>",,,Category/Replacement Parts/Body Parts,,,,,,,,,,configurable,base,Default,"sku=10100033-Mercedes-Sprinter,make=Mercedes,model=Sprinter|sku=10100033-VW-Crafter,make=VW,model=Crafter","make=Make,model=Model","Catalog, Search"

But when I import, it is all wrong:
undefined

I hope you could help me! Thank you!