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