iZySolutions - Documentation
FAQ - Excel format for lenses - Lenses tab
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 | 1 | Mandatory |
| ||
Type de verre pour remboursement | 1 | Mandatory for the French market |
| ||
Geometry 1 : Aspherical 2 : Toro-elliptical | 0 | Mandatory |
| ||
Material 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 | 1 |
| If empty then the value will be 0. | |
Engraved reference circle 0 : no | 1 |
| If empty then the value will be 0. | ||
Signed lens | 1 |
| If empty then the value will be 0. | ||
Presence of titanium | 0 |
| If empty then the value will be 0. | ||
Lenticular lens | 0 |
| If empty then the value will be 0. | ||
Selective distribution | 0 |
| If empty then the value will be 0. | ||
Aphakik | 0 |
| If empty then the value will be 0. | ||
Engraved addition | 0 |
| If empty then the value will be 0. | ||
Restriction CEN 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 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 | 1 | Mandatory for the European market |
| ||
Photochromic 1 : Yes | 1 |
| If empty then the value will be 0. | ||
Tinted 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
| ||
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 1 : Straight 2 : Pantoscopic 3 : Round 4 : Executive | Bifocal | Trifocal | Conditional |
| |
Visible segment edge 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 | Optional |
| ||
Command lens only | Optional |
| |||
Percentage of total price for lens scales | Optional |
| |||
Addition/deletion proximity lens 0 : No specification required | Optional |
| |||
Increases the contrast 0 : no | Optional | If empty then the value will be 0. | |||
Marketing
| Action 2 : Deleted | Commercially active 1 : modified 2 : deleted = closed |
|
| |
Start of validity |
| Optional |
| ||
End of validity |
| Optional |
| ||
Refund class 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 |
© 2018 iZySolutions