uRapidFlow Professional Fixed Row format

The following information comes from here:

http://www.unirgy.com/wiki/urapidflow/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.


Action Char Meaning
+ Insert/Update (optional)
- Delete
% Rename (* see below for explanation)
# Comment line (## is used for row structure explanation)
! Define column order for row type within the file (ROADMAP)


* 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.


EAV Structure Row Types

Allowed actions

Row Type Create Update Delete Rename (*) Description
EA X X X X EAV Attribute
EAL X X X
EAV Attribute Store Specific
EAX
X

EAV Attribute Extension
EAXP
X

EAV Attribute Product Extension
EAS X X X X EAV Attribute Set
EAG X X X X EAV Attribute Group
EASI X X X
EAV Attribute Within Attribute Set
EAO X X X X EAV Attribute Option
EAOL X X X
EAV Attribute Option Store Specific
CC

X
Catalog Category
CCP X X X
Catalog Category-Product Association
CP

X X Catalog Product
CPI X X X
Catalog Product Image
CPIL X X X
Catalog Product Image Store Specific
CPCO X X X X Catalog Product Custom Option
CPCOL X X X
Catalog Product Custom Option Store Specific
CPCOS X X X X Catalog Product Custom Option Selection
CPCOSL X X X
Catalog Product Custom Option Selection Store Specific
CPBO X X X X Catalog Product Bundle Option
CPBOL X X X
Catalog Product Bundle Option Store Specific
CPBOS X X X
Catalog Product Bundle Option Selection
CPRI X X X
Catalog Product Related Item
CPUI X X X
Catalog Product Up Sell Item
CPXI X X X
Catalog Product Cross Sell Item
CPGI X X X
Catalog Product Grouped Item
CPSA X X X X Catalog Product Super Configurable Attribute
CPSAL X X X
Catalog Product Super Configurable Attribute Store Specific
CPSAP X X X
Catalog Product Super Configurable Attribute Pricing
CPSI X X X
Catalog Product Super Configurable Item
CPD X X X X Catalog Product Downloadable
CPDL X X X
Catalog Product Downloadable Label
CPDP X X X
Catalog Product Downloadable Price
CPDS X X X X Catalog Product Downloadable Sample
CPDSL X X X
Catalog Product Downloadable Sample Label
CPPT X X X
Catalog Product Tier Prices
CPPG X X X
Catalog Product Group Prices


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


EA: EAV Attribute

Create/Update Columns

# Column Key? Required? Comments
1 attribute_code X X
2 backend_type
X
3 frontend_input
X
4 frontend_label
X
5 is_required
X
6 is_unique
X
7 entity_type X
If not specified, 'catalog_product' used by default


Examples

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


EAL: EAV Attribute Store Specific

Support only for Magento CE 1.4.0.0+ or EE 1.7.0.0+

Create/Update Columns

# Column Key? Required? Comments
1 attribute_code X X
2 store X X
3 label
X
4 entity_type X
If not specified, 'catalog_product' used by default


EAX: EAV Attribute Extension

Create/Update Columns

# Column Key? Required? Comments
1 attribute_code X X
2 attribute_model


3 backend_model


4 backend_table


5 frontend_model


6 frontend_class


7 source_model


8 default_value


9 note


10 entity_type X
If not specified, 'catalog_product' used by default


EAXP: EAV Attribute Product Extension

Create/Update Columns

# Column Key? Required? Comments
1 attribute_code X X
2 is_global


3 is_visible


4 is_searchable


5 is_filterable


6 is_comparable


7 is_visible_on_front


8 is_html_allowed_on_front


9 is_used_for_price_rules


10 is_filterable_in_search


11 used_in_product_listing


12 used_for_sort_by


13 is_configurable


14 apply_to


15 is_visible_in_advanced_search


16 position


17 frontend_input_renderer


18 is_wysiwyg_enabled



EAS: EAV Attribute Set

Create/Update Columns

# Column Key? Required? Comments
1 set_name X X
2 sort_order


3 entity_type X
If not specified, 'catalog_product' used by default

Examples

Create attribute set
##EAS,set_name,sort_order,entity_type
EAS,New Attribute Set


EAG: EAV Attribute Group

Create/Update Columns

# Column Key? Required? Comments
1 set_name X X
2 group_name X X
3 sort_order


4 entity_type X
If not specified, 'catalog_product' used by default


EASI: EAV Attribute Within Attribute Set

Create/Update Columns

# Column Key? Required? Comments
1 set_name X X
2 group_name X X
3 attribute_code X X
4 sort_order


5 entity_type X
If not specified, 'catalog_product' used by default

Examples

Add attribute to attribute set
##EASI,set_name,group_name,attribute_code,sort_order,entity_type
EASI,New Attribute Set,General,your_attribute,10


EAO: EAV Attribute Option

Create/Update Columns

# Column Key? Required? Comments
1 attribute_code X X
2 option_name X X
3 sort_order


4 entity_type X
If not specified, 'catalog_product' used by default

Examples

Add attribute options
EAO,custom_field,Option 1,1
EAO,custom_field,Option 2,2


EAOL: EAV Attribute Option Store Specific

Create/Update Columns

# Column Key? Required? Comments
1 attribute_code X X
2 option_name X X
3 store X X
4 option_label
Х
5 entity_type X
If not specified, 'catalog_product' used by default


Product Extra Data Row Types

CC: Catalog Category

Examples

Delete categories
-CC,electronics/accessories
-CC,misc/accessories


