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.

Commercial file template:

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 Product code in the group catalog (if available)	Mandatory if product code is available in the group catalog	Text	6 max	100067	100068	100088	200124
B		SF6 Lens Code *	SF6 Lens Code Generic lens in the SF6 File	Mandatory	Text	6 max	DSK16C	DSK16T	IZ1501	ST0238
C		Article Description *	Product Name Name of the packaged product (Baselens + Coating)	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) Order code of the packaged product	Mandatory	Text	10 max	DSK16CHC	DSK16TBC	IZ1501SAR	ST0238HMC
E		Base Lens Name *	Base Lens Name Base Lens category	Mandatory	List	40 max	DESK IZY 1.6	DESK IZY 1.6 TR	IZY FF 1.5	iZy Stock 1.5
F		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
G		RX Lens Code *for PbP	Associated RX Lens Code RX lens package associated with Stock lens package Mandatory if Lens is Stock	Mandatory only for Stock lenses If the lens is not a stock the code will be ignore	Text					SV2526
H	Treatment information	Coating Code	Integrated Coating Code Coating treatment in the package version Empty if Uncoat	Mandatory if uncoat put N/A	Text	6 max	HC	HC	SAR	HMC
I		Coating Description		Mandatory if a coating code is set				Hard Coat		HMC
J		Coating Color			List			Brown
K		Supplier Lens Color Description *	Lens Color Description Tint of the lens	Mandatory	Text	40	Clear	Photochromic Brown	Clear	Clear
L		Lens Appearance *	Lens Appearance Type of tint (Gradient, …)	Mandatory	List	16	Clear/None	Clear/None	Clear/None	Clear/None
M	Commercial data	Label *	Brand Name Brand	Mandatory	Text		DESK	DESK	IZY FF	SV
N		Sub Label	Collection Name Collection	Mandatory	Text				SHORT
O		Material *	Material Material (Commercial name)	Mandatory	Text		MR_8	MR_8	CR39	CR39
P		Country of Origin *	Country of Origin Country of the product	Mandatory By default it’s the country of your company.	Text		FR	FR	FR	FR
Q		Lens Design *	Lens Design	Mandatory	List		Standard	Standard	Aspheric	Spheric
R		Design Variant * for freeform lenses	Design Variant Style of use Mandatory if lens is Freeform	Mandatory By default N/A	List		None	None	Flex	None
S		Technology	Technology Mandatory if lens is Freeform	Mandatory By default N/A	List		No	No	Individual	No
T	Technical specifications	Blue Cut Material *	Blue Cut Material Blue light cut in the mass	Mandatory	Yes/No	Yes or No	No	No	Yes	No
U		Photochromic *	Indicate if the lens is photochromatic	Mandatory	List	Yes - UV light Yes - UV + visible light No	No	Yes	No	No
V		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	Integer	xxx		390
W		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
X		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
Y		FreeForm Produced *	FreeForm Produced Freeform technology	Mandatory	Boolean	Yes or No	No	No	Yes	No
Z		Absorption *	Absorption (in %) Global UV absorption (%)	Mandatory	Integer	0 min 100 max		85
AA		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
AB	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
AC		Supplier Discontinuation date	Supplier Discontinuation date End Date of the packaged product	Mandatory if the the supplier SKU Status = Phase Out	Date	YYYY-MM-DD
AD		Supplier SKU Status	Supplier SKU Status Product status	Mandatory	List (see blelow)	9 max	Active	Active	New	Active
AE		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		Text
AF		Supplier Recommanded Retail Price (optional)	Supplier Recommanded Retail Price Recommended selling price for the product	Mandatory	Decimal	xxx.xx	10	15	53
AG	Logistic information	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.

iZySolutions - Documentation

📘COMMERCIAL FILE - Integrated lens

HOW TO FILL GRANDVISION COMMERCIAL FILE?

List of possibilities for:

List of possible errors you can have on your import: