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

    • 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

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

(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:

  • No changes for this version

(blue star) Version 3.2

(blue star) 1. Lenses

Template file:

View file
nameExcel_Lenses.xlsx

Changes:

  • OPC

    Adding the column Product Name after GTIN

(blue star) 2. 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

...

...

Audio

...

  • 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

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

...

_Excel_Template.xlsx

Changes:

  • No changes for this version