CCP: Catalog Category-Product Association

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

Examples

Create category-product associations
CCP,electronics/accessories,SKU1,1
CCP,misc/accessories,SKU2,5
Delete category-product associations
-CCP,electronics/accessories,SKU1
-CCP,misc/accessories,SKU2


CP: Catalog Product

Examples

Delete products
-CP,SKU1
-CP,SKU2
Rename product SKU
%CP,OLDSKU,NEWSKU


CPI: Catalog Product Image

Create/Update Columns

# Column Key? Required? Comments
1 sku X X
2 image_url X X
3 label


4 position


5 disabled


Examples

Add Gallery Images


CPIL: Catalog Product Image Store Specific

Create/Update Columns

# Column Key? Required? Comments
1 sku X X
2 image_url X X
3 store X X Can't be “admin”
4 label


5 position


6 disabled



CPCO: Catalog Product Custom Option

Create/Update Columns

# Column Key? Required? Comments
1 sku X X
2 default_title X X
3 type
X
4 is_require


5 option_sku


6 sort_order


7 max_characters


8 price


9 price_type


10 file_extension


11 image_size_x


12 image_size_y


Examples

Add custom options to a product
# // 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


CPCOL: Catalog Product Custom Option Store Specific

Create/Update Columns

# Column Key? Required? Comments
1 sku X X
2 default_title X X
3 store X X
4 title
X
5 price


6 price_type



CPCOS: Catalog Product Custom Option Selection

Create/Update Columns

# Column Key? Required? Comments
1 sku X X
2 default_title X X
3 selection_default_title X X
4 selection_sku


5 sort_order


6 price


7 price_type



CPCOSL: Catalog Product Custom Option Selection Store Specific

Create/Update Columns

# Column Key? Required? Comments
1 sku X X
2 default_title X X
3 selection_default_title X X
4 store
X
5 title
X
6 price


7 price_type



CPBO: Catalog Product Bundle Option

Create/Update Columns


# Column Key? Required? Comments
1 sku X X
2 default_title X X
3 position


4 type


5 required



Examples

Add a Bundle Product


##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


CPBOL: Catalog Product Bundle Option Store Specific

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 default_title X X
3 store X X
4 title
X



CPBOS: Catalog Product Bundle Option Selection

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 default_title X X
3 selection_sku X X
4 position


5 is_default


6 selection_price_type


7 selection_price_value


8 selection_qty


9 selection_can_change_qty




CPRI: Catalog Product Related Item

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 linked_sku X X
3 position


4 qty




CPUI: Catalog Product Up Sell Item

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 linked_sku X X
3 position


4 qty




CPXI: Catalog Product Cross Sell Item

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 linked_sku X X
3 position


4 qty




CPGI: Catalog Product Grouped Item

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 linked_sku X X
3 position


4 qty




CPSA: Catalog Product Super Configurable Attribute

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 attribute_code X X
3 position
X
4 label
X



Examples

Basic link between configurable product and 5 simple products using 2 attributes


##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


CPSAL: Catalog Product Super Configurable Attribute Store Specific

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 attribute_code X X
3 store
X
4 label




CPSAP: Catalog Product Super Configurable Attribute Pricing

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 attribute_code X X
3 value_label X X
4 website X X
5 pricing_value
X
6 is_percent
X



CPSI: Catalog Product Super Configurable Item

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 linked_sku X X



CPPT: Catalog Product Tier Prices

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 customer_group X X Use '*' for all groups
3 qty X X
4 price
X
5 website




Delete Columns



# Column Key? Required? Comments
1 sku X X
2 customer_group X X Use '*' for all groups
3 qty X X
4 website




CPPG: Catalog Product Group Prices

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 customer_group X X
3 price
X
4 website




Delete Columns



# Column Key? Required? Comments
1 sku X X
2 customer_group X X
4 website




CPD: Catalog Product Downloadable

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 title X X
3 price


4 max_downloads


5 is_shareable


6 sort_order


7 link_url


8 link_file


9 link_type


10 sample_url


11 sample_file


12 sample_type




CPDL: Catalog Product Downloadable Store Specific

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 default_title X X
3 store X X
4 title
X



CPDP: Catalog Product Downloadable Website Price

Create/Update Columns



# Column Key? Required? Comments
1 sku X X
2 default_title X X
3 website X X
4 price
X



CPDS: Catalog Product Downloadable Sample

Columns



# Column Key? Required? Comments
1 sku X X
2 title X X
3 sort_order


4 sample_url


5 sample_file


6 sample_type




CPDSL: Catalog Product Downloadable Sample Store Specific

Columns



# Column Key? Required? Comments
1 sku X X
2 default_title X X
3 store X X
4 title
X



Roadmap



Row Type Description Comments
CT Catalog Tag
CTL Catalog Tag Store Specific
CTP Catalog Tag Product Relation
CS Catalog Search
AC Customer
AA Customer Address
SO Sales Order
SI Sales Invoice
SS Sales Shipment
SC Credit Memo



CT: Catalog Tag

Columns



# Column Key? Required? Comments
1 tag_name X X
2 status




CTL: Catalog Tag Store Specific

Columns



# Column Key? Required? Comments
1 tag_name X X
2 store


3 customers


4 products


5 uses


6 historical_uses


7 popularity




CTP: Catalog Tag Product Relation

Columns



# Column Key? Required? Comments
1 sku X X
2 tag_name X X
3 store


4 active


5 created_at