Column Specifications
| Column Name(A) | Column Identifier for Auto Matching | Data Type | Correspondences 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 | No | No | 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-name | single-line | 1 | 1 | No | No | Allows chars 0-9, A-Z, and a-z. Example: Apple iPad |
| Product Brief(short) | $s-pdt-brief_short | single-line | 2 | 2 | No | No | Allows chars 0-9, A-Z, and a-z. Example: comes with powerful apps for the things you do every day. |
| Item Cost | $f-item-cost | decimal(2) | 3 | 3 | No | No | Allows number: 0-100000000, 2 decimal places. |
| List Price | $f-list-price | decimal(2) | 4 | 4 | No | No | Allows number: 0-100000000, 2 decimal places. |
| Our Price | $f-our-price | decimal(2) | 5 | 5 | No | No | Allows number: 0-100000000, 2 decimal places. |
| $Unit | $s-price-per-unit | single-line | 6 | 6 | No | No | Allows chars 0-9, A-Z, and a-z. Example(1): per unit; Example(2): /pcs. |
| Shipping Weight(kg) | $f-gross-wgt | decimal(2) | 7 | 7 | No | No | Allows number: 0-100000000, 2 decimal places. Unit: Kilogram(KG) |
| Stock QTY | $i-stock | integer | 8 | 8 | No | No | Allows number: 0-100000000. |
| Min. Order QTY | $i-min-order-qty | integer | 9 | 9 | No | No | Allows number: 1-100000000. |
| Max.Order QTY | $i-max-order-qty | integer | 10 | 10 | No | No | Allows number: 1-100000000. |
| Product Reviews | $i-re-views | integer | 11 | 11 | No | No | Allows number: 0-100000000. |
| Access Level | $i-access-level | integer | 39 | / | No | No | Allows number: 0-2. Don't Publish[0]; Public[1]; Private[2] |
| Availability | $i-availability | integer | 12 | 12 | No | No | Allows 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-ids | array string | 13 | 13 | | No | No | Allows 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-line | multi-line | 14 | 14 | Yes | Yes | User 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-line | multi-line | 15 | 15 | Yes | Yes | |
| #Product Detail(Right) | $m-detail_multi-line2 | multi-line | 16 | 16 | Yes | Yes | |
| #Whats Included | $m-os_multi-line | multi-line | 17 | 17 | Yes | Yes | |
| #HTML Tag | $m-html-tag | multi-line | 18 | 18 | Yes | Yes | |
| #searchable Keywords | $m-searchable-keyword | multi-line | 19 | 19 | Yes | Yes | |
| #Internal Use Only | $m-internal-use-only_multi-line | multi-line | 20 | 20 | Yes | Yes | |
| Color Code | $s-color-code | single-line | 21 | 21 | | No | No | Allows chars 0-9, A-Z, and a-z. Example(1): Blue Example(2): Red |
| Size Code | $s-size-code | single-line | 22 | 22 | | No | No | Allows 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-ids | array string | 23 | 23 | | No | No | Allows 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-1 | single-line | 24 | 24 | No | No | Allows chars 0-9, A-Z, and a-z. Corresponding to $m-tab-mvalue-1 |
| TAB Title(2) | $s-tab-title-2 | single-line | 25 | 25 | No | No | Allows chars 0-9, A-Z, and a-z. Corresponding to $m-tab-mvalue-2 |
| TAB Title(3) | $s-tab-title-3 | single-line | 26 | 26 | No | No | Allows chars 0-9, A-Z, and a-z. Corresponding to $m-tab-mvalue-3 |
| TAB Title(4) | $s-tab-title-4 | single-line | 27 | 27 | No | No | Allows chars 0-9, A-Z, and a-z. Corresponding to $m-tab-mvalue-4 |
| TAB Title(5) | $s-tab-title-5 | single-line | 28 | 28 | No | No | Allows chars 0-9, A-Z, and a-z. Corresponding to $m-tab-mvalue-5 |
| #TAB Value(1) | $m-tab-mvalue-1 | multi-line | 29 | 29 | Yes | Yes | User 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-2 | multi-line | 30 | 30 | Yes | Yes | |
| #TAB Value(3) | $m-tab-mvalue-3 | multi-line | 31 | 31 | Yes | Yes | |
| #TAB Value(4) | $m-tab-mvalue-4 | multi-line | 32 | 32 | Yes | Yes | |
| #TAB Value(5) | $m-tab-mvalue-5 | multi-line | 33 | 33 | Yes | Yes | |
| Path to Vertical Product Menu | $s-path-to_VPM | single-line | 38 | No | No | - | |
| Meta Title | $s-meta-title | single-line | 34 | No | No | Allows chars 0-9, A-Z, and a-z. | |
| Meta Keywords | $s-meta-keywords | single-line | 35 | No | No | Allows chars 0-9, A-Z, and a-z. | |
| Meta Desc | $s-meta-desc | single-line | 36 | No | No | Allows chars 0-9, A-Z, and a-z. | |
| END | END | / | / | / | / | / | End of column identifier: "END" must exist in the last column. |
