Column Specifications

Column Name(A)Column Identifier
for Auto Matching
Data TypeCorrespondences
admin-side
Correspondences
client-side
User definable
Column Name(A)
Allow Repeat
Column Name(A)
Column
Properties
Item No#
(either Pdtid#)
$s-item-no
(either $i-pdt-id)
single-line NoNo Unique Identity, Mandatory.
For the purpose of indexing and doing column-matching, do not repeat(unique):

Item No#
Allows chars 0-9, A-Z, and a-z.
Example: item0001

Pdtid#
(unique id, generated by the system)
Product Name$s-pdt-namesingle-line 1 1NoNoAllows chars 0-9, A-Z, and a-z.

Example: Apple iPad
Product Brief(short) $s-pdt-brief_shortsingle-line 2 2NoNoAllows chars 0-9, A-Z, and a-z.

Example: comes with powerful apps for the things you do every day.
Item Cost$f-item-costdecimal(2) 3 3NoNoAllows number: 0-100000000, 2 decimal places.
List Price$f-list-pricedecimal(2) 4 4NoNoAllows number: 0-100000000, 2 decimal places.
Our Price$f-our-pricedecimal(2) 5 5NoNoAllows number: 0-100000000, 2 decimal places.
$Unit$s-price-per-unitsingle-line 6 6NoNoAllows chars 0-9, A-Z, and a-z.

Example(1): per unit;
Example(2): /pcs.
Shipping Weight(kg)$f-gross-wgtdecimal(2) 7 7NoNoAllows number: 0-100000000, 2 decimal places.

Unit: Kilogram(KG)
Stock QTY$i-stockinteger 8 8NoNoAllows number: 0-100000000.
Min. Order QTY$i-min-order-qtyinteger 9 9NoNoAllows number: 1-100000000.
Max.Order QTY$i-max-order-qtyinteger 10 10NoNoAllows number: 1-100000000.
Product Reviews$i-re-viewsinteger 11 11NoNoAllows number: 0-100000000.
Access Level$i-access-levelinteger 39 /NoNo Allows number: 0-2.
Don't Publish[0]; Public[1]; Private[2]
Availability$i-availabilityinteger 12 12NoNoAllows number: 0-2. Out-of-Stock icon will be showing up if input value=2.

Not For Sales[0]; On Sales[1]; Out-Of-Stock[2]
Recommended Products(Item No#)$a-recommended-pdts_pdt-idsarray string 13 13 | NoNoAllows Item No#, separarted by comma ",".
A scrollable Product-Carousel will be generated at bottom of this product detail page.

Example: itemi0001,item0002,item0003,item0005
#Product Brief$m-brief_multi-linemulti-line 14 14YesYesUser definable Column Name(A) - change the name of column(A) to define your own title.

Allow Repeat Column Name(A) - if repeatedly defined, data will be appended to the same column instead of replacing.

If char # is removed, the first row will be treated as title.

Example of Repeat Column Name:
Color: Blue, White
Material: Cotton
Lead Time: 5 days
#Product Detail(Left)$m-detail_multi-linemulti-line 15 15YesYes
#Product Detail(Right)$m-detail_multi-line2multi-line 16 16YesYes
#Whats Included$m-os_multi-linemulti-line 17 17YesYes
#HTML Tag$m-html-tagmulti-line 18 18YesYes
#searchable Keywords$m-searchable-keywordmulti-line 19 19YesYes
#Internal Use Only$m-internal-use-only_multi-linemulti-line 20 20YesYes
Color Code $s-color-codesingle-line 21 21 | NoNoAllows chars 0-9, A-Z, and a-z.

Example(1): Blue
Example(2): Red
Size Code $s-size-codesingle-line 22 22 | NoNoAllows chars ")", 0-9, A-Z, and a-z.
Order Sequence(ASC): add numeric prefix with char ")".

Example(1): S
Example(2): M
Example(2): XL
Combo-Option IDs $a-combo-option-idsarray string 23 23 | NoNoAllows Item No#, separarted by comma ",".
In addition to sharing a combo-set to designated items;
which also facilitates you to enable or disable any combo-option(s) from the primary one.

Example: 25522,25523,9552,10447
TAB Title(1) $s-tab-title-1single-line 24 24NoNoAllows chars 0-9, A-Z, and a-z.

Corresponding to $m-tab-mvalue-1
TAB Title(2)$s-tab-title-2single-line 25 25NoNoAllows chars 0-9, A-Z, and a-z.

Corresponding to $m-tab-mvalue-2
TAB Title(3)$s-tab-title-3single-line 26 26NoNoAllows chars 0-9, A-Z, and a-z.

Corresponding to $m-tab-mvalue-3
TAB Title(4)$s-tab-title-4single-line 27 27NoNoAllows chars 0-9, A-Z, and a-z.

Corresponding to $m-tab-mvalue-4
TAB Title(5)$s-tab-title-5single-line 28 28NoNoAllows chars 0-9, A-Z, and a-z.

Corresponding to $m-tab-mvalue-5
#TAB Value(1)$m-tab-mvalue-1multi-line 29 29YesYesUser definable Column Name(A) - change the name of column(A) to define your own title.

Allow Repeat Column Name(A) - if repeatedly defined, data will be appended to the same column instead of replacing.

If char # is removed, the first row will be treated as title.

Example of Repeat Column Name:
Color: Blue, White
Material: Cotton
Lead Time: 5 days

Corresponding to $s-tab-title-1 - $s-tab-title-5
#TAB Value(2)$m-tab-mvalue-2multi-line 30 30YesYes
#TAB Value(3)$m-tab-mvalue-3multi-line 31 31YesYes
#TAB Value(4)$m-tab-mvalue-4multi-line 32 32YesYes
#TAB Value(5) $m-tab-mvalue-5multi-line 33 33YesYes
Path to Vertical Product Menu$s-path-to_VPMsingle-line 38 NoNo -
Meta Title$s-meta-titlesingle-line 34 NoNoAllows chars 0-9, A-Z, and a-z.
Meta Keywords$s-meta-keywordssingle-line 35 NoNoAllows chars 0-9, A-Z, and a-z.
Meta Desc$s-meta-descsingle-line 36 NoNoAllows chars 0-9, A-Z, and a-z.
ENDEND / / / / /End of column identifier:
"END" must exist in the last column.