Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel3
outlinefalse
stylenone
typelist
printablefalse

(blue star) Version 3.

...

X

(blue star) 1. Lenses

Template file:

View file
nameExcel_Lenses.xlsx

Changes:

  • No changes for this version

(blue star) 2. Contact lenses

Template file:

View file
nameExcel_Contact_lenses.xlsx

Changes:

  • Contact lenses

    • AQ: Adding the column “Manufacturing” as optional

(blue star) 3. Frames

Template file:

View file
nameExcel_Frames.xlsx

Changes:

  • Frames

    • P: “Type” is given three new possibilities:

      • F - Preassembled sunglass

      • G - Optical clip

      • H - Optical mask

    • T: Passing “Nominal overall length of side” from mandatory to conditional

      • It is now only mandatory for other types than clips

    • BG: “Main material of the front” now also accepts “J” for Recycled

    • BH: “Main material of the side” now also accepts “J” for Recycled

(blue star) 4. Accessories

Template file:

View file
nameExcel_Accessories.xlsx

Changes:

  • No changes for this version

(blue star)

...

Template file:

View file
nameExcel_AudioProsthesis.xlsx

...

2

...

Template file:

View file
nameExcel_Lenses.xlsx

Changes:

  • OPC

    • Adding the column Product Name after GTIN

...

.

...

Contact lenses

Template file:

View file
nameExcel_Contact_lenses.xlsx

Changes:

  • No changes for this version

(blue star) 3. Frames

Template file:

View file
nameExcel_Frames.xlsx

Changes:

  • No changes for this version

(blue star) 4. Accessories

Template file:

View file
nameExcel_Accessories.xlsx

Changes:

  • No changes for this version

(blue star) 5. Audioprostheses

Template file:

View file
nameExcel_AudioProsthesis.xlsx

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”

(blue star) Version 3.0

(blue star) 1. Lenses

Template file : Work in progress

...

(blue star)

...

Template file : Work in progress

Changes:

(blue star) 3. Frames

Template file : Work in progress

Changes:

(blue star) 4. Accessories

Template file : Work in progress

Changes:

...

5. Audioprostheses

Template file:

View file
nameAudio_Excel_20240305084552Template.xlsx

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

  • Marketing

  • 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 from BH to BM:

  • Small image

  • Face image

  • Right image

  • Left image

  • Top image

  • Bottom image

    No changes for this version