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 | 1 | 0 | 0 | Mandatory |
|
Included option | 0 | 1 | 0 | 0 | Mandatory |
| |
Mandatory option | 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 |
|
|
|
| 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 | 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 | 1 | 1 | 1 | Mandatory |
|
Validity start date |
|
|
|
| Optional |
| |
Validity end date |
|
|
|
| Optional |
| |
Refund class A : Class A |
|
|
|
| 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