To import configurable products, you should:
1. Import both simple and configurable product data using profile 'Data Type' - 'Products';
- make sure that simple products that represent variations have corresponding super attributes set in THIS import.
That means if super attribute is 'size' each simple product that will be used for variation of size has to have the attribute set in this profile.
2. Link attributes with configurable products using profile with 'Data Type' - 'Products Extra'
3. Link simple products to configurable products using profile with 'Data Type' - 'Products Extra'
Steps 2 and 3 can be done in a single import file and single profile. See http://unirgy.com/wiki/urapidflow/fixed_row_format#cpsacatalog_product_super_configurable_attribute
for sample file structure.
Bellow are couple of example files which could be used to perform configurable product cration.
##CPSA,sku,attribute_code,position,label
## configure super attributes
CPSA,PO170,size,2,Size
CPSA,PO170,color,1,Color
CPSA,PO171,size,2,Size
CPSA,PO171,color,1,Color
CPSA,PO172,color,1,Color
CPSA,PO173,color,1,Color
CPSA,PO174,color,1,Color
CPSA,PO176,color,1,Color
## set price for particular option - valid only for Magento 1
##CPSAP,sku,attribute_code,label,website,price,is_percent
CPSAP,PO176,color,White,base,15,0
## link parent and child skus
##CPSI,sku,linked_sku
CPSI,PO170,PO170LT
CPSI,PO170,PO170TC
CPSI,PO170,PO170NV
CPSI,PO171,PO171LG
CPSI,PO171,PO171SM
CPSI,PO172,PO172GO
CPSI,PO172,PO172IV
CPSI,PO172,PO172SV
CPSI,PO172,PO172BL
CPSI,PO173,PO173KY
CPSI,PO173,PO173BL
CPSI,PO174,PO174GR
CPSI,PO174,PO174BL
CPSI,PO174,PO174LL
CPSI,PO176,PO176GR
CPSI,PO176,PO176WH
sku,image,size,color,description,enable_googlecheckout,manufacturer,name,price,short_description,small_image,status,tax_class_id,thumbnail,url_key,visibility,weight,links_exist,price.final,price.maximum,price.minimal,product.attribute_set,product.entity_id,product.has_options,product.required_options,product.type,product.websites,category.name,stock.is_in_stock,stock.manage_stock,stock.qty,stock.use_config_manage_stock
PO170LT,/A/C/ACES-074-04b.jpg,1,Latte,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 1,174,dolor sit amet,/A/C/ACES-074-04b.jpg,Enabled,Taxable Goods,/A/C/ACES-074-04b.jpg,lorem-ipsum-dolor-1,Not Visible Individually,0,0,174,174,174,Default,590,No,No,simple,base,Sample>Child>Child 2;Sample 2>Child 3,In Stock,Yes,500,No
PO170TC,/A/C/ACES-074-05b.jpg,2,Terracotta,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 2,174,dolor sit amet,/A/C/ACES-074-05b.jpg,Enabled,Taxable Goods,/A/C/ACES-074-05b.jpg,lorem-ipsum-dolor0,Not Visible Individually,0,0,174,174,174,Default,591,No,No,simple,base,Sample,In Stock,Yes,500,No
PO170NV,/A/C/ACES-074-06b.jpg,10,Navy,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 3,174,dolor sit amet,/A/C/ACES-074-06b.jpg,Enabled,Taxable Goods,/A/C/ACES-074-06b.jpg,lorem-ipsum-dolor1,Not Visible Individually,0,0,174,174,174,Default,592,No,No,simple,base,Sample,In Stock,Yes,500,No
PO170,/A/C/ACES-074-04b.jpg,9,,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 4,174,dolor sit amet,/A/C/ACES-074-04b.jpg,Enabled,Taxable Goods,/A/C/ACES-074-04b.jpg,lorem-ipsum-dolor2,"Catalog, Search",,0,174,174,174,Default,593,Yes,Yes,configurable,base,Sample,In Stock,Yes,500,Yes
PO171LG,/A/C/ACBS-092-12b.jpg,45,,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 5,86,dolor sit amet,/A/C/ACBS-092-12b.jpg,Enabled,Taxable Goods,/A/C/ACBS-092-12b.jpg,lorem-ipsum-dolor3,Not Visible Individually,0,0,86,86,86,Default,594,No,No,simple,base,Sample,In Stock,Yes,500,No
PO171SM,/A/C/ACBS-092-14b.jpg,42,,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 6,53,dolor sit amet,/A/C/ACBS-092-14b.jpg,Enabled,Taxable Goods,/A/C/ACBS-092-14b.jpg,lorem-ipsum-dolor4,Not Visible Individually,0,0,53,53,53,Default,595,No,No,simple,base,Sample,In Stock,Yes,500,No
PO171,/A/C/ACBS-092-14b.jpg,56,,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 7,0,dolor sit amet,/A/C/ACBS-092-14b.jpg,Enabled,Taxable Goods,/A/C/ACBS-092-14b.jpg,lorem-ipsum-dolor5,"Catalog, Search",,0,0,0,0,Default,596,Yes,Yes,configurable,base,Sample,In Stock,Yes,500,Yes
PO172GO,/L/P/LPBS-127-02b.jpg,12,Gold,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 8,328,dolor sit amet,/L/P/LPBS-127-02b.jpg,Enabled,Taxable Goods,/L/P/LPBS-127-02b.jpg,lorem-ipsum-dolor6,Not Visible Individually,0,0,328,328,328,Default,597,No,No,simple,base,Sample,In Stock,Yes,500,No
PO172IV,/L/P/LPBS-127-01.jpg,13,Ivory,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 9,328,dolor sit amet,/L/P/LPBS-127-01.jpg,Enabled,Taxable Goods,/L/P/LPBS-127-01.jpg,lorem-ipsum-dolor7,Not Visible Individually,0,0,328,328,328,Default,598,No,No,simple,base,Sample,In Stock,Yes,500,No
PO172SV,/L/P/LPBS-127-06b.jpg,1,Silver,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 10,328,dolor sit amet,/L/P/LPBS-127-06b.jpg,Enabled,Taxable Goods,/L/P/LPBS-127-06b.jpg,lorem-ipsum-dolor8,Not Visible Individually,0,0,328,328,328,Default,599,No,No,simple,base,Sample,In Stock,Yes,500,No
PO172BL,/L/P/LPBS-127-08b.jpg,2,Black,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 11,328,dolor sit amet,/L/P/LPBS-127-08b.jpg,Enabled,Taxable Goods,/L/P/LPBS-127-08b.jpg,lorem-ipsum-dolor9,Not Visible Individually,0,0,328,328,328,Default,600,No,No,simple,base,Sample,In Stock,Yes,500,No
PO172,/L/P/LPBS-127-06b.jpg,10,,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 12,328,dolor sit amet,/L/P/LPBS-127-06b.jpg,Enabled,Taxable Goods,/L/P/LPBS-127-06b.jpg,lorem-ipsum-dolor10,"Catalog, Search",,0,328,328,328,Default,601,Yes,Yes,configurable,base,Sample,In Stock,Yes,500,Yes
PO173KY,/L/P/LPAS-015-02b.jpg,9,Sky,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 13,218,dolor sit amet,/L/P/LPAS-015-02b.jpg,Enabled,Taxable Goods,/L/P/LPAS-015-02b.jpg,lorem-ipsum-dolor11,Not Visible Individually,0,0,218,218,218,Default,602,No,No,simple,base,Sample,In Stock,Yes,500,No
PO173BL,/L/P/LPAS-015-01b.jpg,45,Black,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 14,218,dolor sit amet,/L/P/LPAS-015-01b.jpg,Enabled,Taxable Goods,/L/P/LPAS-015-01b.jpg,lorem-ipsum-dolor12,Not Visible Individually,0,0,218,218,218,Default,603,No,No,simple,base,Sample,In Stock,Yes,500,No
PO173,/L/P/LPAS-015-02b.jpg,42,,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 15,218,dolor sit amet,/L/P/LPAS-015-02b.jpg,Enabled,Taxable Goods,/L/P/LPAS-015-02b.jpg,lorem-ipsum-dolor13,"Catalog, Search",,0,218,218,218,Default,604,Yes,Yes,configurable,base,Sample,In Stock,Yes,500,Yes
PO174GR,/L/P/LPAS-106-01b.jpg,56,Green,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 16,328,dolor sit amet,/L/P/LPAS-106-01b.jpg,Enabled,Taxable Goods,/L/P/LPAS-106-01b.jpg,lorem-ipsum-dolor14,Not Visible Individually,0,0,328,328,328,Default,605,No,No,simple,base,Sample,In Stock,Yes,500,No
PO174BL,/L/P/LPAS-106-03b.jpg,12,Blue,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 17,363,dolor sit amet,/L/P/LPAS-106-03b.jpg,Enabled,Taxable Goods,/L/P/LPAS-106-03b.jpg,lorem-ipsum-dolor15,Not Visible Individually,0,0,363,363,363,Default,606,No,No,simple,base,Sample,In Stock,Yes,500,No
PO174LL,/L/P/LPAS-106-02b.jpg,13,Lilac,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 18,363,dolor sit amet,/L/P/LPAS-106-02b.jpg,Enabled,Taxable Goods,/L/P/LPAS-106-02b.jpg,lorem-ipsum-dolor16,Not Visible Individually,0,0,363,363,363,Default,607,No,No,simple,base,Sample,In Stock,Yes,500,No
PO174,/L/P/LPAS-106-02b.jpg,45,,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 19,363,dolor sit amet,/L/P/LPAS-106-02b.jpg,Enabled,Taxable Goods,/L/P/LPAS-106-02b.jpg,lorem-ipsum-dolor17,"Catalog, Search",,0,363,363,363,Default,608,Yes,Yes,configurable,base,Sample,In Stock,Yes,500,Yes
PO175,/L/P/LPAS-098-01b.JPG,42,,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 20,284,dolor sit amet,/L/P/LPAS-098-01b.JPG,Enabled,Taxable Goods,/L/P/LPAS-098-01b.JPG,lorem-ipsum-dolor18,"Catalog, Search",0,0,284,284,284,Default,609,No,No,simple,base,Sample,In Stock,Yes,500,No
PO176GR,/L/P/LPAS-131-02b.jpg,56,Green,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 21,328,dolor sit amet,/L/P/LPAS-131-02b.jpg,Enabled,Taxable Goods,/L/P/LPAS-131-02b.jpg,lorem-ipsum-dolor19,Not Visible Individually,0,0,328,328,328,Default,610,No,No,simple,base,Sample,In Stock,Yes,500,No
PO176WH,/L/P/LPAS-131-01b.jpg,12,White,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 22,328,dolor sit amet,/L/P/LPAS-131-01b.jpg,Enabled,Taxable Goods,/L/P/LPAS-131-01b.jpg,lorem-ipsum-dolor20,Not Visible Individually,0,0,328,328,328,Default,611,No,No,simple,base,Sample,In Stock,Yes,500,No
PO176,/L/P/LPAS-131-01b.jpg,13,,"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod
tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,
quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo
consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse
cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non
proident, sunt in culpa qui officia deserunt mollit anim id est laborum.",Yes,Lorem,Lorem ipsum dolor 23,328,dolor sit amet,/L/P/LPAS-131-01b.jpg,Enabled,Taxable Goods,/L/P/LPAS-131-01b.jpg,lorem-ipsum-dolor21,"Catalog, Search",,0,328,328,328,Default,612,Yes,Yes,configurable,base,Sample,In Stock,Yes,500,Yes