iZySolutions - Documentation
📘COMMERCIAL FILE - Options
- Jérémy Fromenteau
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 | Option information | Option Code * | Option Code | Mandatory | text |
| 2IZ | I1Z |
B | Option Description * | Option Description | Mandatory | Text | 40 max | AR Classic | Black A | |
C | Option Color * 40 characters | Option color Select a color in the list of allowed values. For options, please select "Clear" | Mandatory | List |
| Clear | Grey | |
D | Pricing information | Supplier Introduction Date * | Supplier Introduction Date yyyy-mm-dd | Optional | Data | yyyy-mm-dd | 2023-04-03 |
|
E | Supplier Discontinuation date | Supplier Discontinuation date yyyy-mm-dd | Optional | Date | yyyy-mm-dd | 2023-04-03 |
| |
F | Supplier SKU Status | Supplier SKU Status | Optional | List |
|
|
| |
G | Supplier Recommanded Retail Price (optional) | Supplier Recommanded Retail Price Recommended selling price for the product | Optional | Integer | xxx | 150 |
| |
H | (Supplier will delete this columns before sending the file back to iWi)
not supported by iWi | Free of charge option * |
|
|
|
|
|
|
I | net Price |
|
|
|
|
|
| |
J | Transport/handling fee |
|
|
|
|
|
| |
K | Invoice price |
|
|
|
|
|
| |
L | GAN | Global Article Number |
|
|
|
|
| |
List of possible errors you can have on your import:
[Warning]:The option XXX does not exist
The option is not on the SF6/and not exists in iWi
[Warning]: The sheet Options is missing
check your excel file and verify that the Options sheet is present
[Warning]:The field Article Description at line XXX is too long and will be troncated at 40 characters
the Option Description is too long
© 2018 iZySolutions