uRapidFlowPro Fixed Row format

While Product and Category records require a dynamic row format, which would allow flexible columns configuration, other information in catalog requires well defined and DB oriented format. We call it “fixed row format”.

Example of file with fixed format rows:

##CPCO,sku,default_title,type,is_require,option_sku,sort_order,max_characters,price,price_type,file_extension,image_size_x,image_size_y
CPCO,SKU1,"Custom Option 1",drop_down,0,OPTION_SKU,1

##CPCOL,sku,default_title,store,title,price,price_type
CPCOL,SKU1,"Custom Option 1",store1,"Store Specific Option Name"

##CPCOS,sku,default_title,selection_default_title,selection_sku,sort_order,price,price_type
CPCOS,SKU1,"Custom Option 1","Product Selection Name",SELSKU1,1

##CPCOSL,sku,default_title,selection_default_title,store,title,price,price_type
CPCOSL,SKU1,"Custom Option 1","Product Selection Name",store1,"Store Specific Selection Name"

##CPRI,sku,linked_sku,position,qty
CPRI,SKU1,RELATED_SKU

##CPGI,sku,linked_sku,position,qty
CPGI,SKU1,GROUPED_SKU,1,2

The file above will create a dropdown custom option named “Custom Option 1” for product SKU1. This custom option will have store view specific label “Store Specific Option Name”, and a selection of one product “Product Selection Name”, with store view specific label as well. Also, it will add RELATED_SKU as related to SKU1 and GROUPED_SKU as a child grouped product with default quantity of 2.

Each row begins with action char and row type identifier. If action char is ommited, insert/update is implied.

* For example, in CPCO, “default_title” is used as a key to update store view specific records. Use ”[%] Rename” action to change this title.

First few fields are always required, others are optional, but the row structure should always remain the same.

This allows to combine different types of fixed format rows into the same file, as there's no need for header titles, which means each row's structure is well known and will be expected by the parser.

* Rename is in ROADMAP, currently only CP and CPBO are implemented.

##EA,attribute_code,backend_type,frontend_input,frontend_label,is_required,is_unique
EA,custom_field,varchar,select,Custom Dropdown Field,0,0

Support only for Magento CE 1.4.0.0+ or EE 1.7.0.0+

##EAS,set_name,sort_order,entity_type
EAS,New Attribute Set

##EASI,set_name,group_name,attribute_code,sort_order,entity_type
EASI,New Attribute Set,General,your_attribute,10

EAO,custom_field,Option 1,1
EAO,custom_field,Option 2,2

-CC,electronics/accessories
-CC,misc/accessories

Can be used to specify product position within category. Alternatively, products can be associated in “Product” data type files.

CCP,electronics/accessories,SKU1,1
CCP,misc/accessories,SKU2,5

-CCP,electronics/accessories,SKU1
-CCP,misc/accessories,SKU2

-CP,SKU1
-CP,SKU2

%CP,OLDSKU,NEWSKU

# // Add a non-required text custom option
##CPCO,sku,default_title,type,is_require,option_sku,sort_order,max_characters,price,price_type,file_extension,image_size_x,image_size_y
CPCO,PRODUCT_SKU,Text option,field,0,,1

# // Add a required dropdown custom option
##CPCO,sku,default_title,type,is_require,option_sku,sort_order,max_characters,price,price_type,file_extension,image_size_x,image_size_y
CPCO,PRODUCT_SKU,Color,drop_down,1,,2
##CPCOS,sku,default_title,selection_default_title,selection_sku,sort_order,price_price_type
CPCOS,PRODUCT_SKU,Color,Blue,BLUE,1
CPCOS,PRODUCT_SKU,Color,Red,RED,2

##CPBO,sku,default_title,position,type,required
CPBO,BUNDLE_SKU,CPU,1,select,1
CPBO,BUNDLE_SKU,RAM,2,select,0
##CPBOS,sku,default_title,selection_sku,position,is_default,selection_price_type,selection_price_value,selection_qty,selection_can_change_qty
CPBOS,BUNDLE_SKU,CPU,"CORE2DUO",1,1,0,100,1,0
CPBOS,BUNDLE_SKU,CPU,"PHENOMII",2,0,0,120,1,0
CPBOS,BUNDLE_SKU,RAM,"2GB",1,1,0,30,1,1
CPBOS,BUNDLE_SKU,RAM,"4GB",2,0,0,60,1,1

##CPSA,sku,attribute_code,position,label
CPSA,CONFIGURABLE,color,1,Color
CPSA,CONFIGURABLE,size,2,Size
##CPSI,sku,linked_sku
CPSI,CONFIGURABLE,SIMPLE-BLUE-L
CPSI,CONFIGURABLE,SIMPLE-RED-L
CPSI,CONFIGURABLE,SIMPLE-BLUE-M
CPSI,CONFIGURABLE,SIMPLE-RED-M
CPSI,CONFIGURABLE,SIMPLE-BLUE-S