Page Comparison

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 (VAC)
Order

(France only)

EDI Code

(France only)

Change the distributor product code of the packaged productintegrated lens

MandatoryOptional

Text

10 max

DSK16CHC

DSK16TBC

IZ1501SAR

ST0238HMC

E

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

FG

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

GH

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

HI

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

IJ

Coating Description

Mandatory if a coating code is set

Hard Coat

HMC

JK

Coating Color

Leave empty if no coating color.

List

Brown

LK

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

LM

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

MN

Commercial data

Label *

Brand Name
Brand

Mandatory

Text

DESK

DESK

IZY FF

SV

NO

Sub Label

Collection Name
Collection

Mandatory

Text

SHORT

OP

Material *

Material
Material (Commercial name)

Mandatory

Text

MR_8

MR_8

CR39

CR39

PQ

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

QR

Lens Design *

Lens Design

Mandatory

List

Standard

Standard

Aspheric

Spheric

RS

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

ST

Technology

Technology
Mandatory if lens is Freeform

Mandatory

By default N/A

List

No

No

Individual

No

TU

Technical specifications

Blue Cut Material *

Blue Cut Material
Blue light cut in the mass

Mandatory

Yes/No

Yes or No

No

No

Yes

No

UV

Photochromic *

Indicate if the lens is photochromatic

Mandatory

List

Yes - UV light

Yes - UV + visible light

No

No

Yes

No

No

VW

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

WX

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

XY

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

YZ

FreeForm Produced *

FreeForm Produced
Freeform technology

Mandatory

Boolean

Yes or No

No

No

Yes

No

ZAA

Absorption *

Absorption (in %)
Global UV absorption (%)

Mandatory

Integer

0 min

100 max

85

AAAB

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

ABAC

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

ACAD

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

ADAE

Supplier SKU Status

Supplier SKU Status
Product status

Mandatory

List (see blelow)

9 max

Active

Active

New

Active

AEAF

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

AF

Supplier Recommanded Retail Price (optional)

Supplier Recommanded Retail Price
Recommended selling price for the product

Mandatory

Decimal

xxx.xx

10

15

53

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