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.4

(blue star) 1. Lenses

Template file:

View file
nameExcel_Lenses.xlsx

...

  • No changes for this version

(blue star) 2. Contact lenses

Template file:

View file
nameExcel_Contact_lenses.xlsx

Changes:

  • Contact lenses

    • T: 8 (Biannual) is now an accepted value

    • AQ: Adding the column “Manufacturing” as optional

(blue star) 3. Frames

Template file:

View file
nameExcel_Frames.xlsx

...

  • 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: Passing “Nominal overall length of side” from mandatory to now conditional

      • It is now only must be empty for clips

      • It can be empty for masks

      • It is 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

...

  • No changes for this version

(blue star) 5. Audioprostheses

Template file:

View file
nameExcel_AudioProsthesis.xlsx

...

  • No changes for this version

(blue star) Version 3.2

(blue star) 1. Lenses

Template file:

View file
nameExcel_Lenses.xlsx

...

  • OPC

    • Adding the column Product Name after GTIN

(blue star) 2. Contact lenses

Template file:

View file
nameExcel_Contact_lenses.xlsx

...

  • No changes for this version

(blue star) 3. Frames

Template file:

View file
nameExcel_Frames.xlsx

...

  • No changes for this version

(blue star) 4. Accessories

Template file:

View file
nameExcel_Accessories.xlsx

...

  • No changes for this version

(blue star) 5. Audioprostheses

Template file:

View file
nameExcel_AudioProsthesis.xlsx

...

  • 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

Changes:

(blue star) 2. Contact lenses

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:

(blue star) 5. Audioprostheses

Template file:

View file
nameAudio_Excel_20240305084552.xlsx

...