iZySolutions - Documentation

FAQ - Excel format for lenses - Associations tab

 

Tabs

Possible fields and values for enumerations

Example of a photochromic lens with mandatory surface treatment when ordered.

Incompatible anti-reflective coatings are required, but it is not possible to order a bare lens.

Mandatory / Optional / Conditional

Further information

Mandatory option

Hidden option, price must be 0 as included in the price of the lens

Mandatory option

Prism required only if the prism values entered in the order are within the limits indicated below (0.5 to 4)

Lens

Manufacturer code

IZY

IZY

IZY

IZY

Mandatory

 

Distributor code

IZY

IZY

IZY

IZY

Mandatory

 

Lens code

A001XX

A001XX

A001XX

A001XX

Mandatory

 

Groupment code

 

 

 

 

Optionnel

 

Option

Manufacturer code

IZY

IZY

IZY

IZY

Mandatory

 

Distributor code

IZY

IZY

IZY

IZY

Mandatory

 

option code

MBL

PHO

ARB

PRI

Mandatory

 

Groupment code

 

 

 

 

Optionnel

 

General

Hidden option
0 : No
1 : Yes

0

1

0

0

Mandatory

 

Included option
0 : No
1 : Yes

0

1

0

0

Mandatory

 

Mandatory option
0 : No
1 : Yes

1

1

1

1

Mandatory

 

Purchase

9

0

15

10

Mandatory

 

Origin Purchase

 

 

 

 

 

Do not complete. Managed on export only

Selling

25

0

38

25

Optional

Not recommended for the French market

Origin Selling

 

 

 

 

 

Do not complete. Managed on export only

 Price 3

 

 

 

 

Optional

 

 Origin Price 3

 

 

 

 

 

Do not complete. Managed on export only

 Price 4

 

 

 

 

Optional

 

 Origin Price 4

 

 

 

 

 

Do not complete. Managed on export only

 Price 5

 

 

 

 

Optional

 

 Origin Price 5

 

 

 

 

 

Do not complete. Managed on export only

 Price 6

 

 

 

 

Optional

 

 Origin Price 6

 

 

 

 

 

Do not complete. Managed on export only

Technical

Range type
1 : Stock
2 : RX
3 : Outside manufacturing range

 

 

 

 

Optional

If empty, inherits the lens data.

We recommend leaving this information blank if the lens contains only one manufacturing range.

Range name

 

 

 

 

Optional

UVA

 

 

 

 

Optional

 

UVB

 

 

 

 

Optional

 

Electronic ordering
0 : Prohibited
1 : Mandatory
2 : Optional

2

2

2

2

Mandatory

 

Diameter min.

 

 

 

 

Optional

 

Diameter max.

 

 

 

 

Optional

 

Sphere min.

 

 

 

 

Optional

 

Sphere max.

 

 

 

 

Optional

 

Cylinder min.

 

 

 

 

Optional

 

Cylinder max.

 

 

 

 

Optional

 

Prism min.

 

 

 

0,5

Conditional

Only to be filled in for a supplement of the Prismatic Effect type

Prism max.

 

 

 

4

Conditional

Marketing

Action
1 : Modified
2 : delete

1

1

1

1

Mandatory

 

Validity start date

 

 

 

 

Optional

 

Validity end date

 

 

 

 

Optional

 

Refund class

A : Class A
B : Class B
Z : No class
1 : Class 1
2 : Class 2
NO : No class

 

 

 

 

Optional

If empty, inherits the lens and/or option data.

We recommend leaving this information blank as not all optician software can interpret this type of information as it is not indicated on the lens or option.

Special tariff code

 

 

 

 

Optional

 

Name marketing action

 

 

 

 

Optional

 

Name marketing action

 

 

 

 

Optional

 

Additional delay

 

 

 

 

Optional

Format 0000

Date of creation

 

 

 

 

Optional

If empty then the current date will be shown

Modification date

 

 

 

 

Optional

If empty then the current date will be shown

© 2018 iZySolutions