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

iZySolutions - Documentation

COMMERCIAL FILE

How to fill the commercial file for GrandVision ?

List of possibilities for