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.
...
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