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 | Global Master Code | Mandatory | Text | 6 max | 100067 | ||
B | Local Article Code | Mandatory | Text | 6 max | 100068 | ||
C | Local Article Name | Mandatory | Text | max 40 | DESK IZY 1.6 HARD COAT | ||
D | Banner Code | OpCos:Country:Banner | Mandatory | Text | OpCos:Country:Banner | FR:FR:FR |
...
List of possible errors you can have on your import:
[Warning]: The sheet French EDI Codes is missing
check your excel file and verify that the French EDI Codes sheet is present
[Warning]: The integrated lens with global master code XXXXXX could not be found in the integrated lens tab
Check your integrated lens tab and verify that the global master code indicated is present
[Error]: The element with the global master code XXXXXX and the banner XX on line XX is duplicate
Check that globlal master code is only present once with this banner