Differences

This shows you the differences between two versions of the page.

--- urapidflow:configurable [2013/11/25 20:33]
jamby77
+++ urapidflow:configurable [2013/11/25 20:36] (current)
jamby77
@@ Line 1: / Line 1: @@
+===== To import configurable products, you should: =====
+  - 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.
+  - Link attributes with configurable products using profile with 'Data Type' - 'Products Extra'
+  - 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 [[urapidflow/fixed_row_format#cpsacatalog_product_super_configurable_attribute|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.
+<file csv 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
+</file>
+=== Products Extra ===
+Products Extra import.
+<file csv 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
+</file>

UnirgyWiki

User Tools

Site Tools

Differences

Page Tools