Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Below you will find the complete description of the Excel catalog format of the Lenses tab. If field lengths are not specified you can find them in our documentation. The same goes for the exact description of the fields. Here the goal is to offer help on how to enter the different information.

Tab

Possible fields and values for enumerations

Example

Mandatory / Optional / Conditional

Additional information

General

Manufacturer code

IZY

Mandatory

Name manufacturer

iZySolutions

Mandatory

Distributor code

IZY

Mandatory

Distributor name

iZySolutions

Mandatory

Name

1,53 Photo Grey

Mandatory

Must take into account your export format (60 max.)

Short name

Optional

Manufacturer Product Code

A001XX

Mandatory

Code of the lens

Distributor product code

Optional

Order code

A001XX

Mandatory

Order code of the lens

Internal code

Optional

Lens type
0 : Afocal
1 :

Unifocal

Single vision
2 : Bifocal
3 : Trifocal
4 : Progressive
5 :

Mid distance

Intermediate

1

Mandatory

Type

of lens for refunding

de verre pour remboursement
0 : Neutral
1 :

Unifocal

Single vision
2 : Multifocal

3

4 : Progressive

1

Mandatory for the French market

Geometry
0 : Spherical

1 : Aspherical

2 : Toro-elliptical

0

Mandatory

Material
0 : Mineral

1 : Organic

2 : Polycarbonate

3 : Trivex

3

Mandatory

Material

TVX

Optional

Real refractive index

1,530

Mandatory

Reference refractive index

1,53

Mandatory

Code Sign

Optional

Public product code

Conditional

Put the product code of the public version only if a sign is filled in.

Technical

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Marking
0 : no
1 : yes

1

If empty then the value will be 0.

Centering markEngraved reference circle

0 : no
1 : yes

1

If empty then the value will be 0.

Signed lens
0 : no
1 : yes

1

If empty then the value will be 0.

Presence of titanium
0 : no
1 : yes

0

If empty then the value will be 0.

Lenticular lens
0 : no
1 : yes

0

If empty then the value will be 0.

Selective distribution
0 : no
1 : yes

0

If empty then the value will be 0.

Aphakik
0 : no
1 : yes

0

If empty then the value will be 0.

Engraved addition
0 : no
1 : yes

0

If empty then the value will be 0.

Restriction CEN
0: No restriction

1: Not recommended for night driving

2: Not recommended for driving

3: Depends on center thickness and anti-reflective coating

4: No information provided

1

Mandatoryfor the European market

Restriction CEN alternative
0: No restriction

1: Not recommended for night driving

2: Not recommended for driving

Conditional

To be filled in if CEN Restriction is filled in with values 3 or 4.

CEN Category
0 :

Light or very lightly tinted

Confort
1 :

Lightly tinted

Low luminosity
2 :

Medium tinted

Average luminosity
3 :

Dark

High lumonisity
4 :

Very dark

Exceptionnal luminosity

1

Mandatory for the European market

Photochromic
0 : No

1 : Yes

1

If empty then the value will be 0.

Tinted
0 : No

1 : Yes

0

If empty then the value will be 0.

Aspherical diameter

Optional

Absorption infrarouge

Optional

Density

1,32

Optional

Number of abbe

35

Optional

Alpha protection

Optional

UVA absorption

Optional

UVB Absorption

Optional

Vertical distance from the minimum centering cross

Multi-focal only

Conditional

For the type of lens

  • Progressive

  • Mid-distance

  • Bifocal

  • Trifocal

Vertical distance from the maximum centering cross

Vertical distance vision

Horizontal distance vision

Min. distance for vertical near vision

Max. vertical near vision distance

Minimum distance for horizontal near vision

Max. horizontal near vision distance

Minimum mounting height

VP segment type
0 : Curved

1 : Straight

2 : Pantoscopic

3 : Round

4 : Executive

Bifocal

Trifocal

Conditional

Visible segment edge
0 : No

1 : Yes

If empty then the value will be 0.

Lower radius of the VP segment

Upper radius of the VP segment

Width of the VP segment

Height of the VP segment

Distance geometric center of the segment VP

Upper radius intermediate vision segment

Intermediate vision segment height

Display order

Specificity SF6

OptionalOrderable

Command lens only
0 : Not possible
1 : Possible
2 : With

fictitious

fictive opposite lens

9: Resume from lens

Optional

Percentage of total price for lens scales

Optional

Addition/deletion proximity lens

0 : No

information

specification required
1 : Specify

VL power and

distance + addition
2 : Specify

VP

near + power

and degression

decrease

Optional

Increases the contrast

0 : no
1 : yes

Optional

If empty then the value will be 0.

Marketing

 

 

 

 

 

 

 

 

 

Action
1 : Modified

2 : Deleted

Commercially active

1 : modified

2 : deleted = closed

Start of validity

Optional

End of validity

Optional

Refund class
A : Class A

B : Class B

Z : No class

A

Mandatory for the French market

Manufacturer's URL

Optional

Supplier URL

Optional

Other information

Optional

Essential feature

Description for the consumer. No abbreviation

Mandatoryfor the French market

Date of creation

Optional

If empty then the current date will be shown

Date of modification

Optional

If empty then the current date will be shown

...