Columns

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

Solid

Polycarbonate

Aphake

40

Traditional

Yes

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