Export

Import

Extension

Excel (.xlsx)

Structure

Goal

This file format allows you to quickly create lenses using existing versions.

Possible fields and values for enumerations

Mandatory / Optional

Format / Length

Example

Product to duplicate

Manufacturer Code

Mandatory

Existing product code in iWi

IZY

Distributor Code

Mandatory

Existing product code in iWi

IZY

Product Code

Mandatory

Existing product code in iWi

TPIZY1

Product Name

Optional

No read, just for information

TEST PROGRESSIVE IZY 1.5

Product to create 

Manufacturer Code

Mandatory

String: 5 max.

IZY

Distributor Code

Mandatory

String: 5 max.

IZY

Product Code

Mandatory

String: depends on the format. (We recommend 6 characters as this is the limit for the main catalogue formats).

TPIZY2

Distributor Product Code

Optional

Ordering Code

Mandatory

String: depends on the format. (We recommend 6 characters)

TPIZY2

Internal Code

Optional

Product Name

Mandatory

Must take into account your main export format (60 max.)

TEST PROGRESSIVE IZY 1.5 Hard coat

Start validity date

Optional

DD/MM/YYYY

22/03/2023

End validity date

Optional

DD/MM/YYYY

Copy manufacturing grids

0 or empty : No
1 : Yes

1

Copy price grids

0 or empty : No
1 : Yes

0

Copy associations

0 or empty : No
1 : Yes

1

Copy groupments

0 or empty : No
1 : Yes

1

Copy specific data

0 or empty : No
1 : Yes

0