Versions Compared

Version Old Version 5 New Version 6
Changes made by

Fred

Fred

Saved on

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.

...

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

Integer

xxx

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

...