|
Tabs | Possible fields and values for enumerations | Example single price | Example price according to the cylinder (same operation for spheres). Each line should therefore appear in the Excel file | Mandatory / Optional / Conditional | Further information | ||
Prices for spherical powers only | Price for a lens with powers from 0.25 to 2 inclusive | Price for a lens with powers from 2.25 to more | |||||
Lens | Manufacturer code | IZY | IZY | IZY | IZY | Mandatory | |
Distributor code | IZY | IZY | IZY | IZY | Mandatory | ||
Product code | A001XX | A001XX | A001XX | A001XX | Mandatory | ||
Groupment code | |||||||
Definition of the price grid | Range type | 2 | 2 | 2 | 2 | Mandatory | |
Range name | Rx | Rx | Rx | Rx | Mandatory | ||
Action | 1 | 1 | 1 | 1 | Mandatory | ||
Validity start date | Optional | ||||||
Validity end date | Optional | ||||||
Special tarif code | Optional | ||||||
Name marketing action | Optional | ||||||
% Reduction for balancing lens | Optional | ||||||
Diameter | Optional | ||||||
Sphere start | Optional | ||||||
Sphere end | Optional | ||||||
Cylinder start | 0 | 0.25 | 2.25 | Optional | |||
Cylinder end | 0 | 2 | Optional | ||||
Purchase | 12 | 12 | 17 | 24 | Mandatory | ||
Selling | 50 | Optional | Not recommended to be included in catalogues for the French market | ||||
Prix 3 (optional) Empty field by default | Conditional | To be filled in only if the price type is available on your product base | |||||
Prix 4 (optional) Empty field by default | |||||||
Prix 5 (optional) Empty field by default | |||||||
Prix 6 (optional) Empty field by default | |||||||
Modification date | Optional | If empty then the current date will be shown |