cancel
Showing results for 
Search instead for 
Did you mean: 

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

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:
error1.jpg

I hope you could help me! Thank you!