iZySolutions - Documentation
IWICATALOG-EN - Options prices
To use the interface (Options Prices), go to the option page in your catalogue and click on the "Interface" button.
A window will open, allowing you to select the interface you want to use via the "Format" drop-down list.
By selecting "Options Prices", you should obtain the page below.
You can choose to export all the products or a selection that you have checked beforehand.
Once you've finished exporting and downloaded the file, you'll have a file like this one:
Each page consists of a header showing :
the name of the price type
the data relating to the exported option
The import is based on an Excel file in the same format as the export result file contained in a zip archive (in this case, we advise you to use a file exported from your database to avoid errors).
There are several price type categories:
| Excel File | iWi after export |
|---|---|---|
Single Price |
|
|
Type of ophthalmic lens |
|
|
Geometry |
| |
Ophthalmic lens base material |
|
|
Reference refractive index |
|
|
For example, a price by refractive index and by material will be represented in the form of a table as illustrated below.
If the option for the line read is not present in your catalogue, an error will be raised.
In addition, if you import a file for a groupment, any options not belonging to this brand will be added to it.
If a groupement price is the same as the public price, the groupement code is not exported. You will need to add the groupement code when you import if you wish to change the groupement price.
© 2018 iZySolutions