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.
Info |
---|
As a reminder: a packaged lens is a lens that includes an option which is generally a coating. |
Commercial file template:
View file | ||
---|---|---|
|
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