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.
As a reminder, a packaged lens is a lens that includes an option which is generally a coating.
How to fill the commercial file for GrandVision ?
Section | Data | Data description | Mandatory / Conditional / Optional | Type | Format/Length | Examples | ||
Product identification
| Global Master Code * | Global Master Code | Mandatory if product code is available in the group catalog | String | 6 max | 100067 | 100067 | 100088 |
SF6 Lens Code * | SF6 Lens Code | Mandatory | String | 6 max | DSK16C | DSK16B | IZ1501 | |
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 | |
VAC (Vendor Article Code) * | Vendor Article Code (VAC) | Mandatory | String | 10 max | DSK16C HC | DSK16C HC | IZ1501 SAR | |
Base Lens Name * | Base Lens Name | Mandatory | Enumerated | 40 max | DESK IZY 1.6 | DESK IZY 1.6 | IZY FF 1.5 | |
RX Lens Code *for PbP | Associated RX Lens Code | Mandatory for RX lenses | ||||||
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 | |
Supplier Lens Color Description * | Lens Color Description | Mandatory | String | 40 | N/A | Brown | N/A | |
Lens Appearance * | Lens Appearance | Mandatory | Enumerated | 16 | Clear/None | Solid | Clear/None | |
Commercial data
| Label * | Brand Name | Mandatory | String | DESK | DESK | IZY FF | |
Sub Label | Collection Name | Mandatory | String | SHORT | ||||
Material * | Material | Mandatory | String | MR_8 | MR_8 | CR39 | ||
Country of Origin * | Country of Origin | Mandatory By default it’s the country of your company. | String | FR | FR | FR | ||
Lens Design * | Lens Design | Mandatory | Enumerated | Standard | Standard | Optimised | ||
Design Variant *for freeform lenses | Design Variant | Conditional, empty if FreeForm Produced is Yes | String | N/A | N/A | Flex | ||
Technology *for freeform lenses | Technology | Mandatory | Boolean | Yes or No | No | No | Yes | |
Technical specifications
| Blue Cut Material * | Blue Cut Material | Mandatory | Boolean | Yes or No | No | No | Yes |
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 | |
FreeForm Produced * | FreeForm Produced | Mandatory | Boolean | Yes or No | No | No | No | |
Absorption | Absorption (in %) | Mandatory If no information put N/A | Integer | 40 min 100 max | N/A | 85 | N/A | |
Minimum to Top | Minimum to Top (in mm) | Mandatory If no information put N/A | Integer | xx | N/A | N/A | 15 | |
Pricing information
| Supplier Introduction Date | Supplier Introduction Date | Mandatory | Date | YYYYMMDD | 2013-02-14 | 2013-02-14 | 2021-12-01 |
Supplier Discontinuation date | Supplier Discontinuation date | Mandatory | Date | YYYYMMDD | 2099-12-31 | 2099-12-31 | 2099-12-31 | |
Supplier SKU Status | Supplier SKU Status | Mandatory | Enumerated | 9 max | Active | Active | New | |
Supplier Recommanded Retail Price | Supplier Recommanded Retail Price | Mandatory | Decimal | xxx.xx | 10 | 15 | 53 | |
Logistic information
| Length | Package Length (in mm) | Mandatory | Integer | xxx | 80 | 80 | 80 |
Width | Package Width (in mm) | Mandatory | Integer | xxx | 80 | 80 | 80 | |
Height | Package Height (in mm) | Mandatory | Integer | xxx | 80 | 80 | 80 | |
Gross Weight | Package Gross Weight (in g) | Mandatory Fill y default 19 | Integer | xxx | 19 | 19 | 19 | |
Net Weight | Package Net Weight (in g) | Mandatory Fill y default 18 | Integer | xxx | 18 | 18 | 18 |
List of possibilities for
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 | |||||||
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 |