Product type	Options

Product type	Options
Export
Import
Extension	Excel (.xlsx)
Structure
Goal	This file format makes it possible to update specific prices via an Excel file.

What is a specific price?

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

Result in the lens