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

StringText

6 max

100067100067

100068

100088

200124

B

SF6 Lens Code *

SF6 Lens Code
Generic lens in the SF6 File

Mandatory

StringText

6 max

DSK16C

DSK16BDSK16T

IZ1501

ST0238

C

Article Description *

Product Name
Name of the packaged product (Baselens + Coating)

Mandatory

StringText

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

StringText

10 max

DSK16C HC

DSK16C HC

IZ1501 SAR

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

EnumeratedList

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

StringText

6 max

HC

HC

SAR

Coating Description *

Integrated HMC

J

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 ARa coating code is set

Hard Coat

HMC

K

Coating Color *

Integrated Coating Color
Color of the integrated treatment

Mandatory

Enumerated

3

999

300

999

Leave empty if no coating color.

List

Brown

L

Lens information

Supplier Lens Color Description *

Lens Color Description
Tint of the lens

MandatoryString

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

Text

40

N/AClear

Photochromic BrownN/A

Clear

Clear

M

Lens Appearance *

Lens Appearance
Type of tint (Gradient, …)

Mandatory

Enumerated

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

List

16

Clear/None

Clear/None

SolidClear/None

Clear/None

N

Commercial data

Label *

Brand Name
Brand

Mandatory

StringText

DESK

DESK

IZY FF

SV

O

Sub Label

Collection Name
Collection

Mandatory

StringText

SHORT

P

Material *

Material
Material (Commercial name)

Mandatory

StringText

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

StringFR

FR

FR

FR

R

Lens Design *Lens Design

Lens Design

Mandatory

EnumeratedList

Standard

Standard

OptimisedAspheric

Spheric

S

Design Variant * for freeform lenses

Design Variant
Style of use
Mandatory if lens is Freeform

Conditional, empty if FreeForm Produced is Yes

String

Mandatory

By default N/AN/A

List

None

None

Flex

None

T

Technology *for freeform lenses

Technology
Mandatory if lens is Freeform

Mandatory

Boolean

Yes or

By default N/A

List

No

No

Individual

No

Yes U

Technical specifications

Blue Cut Material *

Blue Cut Material
Blue light cut in the mass

MandatoryBoolean

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

N/A

N/A

N/A

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

If no information put N/A

Integer

40 0 min

100 max

N/A

85

N/AAB

Minimum to Top

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

If no information put N/A

Integer

xx

N/A

N/A

15

15

AC

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

AD

Supplier Discontinuation date

Supplier Discontinuation date
End Date of the packaged product

Mandatory if the the supplier SKU Status = Phase Out

Date

YYYYMMDD

2099YYYY-12MM-31

2099-12-31

2099-12-31DD

AE

Supplier SKU Status

Supplier SKU Status
Product status

MandatoryEnumerated

List (see blelow)

9 max

Active

Active

New

Supplier Recommanded Retail Price

Supplier Recommanded Retail Price
Recommended selling price for the product

Mandatory

Decimal

xxx.xx

10

15

53

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

Lens Appearance Label

Material

Lens Design

Lifestyle (Design Variant )* for freeform lenses

Technology

YesNo

Base Lens

Brand

Collection

Supplier SKU Status

Solid

Polycarbonate

SphericAphake

Far40

Traditional

Yes

Depend your product list

New

Gradient

CR39

Aspheric

FlexA

Optimised

No

Active

Bi-Gradient

NXT / Trivex

Double AsphericBifocal

NearAct

Individual

Phase Out

Clear/None

Polycarbonate

Individual

DrivingSilica / Mineral

Double Aspheric

All

Lifestyle

Filter<15% absorption

Silica / Mineral

StandardMR_6

Enhanced Reader

B

Tri-gradient/3-color graduated tint

MR_68

Optimised

MR_8

LifestyleIndividual

BC

MR_10

Individual Occupational

Enhanced ReaderBook

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

Lenticular

Bifocal

Myopia Control

Aphake

P1.1

PC

Proxi

Room

S

V

XS