iZySolutions - Documentation

📘COMMERCIAL FILE - OPC

The commercial file is a complementary file requested by GrandVision in order to complete the product information that is not present in the SF6 format.

The aim is to provide a maximum of commercial information on packaged products.

As a reminder: a packaged lens is a lens that includes an option which is generally a coating.

Commercial file template:

HOW TO FILL GRANDVISION COMMERCIAL FILE?

Columns

Section

Data

Data description

Mandatory/Conditional/Optional

Type

Format/Length

Examples

A

Product identification

EAN / OPC *

 

Mandatory

Text

 

02321546982154

 

B

 

Supplier SKU Product Description *

Product Name
Name of the packaged product (Baselens + Coating)
40 characters

Mandatory

Text

 

My iZyStock 1.5 Ar

 

C

 

PbP code *

 

Mandatory

Text

 

IZY100AR

 

D

 

Base Lens Name *

Base Lens Name
Base Lens category
Read only : do not modify this column

Mandatory

Text

 

My iZyStock 1.5

 

E

Technical specifications

Diameter SKU *

##

Mandatory

Integer

 

65

 

F

 

Sphere SKU *

##.##

Mandatory

Decimal

 

-0.25

 

G

 

Cylinder SKU *

##.##

optional

Decimal

 

+1.00

 

H

 

Prism SKU *

##.##

Optional

Decimal

 

 

 

I

 

Addition SKU *

##.##

Optional

Decimal

 

 

 

J

 

Corridor Length SKU *

##.##

Optional

Decimal

 

 

 

K

 

Segment Shape *
for bi/trifocals

 

Optional

Decimal

 

 

 

L

 

Segment Size *
for bi/trifocals

##.#

Optional

Decimal

 

 

 

M

 

Base Curve SKU *

##.##

Optional

Decimal

 

 

 

N

Pricing information

Supplier Introduction Date *

yyyy-mm-dd

Mandatory

Date

 

2020-02-11

 

O

 

Supplier Discontinue date

yyyy-mm-dd

Optional

Date

 

2023-04-04

 

P

 

Supplier SKU Status

Supplier SKU Status
Product status

Optional

List

 

Carry Over

 

Q

 

Market restriction
Country-Banner Restriction

If empty : the product is available everywhere
If one or several country-banner are selected (multiselection possible) : the product is only available in the selected country-banners

Optional

 

 

 

 

R

 

Supplier Recommended Retail Price (optional)
(Euro)

 

Optional

Integer

xxx

150

 

S

Pricing : to be shared with GV procurement
(Supplier will delete this columns before sending the file back to iWi)

 

not supported by iWi

 

 

Net Price

 

 

 

 

 

 

T

Transport/handling fee

 

 

 

 

 

 

U

Invoice Price

 

 

 

 

 

 

V

GAN

 

 

 

 

 

 

List of possible errors you can have on your import:

  • [Warning]: The sheet OPC is missing

    • check your excel file and verify that the OPC sheet is present

© 2018 iZySolutions