iZySolutions - Documentation

IWICATALOG - Excel changelogs

Summary:

 

Version 3.4

1. Lenses

Template file:

Changes:

  • No changes for this version

2. Contact lenses

Template file:

Changes:

  • Contact lenses

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

    • AQ: Adding the column “Manufacturing” as optional

3. Frames

Template file:

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:

Changes:

  • No changes for this version

5. Audioprostheses

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

Version 3.1+

1. Lenses

Template file:

Changes:

  • No changes for this version

2. Contact lenses

Template file:

Changes:

  • No changes for this version

3. Frames

Template file:

Changes:

  • No changes for this version

4. Accessories

Template file:

Changes:

  • No changes for this version

5. Audioprostheses

Template file:

Changes:

  • Combinations:

    • The last three columns have been removed:

      • Price

      • Validity start date

      • Validity end date

Version 3.0

1. Lenses

Template file:

Changes:

  • No changes for this version

2. Contact lenses

Template file:

Changes:

  • No changes for this version

3. Frames

Template file:

Changes:

  • No changes for this version

4. Accessories

Template file:

Changes:

  • No changes for this version

5. Audioprostheses

Template 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

    • 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

Version 2.192+

1. Lenses

Template file:

Changes:

  • Added a default header for the columns CG to CZ corresponding to the additionnal SF6 data

    • When these columns are not used, the header will be “Reserved SF6 Zone” with a red background

  • 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

  • Added a column corresponding to SF6 data “Main viewing direction” in technical part

2. Contact lenses

Template file:

Changes:

  • 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

3. Frames

Template file:

Changes:

  • 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

4. Accessories

Template file:

Changes:

  • 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

​5. Audioprostheses

Template file:

Changes:

  • Addition of an option in audio exports to export all groupment products as public

Version 2.191

1. Lenses

Template file:

Changes:

  • No changes for this version

2. Contact lenses

Template file:

Changes:

  • No changes for this version

3. Frames

Template file:

Changes:

  • No changes for this version

4. Accessories

Template file:

Changes:

  • No changes for this version

5. Audioprostheses

Template file:

Changes:

  • No changes for this version

© 2018 iZySolutions