iZySolutions - Documentation

📘COMMERCIAL FILE - Integrated lens

Owned by Fred
Last updated: Apr 04, 2023 by Jérémy Fromenteau
6 min read

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

EDI Code

(France only)

EDI Code

(France only)

Change the distributor product code of the integrated lens

Optional

Text

 

BUR16CHC

 

 

 

F

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

G

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

H

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

I

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

J

Coating Description

 

Mandatory if a coating code is set

 

 

 

Hard Coat

 

HMC

K

Coating Color

 

Leave empty if no coating color.

List

 

 

Brown

 

 

L

Lens information

Supplier Lens Color Description *

Lens Color Description
Tint of the lens

Mandatory

For a non-tinted lens → the field has to be filled with “Clear”

Text

40

Clear

Photochromic Brown

Clear

Clear

M

Lens Appearance *

Lens Appearance
Type of tint (Gradient, …)

Mandatory

For a non-tinted lens → the field has to be filled with “Clear/None”

List

16

Clear/None

Clear/None

Clear/None

Clear/None

N

Commercial data

 

 

 

 

 

 

Label *

Brand Name
Brand

Mandatory

Text

 

DESK

DESK

IZY FF

SV

O

Sub Label

Collection Name
Collection

Mandatory

Text

 

 

 

SHORT

 

P

Material *

Material
Material (Commercial name)

Mandatory

Text

 

MR_8

MR_8

CR39

CR39

Q

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

R

Lens Design *

Lens Design

Mandatory

List

 

Standard

Standard

Aspheric

Spheric

S

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

T

Technology

Technology
Mandatory if lens is Freeform

Mandatory

By default N/A

List

 

No

No

Individual

No

U

Technical specifications

 

 

 

 

Blue Cut Material *

Blue Cut Material
Blue light cut in the mass

Mandatory

Yes/No

Yes or No

No

No

Yes

No

V

Photochromic *

Indicate if the lens is photochromatic

Mandatory

List

Yes - UV light

Yes - UV + visible light

No

No

Yes

No

No

W

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

 

 

X

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

Y

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

Z

FreeForm Produced *

FreeForm Produced
Freeform technology

Mandatory

Boolean

Yes or No

No

No

Yes

No

AA

Absorption *

Absorption (in %)
Global UV absorption (%)

Mandatory

Integer

0 min

100 max

 

85

 

 

AB

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

 

AC

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

AD

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

 

 

 

 

AE

Supplier SKU Status

Supplier SKU Status
Product status

Mandatory

List (see blelow)

9 max

Active

Active

New

Active

AF

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

 

 

 

 

 

AG

Logistic information(can be average values)

 

 

 

 

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.

 

© 2018 iZySolutions