User Tools

Site Tools


urapidflow:configurable

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. This 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 here for sample file structure.

Sample files

Bellow are 2 sample files that illustrate the data needed to import configurable products.

Products

Base products import.

products.csv
sku,image,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,category.path,stock.is_in_stock,stock.manage_stock,stock.qty,stock.use_config_manage_stock
PO170LT,/A/C/ACES-074-04b.jpg,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,sample.html,In Stock,Yes,500,No
PO170TC,/A/C/ACES-074-05b.jpg,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,sample.html,In Stock,Yes,500,No
PO170NV,/A/C/ACES-074-06b.jpg,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,sample.html,In Stock,Yes,500,No
PO170,/A/C/ACES-074-04b.jpg,,"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,sample.html,In Stock,Yes,500,Yes
PO171LG,/A/C/ACBS-092-12b.jpg,,"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,sample.html,In Stock,Yes,500,No
PO171SM,/A/C/ACBS-092-14b.jpg,,"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,sample.html,In Stock,Yes,500,No
PO171,/A/C/ACBS-092-14b.jpg,,"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,sample.html,In Stock,Yes,500,Yes
PO172GO,/L/P/LPBS-127-02b.jpg,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,sample.html,In Stock,Yes,500,No
PO172IV,/L/P/LPBS-127-01.jpg,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,sample.html,In Stock,Yes,500,No
PO172SV,/L/P/LPBS-127-06b.jpg,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,sample.html,In Stock,Yes,500,No
PO172BL,/L/P/LPBS-127-08b.jpg,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,sample.html,In Stock,Yes,500,No
PO172,/L/P/LPBS-127-06b.jpg,,"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,sample.html,In Stock,Yes,500,Yes
PO173KY,/L/P/LPAS-015-02b.jpg,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,sample.html,In Stock,Yes,500,No
PO173BL,/L/P/LPAS-015-01b.jpg,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,sample.html,In Stock,Yes,500,No
PO173,/L/P/LPAS-015-02b.jpg,,"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,sample.html,In Stock,Yes,500,Yes
PO174GR,/L/P/LPAS-106-01b.jpg,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,sample.html,In Stock,Yes,500,No
PO174BL,/L/P/LPAS-106-03b.jpg,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,sample.html,In Stock,Yes,500,No
PO174LL,/L/P/LPAS-106-02b.jpg,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,sample.html,In Stock,Yes,500,No
PO174,/L/P/LPAS-106-02b.jpg,,"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,sample.html,In Stock,Yes,500,Yes
PO175,/L/P/LPAS-098-01b.JPG,,"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,sample.html,In Stock,Yes,500,No
PO176GR,/L/P/LPAS-131-02b.jpg,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,sample.html,In Stock,Yes,500,No
PO176WH,/L/P/LPAS-131-01b.jpg,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,sample.html,In Stock,Yes,500,No
PO176,/L/P/LPAS-131-01b.jpg,,"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,sample.html,In Stock,Yes,500,Yes

Products Extra

Products Extra import.

CPSA_CPSI_products.csv
##CPSA,sku,attribute_code,position,label
CPSA,PO170,color,1,Color
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
##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
urapidflow/configurable.txt · Last modified: 2013/11/25 20:36 by jamby77