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.

...

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

DSK16C HC

DSK16C HC

IZ1501 SARDSK16CHC

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

Coating Description *

Integrated Coating Description
Name of the coating treatment
Mandatory if Coating Code is filled

Conditional, empty if Coating Code is empty

String

40 max

HARD COAT

HARD COAT

SUPER AR

Coating Color *

Integrated Coating Color
Color of the integrated treatment

Mandatory

Enumerated

3

999

300

999

HMC

I

Supplier Lens Color Description *

Lens Color Description
Tint of the lens

Mandatory

String

40

N/AClear

BrownN/A

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

N/A

N/ANone

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

Integer

xxx

N/A

N/A

N/A

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 (%)

Mandatory

If no information put N/A

Integer

40 0 min

100 max

N/A

85

N/AY

Minimum to Top

Minimum to Top (in mm)
The minimum distance (mm) needed from pupil to the top of the frame/lens

Mandatory

If no information put N/A

Integer

xx

N/A

N/A

15

15

Z

Pricing information

 

 

 

Supplier Introduction Date

Supplier Introduction Date
Introduction Date of the packaged product

Mandatory

DateYYYYMMDD

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 productMandatory

Date

YYYYMMDD

2099YYYY-12MM-31

2099-12-31

2099-12-31DD

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

...

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