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 | Mandatory | Text |
| My iZyStock 1.5 Ar |
|
C |
| PbP code * |
| Mandatory | Text |
| IZY100AR |
|
D |
| Base Lens Name * | Base Lens Name | 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 * |
| Optional | Decimal |
|
|
|
L |
| Segment Size * | ##.# | 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 | Optional | List |
| Carry Over |
|
Q |
| Market restriction | If empty : the product is available everywhere | Optional |
|
|
|
|
R |
| Supplier Recommended Retail Price (optional) |
| Optional | Integer | xxx | 150 |
|
S | Pricing : to be shared with GV procurement
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