Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

View file
nameGV CommercialFile Final Version.xlsx

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

100067100067

100068

100088

200124

B

SF6 Lens Code *

SF6 Lens Code
Generic lens in the SF6 File

Mandatory

String

6 max

DSK16C

DSK16BDSK16T

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

DSK16CHCDSK16CHC

DSK16TBC

IZ1501SAR

ST0238HMC

E

Base Lens Name *

Base Lens Name
Base Lens category

Mandatory

Enumerated

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, 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 only for Stock lenseselse empty

If the lens is not a stock the code will be ignore

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

Coating Description

Hard Coat

HMC

J

Coating Color

Brown

K

Supplier Lens Color Description *

Lens Color Description
Tint of the lens

Mandatory

String

40

Clear

Photochromic Brown

Clear

Clear

JL

Lens Appearance *

Lens Appearance
Type of tint (Gradient, …)

Mandatory

Enumerated

16

Clear/None

SolidClear/None

Clear/None

Clear/None

KM

Commercial data

 

 

 

 

 

 

Label *

Brand Name
Brand

Mandatory

String

DESK

DESK

IZY FF

SV

LN

Sub Label

Collection Name
Collection

Mandatory

String

SHORT

MO

Material *

Material
Material (Commercial name)

Mandatory

String

MR_8

MR_8

CR39

CR39

NP

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

OQ

Lens Design *

Lens Design

Mandatory

Enumerated

Standard

Standard

OptimisedAspheric

Spheric

PR

Design Variant *for freeform lenses

Design Variant
Style of use
Mandatory if lens is Freeform

Conditional, empty if FreeForm Produced is YesNo

String

NoneEnumerated

None

Flex

NoneS

Q

Technology *for freeform lenses

Technology
Mandatory if lens is Freeform

Mandatory

Boolean

Yes or Conditional, empty if FreeForm Produced is No

Enumerated

No

No

No

Yes Individual

No

RT

Technical specifications

 

 

 

 

Blue Cut Material *

Blue Cut Material
Blue light cut in the mass

Mandatory

Boolean

Yes or No

No

No

Yes

No

SU

Photochromic *

Indicate if the lens is photochromatic

Optional

Enumerated

Yes - UV light

Yes - UV + visible light

No

NoNo

Yes

No

No

TV

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

U390

W

Polarized *

Indicate if the lens is polarized

Read only, any modification on this column will not change anything

No

No

No

No

VX

UV Protection *

Indicate if the lens is UB blocking

Read only, any modification on this column will not change anything

No

No

No

No

WY

FreeForm Produced *

FreeForm Produced
Freeform technology

Mandatory

Boolean

Yes or No

No

NoNo

Yes

No

XZ

Absorption *

Absorption (in %)
Global UV absorption (%)

Mandatory

Integer

0 min

100 max

85

YAA

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

ZAB

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

AAAC

Supplier Discontinuation date

Supplier Discontinuation date
End Date of the packaged product

Date

YYYY-MM-DD

ABAD

Supplier SKU Status

Supplier SKU Status
Product status

Mandatory

Enumerated

9 max

Active

Active

New

Active

ACAE

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

ADAF

Supplier Recommanded Retail Price (optional)

Supplier Recommanded Retail Price
Recommended selling price for the product

Mandatory

Decimal

xxx.xx

10

15

53

AEAG

Logistic information

 

 

 

 

Length *

Package Length (in mm)

Mandatory

Integer

xxx

80

80

80

AF80

AH

Width *

Package Width (in mm)

Mandatory

Integer

xxx

80

80

80

80

AGAI

Height *

Package Height (in mm)

Mandatory

Integer

xxx

80

80

80

AH80

AJ

Gross Weight *

Package Gross Weight (in g)

Mandatory Fill y default 19

Integer

xxx

19

19

19

19

AIAK

Net Weight *

Package Net Weight (in g)

Mandatory Fill y default 18

Integer

xxx

18

18

18

19

List of possibilities for

Lens Appearance Label

Material

Lens Design

Lifestyle (Design Variant )*for freeform lenses

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

PolycarbonateSilica / Mineral

Individual

Driving

Lifestyle

Filter<15% absorptionSilica

/ MineralMR_6

Standard

None

Tri-gradient/3-color graduated tint

MR_68

Optimised

MR_810

Lifestyle

MR_10174

Enhanced Reader

MR_174

Office Vocational

Relax Vision

Trifocal

Lenticular

Bifocal

Myopia Control

Aphake

List of possible errors you can have

  • [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

    • If column FreeForm Produced is filled with Yes this data must contains value. See enumarated values Technology

  • [Warning]: Design variant for FreeForm lenses (Integrated Lens): Mandatory data on line YYY

    • If column FreeForm Produced is filled with Yes this data must contains value. 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