| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Version 3.
...
X
1. Lenses
Template file:
| View file | ||
|---|---|---|
|
...
No changes for this version
2. Contact lenses
Template file:
| View file | ||
|---|---|---|
|
Changes:
Contact lenses
T: 8 (Biannual) is now an accepted value
AQ: Adding the column “Manufacturing” as optional
3. Frames
...
:
...
...
| name | Excel_Frames.xlsx |
|---|
Changes:
Frames
P: “Type” is given three new possibilities:
F - Preassembled sunglass
G - Optical clip
H - Optical mask
Q: “Frame subtype” now conditionnal
It can be empty for clips
T: “Nominal overall length of side” now conditional
It must be empty for clips
It can be empty for masks
It is mandatory for other types
BG: “Main material of the front” now also accepts “J” for Recycled
BH: “Main material of the side” now also accepts “J” for Recycled
4. Accessories
Template file:
| View file | ||
|---|---|---|
|
Changes:
No changes for this version
...
Template file:
| View file | ||
|---|---|---|
|
Changes:
Product color combinations:
Product color tab removed
Addition of Color code and name columns to the Audioprosthesis, Audio accessories and Earmolds tabs.
These tabs no longer contain the templates, but directly the products, with unique key :
manufacturer code, distributor code, model code, color code.
...
3
...
1. Lenses
Template file:
| View file | ||
|---|---|---|
|
Changes:
OPC
Adding the column Product Name after GTIN
...
.
...
Template file:
| View file | ||
|---|---|---|
|
Changes:
No changes for this version
...
Frames
Template file:
| View file | ||
|---|---|---|
|
Changes:
No changes for this version
4. Accessories
Template file:
| View file | ||
|---|---|---|
|
Changes:
No changes for this version
5. Audioprostheses
Template file:
| View file | ||
|---|---|---|
|
Changes:
For each : Earmolds / Audio accessories/ Batteries
In General header
Adding “Manufacturer Product Code” before “Product Name”
Reorganized the columns of the General part as to follow the same format as the other product types
In Marketing header
Added a default header for price columns: when these columns are not used, the header will be “Additional price (not configurated)” with a red background
Reorganized the columns of the Marketing part as to follow the same format as the other product types
Adding six new columns for images before “creation date” column:
Small image
Face image
Right image
Left image
Top image
Bottom image
For earmolds, audio accessories and audioprostheses
Removing “Custom Code”
Version 3.0
1. Lenses
Template file : Work in progress
Changes:
2. Contact lenses
Template file : Work in progress
Changes:
3. Frames
Template file : Work in progress
Changes:
...
Template file : Work in progress
Changes:
5. Audioprostheses
Template file:
| View file | ||
|---|---|---|
|
Changes:
Adding colors to the headers in order to know which columns are mandatory, optional or informative
Audioprostheses :
General :
Adding “Manufacturer Product Code” before “Product Name”
Reorganized the columns of the General part as to follow the same format as the other product types
Technical :
Reorganized the columns of the Technical part as to follow what’s on the website more closely
Added a default header for price columns: when these columns are not used, the header will be “Additional price (not configurated)” with a red background
Reorganized the columns of the Marketing part as to follow the same format as the other product types
Small image
Face image
Right image
Left image
Top image
Bottom image
Marketing
Adding six new columns for images from BH to BM:
No changes for this version