...
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
Freeform technology
...
Mandatory
...
Boolean
...
Yes or No
...
No
...
No
...
No
...
No
...
X
...
Absorption
...
Absorption (in %)
Global UV absorption (%)
...
Integer
...
0 min
100 max
...
85
...
Y
...
Minimum to Top
...
Minimum to Top (in mm)
The minimum distance (mm) needed from pupil to the top of the frame/lens
...
Integer
...
xx
...
15
...
Z
...
Pricing information
...
Supplier Introduction Date
...
Supplier Introduction Date
Introduction Date of the packaged product
...
Mandatory
...
Date
...
YYYY-MM-DD
...
2013-02-14
...
2013-02-14
...
2021-12-01
...
2031-02-14
...
AA
...
Supplier Discontinuation date
...
Supplier Discontinuation date
End Date of the packaged product
...
Date
...
YYYY-MM-DD
...
AB
...
Supplier SKU Status
...
Supplier SKU Status
Product status
...
Mandatory
...
Enumerated
...
9 max
...
Active
...
Active
...
New
...
Active
...
AC
...
Market restriction
Country-Banner Restriction
...
If empty : the product is available everywhere
If one or several country-banner are selected (multiselection possible) : the product is only available in the selected country-banners
...
AD
...
Supplier Recommanded Retail Price
...
Supplier Recommanded Retail Price
Recommended selling price for the product
...
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
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
...
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
...
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 ?
...
Columns
...
Section
...
Data
...
Data description
...
Mandatory / Conditional / Optional
...
Type
...
Format/Length
...
Examples
...
A
...
Product identification
...
Global Master Code *
...
Global Master Code
Product code in the group catalog (if available)
...
Mandatory if product code is available in the group catalog
...
String
...
6 max
...
100067
...
100067
...
100088
...
200124
...
B
...
SF6 Lens Code *
...
SF6 Lens Code
Generic lens in the SF6 File
...
Mandatory
...
String
...
6 max
...
DSK16C
...
DSK16B
...
IZ1501
...
ST0238
...
C
...
Article Description *
...
Product Name
Name of the packaged product (Baselens + Coating)
...
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)
Order code of the packaged product
...
Mandatory
...
String
...
10 max
...
DSK16CHC
...
DSK16CHC
...
IZ1501SAR
...
ST0238HMC
...
E
...
Base Lens Name *
...
Base Lens Name
Base Lens category
...
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
RX lens package associated with Stock lens package
Mandatory if Lens is Stock
...
Mandatory for Stock lenses
else empty
...
String
...
SV2526
...
H
...
Treatment information
...
Coating Code *
...
Integrated Coating Code
Coating treatment in the package version
Empty if Uncoat
...
Mandatory if uncoat put N/A
...
String
...
6 max
...
HC
...
HC
...
SAR
...
HMC
...
I
...
Supplier Lens Color Description *
...
Lens Color Description
Tint of the lens
...
Mandatory
...
String
...
40
...
Clear
...
Brown
...
Clear
...
Clear
...
J
...
Lens Appearance *
...
Lens Appearance
Type of tint (Gradient, …)
...
Mandatory
...
Enumerated
...
16
...
Clear/None
...
Solid
...
Clear/None
...
Clear/None
...
K
...
Commercial data
...
Label *
...
Brand Name
Brand
...
Mandatory
...
String
...
DESK
...
DESK
...
IZY FF
...
SV
...
L
...
Sub Label
...
Collection Name
Collection
...
Mandatory
...
String
...
SHORT
...
M
...
Material *
...
Material
Material (Commercial name)
...
Mandatory
...
String
...
MR_8
...
MR_8
...
CR39
...
CR39
...
N
...
Country of Origin *
...
Country of Origin
Country of the product
...
Mandatory
By default it’s the country of your company.
...
String
...
FR
...
FR
...
FR
...
FR
...
O
...
Lens Design *
...
Lens Design
...
Mandatory
...
Enumerated
...
Standard
...
Standard
...
Optimised
...
Spheric
...
P
...
Design Variant *for freeform lenses
...
Design Variant
Style of use
Mandatory if lens is Freeform
...
Conditional, empty if FreeForm Produced is Yes
...
String
...
None
...
None
...
Flex
...
None
...
Q
...
Technology *for freeform lenses
...
Technology
Mandatory if lens is Freeform
...
Mandatory
...
Boolean
...
Yes or No
...
No
...
No
...
Yes
...
No
...
R
...
Technical specifications
...
Blue Cut Material *
...
Blue Cut Material
Blue light cut in the mass
...
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 if lens is Photochromic
...
Mandatory Indication in nm value. It is use to know if the lens can be tint behind a window
...
Enumerated
...
Yes - UV light
Yes - UV + visible light
No
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.
| Info |
|---|
As a reminder: a packaged lens is a lens that includes an option which is generally a coating. |
Commercial file template:
| View file | ||
|---|---|---|
|
HOW TO FILL GRANDVISION COMMERCIAL FILE?
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 | Text | 6 max | 100067 | 100068 | 100088 | 200124 |
B | SF6 Lens Code * | SF6 Lens Code | Mandatory | Text | 6 max | DSK16C | DSK16T | IZ1501 | ST0238 | |
C | Article Description * | Product Name | Mandatory | Text | 40 max | DESK IZY 1.6 HARD COAT | DESK IZY 1.6 TR BROWN 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 | Text | 10 max | DSK16CHC | DSK16TBC | IZ1501SAR | ST0238HMC | |
E | EDI Code (France only) | EDI Code (France only) Change the distributor product code of the integrated lens | Optional | Text | BUR16CHC | |||||
F | Base Lens Name * | Base Lens Name | Mandatory | List | 40 max | DESK IZY 1.6 | DESK IZY 1.6 TR | IZY FF 1.5 | iZy Stock 1.5 | |
G | Stock Lens | Indicate if the lens is a Stock or not | Read only, just for information, any modification on this column will not change anything | Yes/No | No | No | No | Yes | ||
H | RX Lens Code *for PbP | Associated RX Lens Code | Mandatory only for Stock lenses If the lens is not a stock the code will be ignore | Text | SV2526 | |||||
I | Treatment information
| Coating Code | Integrated Coating Code | Mandatory if uncoat put N/A | Text | 6 max | HC | HC | SAR | HMC |
J | Coating Description | Mandatory if a coating code is set | Hard Coat | HMC | ||||||
K | Coating Color | Leave empty if no coating color. | List | Brown | ||||||
L | Lens information | Supplier Lens Color Description * | Lens Color Description | Mandatory For a non-tinted lens → the field has to be filled with “Clear” | Text | 40 | Clear | Photochromic Brown | Clear | Clear |
M | Lens Appearance * | Lens Appearance | Mandatory For a non-tinted lens → the field has to be filled with “Clear/None” | List | 16 | Clear/None | Clear/None | Clear/None | Clear/None | |
N | Commercial data
| Label * | Brand Name | Mandatory | Text | DESK | DESK | IZY FF | SV | |
O | Sub Label | Collection Name | Mandatory | Text | SHORT | |||||
P | Material * | Material | Mandatory | Text | MR_8 | MR_8 | CR39 | CR39 | ||
Q | Country of Origin * | Country of Origin | Mandatory By default it’s the country of your company. | Text | FR | FR | FR | FR | ||
R | Lens Design * | Lens Design | Mandatory | List | Standard | Standard | Aspheric | Spheric | ||
S | Design Variant * for freeform lenses | Design Variant | Mandatory By default N/A | List | None | None | Flex | None | ||
T | Technology | Technology | Mandatory By default N/A | List | No | No | Individual | No | ||
U | Technical specifications
| Blue Cut Material * | Blue Cut Material | Mandatory | Yes/No | Yes or No | No | No | Yes | No |
V | Photochromic * | Indicate if the lens is photochromatic | Mandatory | List | Yes - UV light Yes - UV + visible light No | No | Yes | No | No | |
W | 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 | 390 | ||||
X | Polarized * | Indicate if the lens is polarized | Read only, just for information, any modification on this column will not change anything | Yes/No | No | No | No | No | ||
Y | UV Protection * | Indicate if the lens is UB blocking | Read only, just for information, any modification on this column will not change anything | Yes/No | No | No | No | No | ||
Z | FreeForm Produced * | FreeForm Produced | Mandatory | Boolean | Yes or No | No | No | Yes | No | |
AA | Absorption * | Absorption (in %) | Mandatory | Integer | 0 min 100 max | 85 | ||||
AB | Minimum to Top | Minimum to Top (in mm) | Integer | xx | 15 | |||||
AC | Pricing information
| Supplier Introduction Date * | Supplier Introduction Date | Mandatory | Date | YYYY-MM-DD | 2013-02-14 | 2013-02-14 | 2021-12-01 | 2031-02-14 |
AD | Supplier Discontinuation date | Supplier Discontinuation date | Mandatory if the the supplier SKU Status = Phase Out | Date | YYYY-MM-DD | |||||
AE | Supplier SKU Status | Supplier SKU Status | Mandatory | List (see blelow) | 9 max | Active | Active | New | Active | |
AF | Market restriction | If empty : the product is available everywhere | Text | |||||||
AG | Logistic information(can be average values)
| Length * | Package Length (in mm) | Mandatory | Integer | xxx | 80 | 80 | 80 | 80 |
AH | Width * | Package Width (in mm) | Mandatory | Integer | xxx | 80 | 80 | 80 | 80 | |
AI | Height * | Package Height (in mm) | Mandatory | Integer | xxx | 80 | 80 | 80 | 80 | |
AJ | Gross Weight * | Package Gross Weight (in g) | Mandatory Fill y default 19 | Integer | xxx | 19 | 19 | 19 | 19 | |
AK | Net Weight * | Package Net Weight (in g) | Mandatory Fill y default 18 | Integer | xxx | 18 | 18 | 18 | 19 | |
AL | Pricing : to be shared with GV procurement | (Supplier will delete this columns before sending the file back to iWi) | Net Price | Those columns can be on the import file but they won’t read. | ||||||
AM | Transport/handling fee | |||||||||
AN | Invoice Price | |||||||||
List of possibilities for:
Lens Appearance Label | Material | Lens Design | Design Variant * for freeform lenses | Technology | YesNo | Base Lens | Brand | Collection | Supplier SKU Status |
Solid | Polycarbonate | Aphake | 40 | Traditional | Yes | Depend your product list | New | ||
Gradient | CR39 | Aspheric | A | Optimised | No | Active | |||
Bi-Gradient | NXT / Trivex | Bifocal | Act | Individual | Phase Out | ||||
Clear/None | Silica / Mineral | Double Aspheric | All | Lifestyle | |||||
Filter<15% absorption | MR_6 | Enhanced Reader | B | ||||||
Tri-gradient/3-color graduated tint | MR_8 | Individual | BC | ||||||
MR_10 | Individual Occupational | Book | |||||||
MR_174 | Lenticular | CI | |||||||
Lifestyle | Driving | ||||||||
Lifestyle Occupational | EC | ||||||||
Multi Aspheric | Exp | ||||||||
Myopia Control | Far | ||||||||
Office Vocational | Flex | ||||||||
Optimised | L | ||||||||
Progressive | M | ||||||||
Progressive Lenti | Maxi | ||||||||
Relax Vision | Near | ||||||||
Round | None | ||||||||
Specialist | Office | ||||||||
Spheric | P0.5 | ||||||||
Standard Occupational | P0.8 | ||||||||
Trifocal | P1.1 | ||||||||
PC | |||||||||
Proxi | |||||||||
Room | |||||||||
S | |||||||||
V | |||||||||
XS | |||||||||
List of possible errors you can have on your import:
[Warning]: The Base Lens XXX does not exist
The lens is not on the SF6 or/and not exists in iWi
[Warning]: The coating color is present but there is no lens appearance at line YYY
Reason : Coating color is not like None or Clear AND lens apparence is Clear/None
[Warning]: The Lens Appearence is present but there is no Coating color at line YYY
Reason : Lens apparence is not like Clear/None AND CoatingColor is None or empty AND SupplierLensColorDescription is"None" or empty
[Warning]: The brand code XXX is unknown
1 - You must check this data conformity on the file (sensitive case, expected entry)
2 - You must contact GV to ask them to create this new one.
[Warning]: The Collection code XXX is unknown
1 - You must check this data conformity on the file (sensitive case, expected entry)
2 - You must contact GV to ask them to create this new one.
[Warning]: Technology (Integrated Lens): Mandatory data on line YYY
Must contains at least N/A. See enumarated values Technology
[Warning]: Design variant for FreeForm lenses (Integrated Lens): Mandatory data on line YYY
Must contains at least N/A. See enumarated values Design variant for FreeForm lenses
[Warning]: The value XXX is not correct for the specific data Material at line YYY
You must check this data conformity on the file (sensitive case, expected entry). See enumarated values Material
[Warning]: The value XXX is not correct for the specific data Lens Design at line YYY
You must check this data conformity on the file (sensitive case, expected entry). See enumarated values Lens Design
[Warning]: The value XXX is not correct for the specific data Lens Appearance Label at line YYY
You must check this data conformity on the file (sensitive case, expected entry). See enumarated values Lens Appearance Label
[Warning]: The value XXX is not correct for the specific data Supplier SKU Status at line YYY
You must check this data conformity on the file (sensitive case, expected entry). See enumarated values Supplier SKU Status
[Error]: Global Master Code already exists on the file at line YYY
This code must be unique
[Warning]: La valeur XXX n'est pas correcte pour la donnée spécifique Base Lens à la ligne YYY
[Warning]: La valeur XXX n'est pas correcte pour la donnée spécifique Coating Color à la ligne YYY
The defined value doesn’t exist on the list of possibilities. See your specific enumarated values.