Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Product type

Options

Export

(tick)

Import

(tick)

Extension

Excel (.xlsx)

Structure

Goal

This file format makes it possible to update specific prices via an Excel file.

What is a specific price?

IWICATALOG-EN - Specific data interface

How do I use the interface?

The data to be entered is shown in the table below:

Possible fields and values for enumerations

Mandatory / Optional

Format / Length

Examples

Lens data

Manufacturer code

Mandatory

Existing product code in iWi

IZY

IZY

Distributor code

Mandatory

Existing product code in iWi

IZY

IZY

Product code

Mandatory

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

VO

IZ15

Name

Mandatory

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

iZy 15 SV

iZy 15 SV

Option data

Manufacturer code

Mandatory

Existing product code in iWi

IZY

IZY

Distributor code

Mandatory

Existing product code in iWi

IZY

IZY

Product code

Mandatory

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

SAR

SAR

Name

Mandatory

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

Super AR

Super AR

Price management

Perimeter
Public and groupment (expected value empty)
Public only (expected value Public)
Groupment (expected value Groupment code)

Optional

Groupment code

Public

TEST

Purchase

Optional

decimal

18

22

Selling

Optional

decimal

Other price

Optional

decimal

Other price

Optional

decimal

Other price

Optional

decimal

Other price

Optional

decimal

In iWiCatalog, the result of the examples shown in the table will be :

In the specific prices

Image Added

Result in the lens

Image AddedImage Added