The commercial file is a complementary file requested by GrandVision in order to complete the product information that is not present in the SF6 format. The aim is to provide a maximum of commercial information on packaged products.
...
How to fill the commercial file for GrandVision ?
Columns | Section | Data | Data description | Mandatory / Conditional / Optional | Type | Format/Length | Examples | |||||
A | Product identification      | Global Master Code * | Global Master Code | Mandatory if product code is available in the group catalog | String | 6 max | 100067 | 100067 | 100088 | 200124 | ||
B | SF6 Lens Code * | SF6 Lens Code | Mandatory | String | 6 max | DSK16C | DSK16B | IZ1501 | ST0238 | |||
C | Article Description * | Product Name | Mandatory | String | 40 max | DESK IZY 1.6 HARD COAT | DESK IZY 1.6 BROWN 85% HARD COAT | IZY FF 1.5 SHORT BLUCUT SUPER AR | SV iZy Stock 1.5 HMC | |||
D | VAC (Vendor Article Code) * | Vendor Article Code (VAC) | Mandatory | String | 10 max | DSK16C HC | DSK16C HC | IZ1501 SARDSK16CHC | DSK16CHC | IZ1501SAR | ST0238HMC | |
E | Base Lens Name * | Base Lens Name | Mandatory | Enumerated | 40 max | DESK IZY 1.6 | DESK IZY 1.6 | IZY FF 1.5 | iZy Stock 1.5 | |||
F | Stock Lens | Indicate if the lens is a Stock or not | Read only, any modification on this column will not change anything | Boolean | No | No | No | Yes | ||||
G | RX Lens Code *for PbP | Associated RX Lens Code | Mandatory for RX Stock lenses else empty | String | SV2526 | |||||||
H | Treatment information     | Coating Code * | Integrated Coating Code | Mandatory if uncoat put N/A | String | 6 max | HC | HC | SAR | |||
Coating Description * | Integrated Coating Description | Conditional, empty if Coating Code is empty | String | 40 max | HARD COAT | HARD COAT | SUPER AR | |||||
Coating Color * | Integrated Coating Color | Mandatory | Enumerated | 3 | 999 | 300 | 999 | |||||
HMC | ||||||||||||
I | Supplier Lens Color Description * | Lens Color Description | Mandatory | String | 40 | N/AClear | BrownN/A | Clear | Clear | |||
J | Lens Appearance * | Lens Appearance | Mandatory | Enumerated | 16 | Clear/None | Solid | Clear/None | Clear/None | |||
K | Commercial data       | Label * | Brand Name | Mandatory | String | DESK | DESK | IZY FF | SV | |||
L | Sub Label | Collection Name | Mandatory | String | SHORT | |||||||
M | Material * | Material | Mandatory | String | MR_8 | MR_8 | CR39 | CR39 | ||||
N | Country of Origin * | Country of Origin | Mandatory By default it’s the country of your company. | String | FR | FR | FR | FR | ||||
O | Lens Design * | Lens DesignLens Design | Mandatory | Enumerated | Standard | Standard | Optimised | Spheric | ||||
P | Design Variant *for freeform lenses | Design Variant | Conditional, empty if FreeForm Produced is Yes | String | N/A | N/ANone | None | Flex | None | |||
Q | Technology *for freeform lenses | Technology | Mandatory | Boolean | Yes or No | No | No | Yes | No | |||
R | Technical specifications     | Blue Cut Material * | Blue Cut Material | Mandatory | Boolean | Yes or No | No | No | Yes | No | ||
S | Photochromic | Indicate if the lens is photochromatic | Read only, any modification on this column will not change anything | No | No | No | No | |||||
T | Photocromic Activation WaveLength *for photochromic lenses | Photocromic Activation WaveLength | Mandatory Indication in nm value. It is use to know if the lens can be tint behind a window | Integer | xxx | N/A | N/A | N/A | ||||
U | Polarized | Indicate if the lens is polarized | Read only, any modification on this column will not change anything | No | No | No | No | |||||
V | UV Protection | Indicate if the lens is UB blocking | Read only, any modification on this column will not change anything | No | No | No | No | |||||
W | FreeForm Produced * | FreeForm Produced | Mandatory | Boolean | Yes or No | No | No | No | No | |||
X | Absorption | Absorption (in %) Mandatory If no information put N/A | Integer | 40 0 min 100 max | N/A | 85 | ||||||
N/AY | Minimum to Top | Minimum to Top (in mm) Mandatory If no information put N/A | Integer | xx | N/A | N/A | 15 | 15 | ||||
Z | Pricing information    | Supplier Introduction Date | Supplier Introduction Date | Mandatory | DateYYYYMMDD | YYYY-MM-DD | 2013-02-14 | 2013-02-14 | 2021-12-01 | 2031-02-14 | ||
AA | Supplier Discontinuation date | Supplier Discontinuation date | Date | YYYYMMDD | 2099YYYY-12MM-31 | 2099-12-31 | 2099-12-31DD | |||||
AB | Supplier SKU Status | Supplier SKU Status | Mandatory | Enumerated | 9 max | Active | Active | New | Active | |||
AC | Market restriction | If empty : the product is available everywhere | ||||||||||
AD | Supplier Recommanded Retail Price | Supplier Recommanded Retail Price | Mandatory | Decimal | xxx.xx | 10 | 15 | 53 | ||||
AE | Logistic information     | Length | Package Length (in mm) | Mandatory | Integer | xxx | 80 | 80 | 80 | |||
AF | Width | Package Width (in mm) | Mandatory | Integer | xxx | 80 | 80 | 80 | ||||
AG | Height | Package Height (in mm) | Mandatory | Integer | xxx | 80 | 80 | 80 | ||||
AH | Gross Weight | Package Gross Weight (in g) | Mandatory Fill y default 19 | Integer | xxx | 19 | 19 | 19 | ||||
AI | Net Weight | Package Net Weight (in g) | Mandatory Fill y default 18 | Integer | xxx | 18 | 18 | 18 |
...
Lens Appearance Label | Material | Lens Design | Lifestyle (Design Variant) | Technology | YesNo | Base Lens | Brand | Collection | Supplier SKU Status |
Solid | Polycarbonate | Spheric | Far | Traditional | Yes | Depend your product list | New | ||
Gradient | CR39 | Aspheric | Flex | Optimised | No | Active | |||
Bi-Gradient | NXT / Trivex | Double Aspheric | Near | Individual | Phase Out | ||||
Clear/None | Polycarbonate | Individual | Driving | Lifestyle | |||||
Filter<15% absorption | Silica / Mineral | Standard | None | ||||||
Tri-gradient/3-color graduated tint | MR_6 | Optimised | |||||||
MR_8 | Lifestyle | ||||||||
MR_10 | Enhanced Reader | ||||||||
MR_174 | Office Vocational | ||||||||
Relax Vision | |||||||||
Trifocal | |||||||||
Lenticular | |||||||||
Bifocal | |||||||||
Myopia Control | |||||||||
Aphake |