• If the price is a single price then only one line (per lens) should appear, the following fields should remain blank:

    • Diameter

    • Sphere start

    • Sphere end

    • Cylinder start

    • Cylinder end

  • If there are different prices for a lens by diameter, then a row must be entered for each diameter.

  • If the pricing policy imposes different prices according to the sphere and/or the diameter, the following fields must be filled in:

    • Sphere start

    • End sphere (if the start sphere is filled in, it can remain empty if it corresponds to the last possible price for the spheres)

    • Start cylinder

    • End cylinder (if the start cylinder is filled in, it can remain empty if it corresponds to the last possible price for cylinders)

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
1 : Stock
2 : RX
3 : Outside manufacturing range

2

2

2

2

Mandatory

Range name

Rx

Rx

Rx

Rx

Mandatory

Action
1 : Edit
2 : Delete

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