To import a brands workbook into shooIQ we need following attributes in a CSV or Excel file:
.
| 1 | Brand | Group_ID | Article_ID | Variant_ID | Variant_Name | Name | Media | Valid_Since | Valid_Until | Gender | Sizing_System | Width | Width_System | Last_Family | Size | GTIN |
| 2 | ||||||||||||||||
| .... | ||||||||||||||||
| Explanation | Brand Name | Group ID or FEDAS Code | The article number given by the brand | e.g. Color ID | e.g. Color Name | URL or File Name | yyyy-MM-dd | yyyy-MM-dd | unisex, male, female, boy, girl | US, UK, EU, MP, JP | US, smw | ID to group the fit/last of an article. Must not be the real last name. Could be the name of a main article. | GTIN/EAN - official ID given by the brand | |||
| Data Structure | Brand | Commodity Group | Article | SKU | ||||||||||||
.
The order of the columns are not important, we import by the exact labels of the header.
.
| Mandatory Field | |
| Mandatory for shoescan or last based recommendation | |
| Optional |
.
Example Excel File