Column names in csv file
|
Explanation
|
Data Types
|
| Artikelcode Info |
Item code Info (never changes) |
varchar(30) |
| Artikelcode Leverancier |
Item code currect supplier |
varchar(30) |
| EAN |
Barcode |
varchar(13) |
| Productname |
Product name |
varchar(60) |
| Merk + Productname |
Brand + product name |
varchar(60) |
| LedenPrijs |
Net purchase price excl. VAT (invoice price) |
varchar(10) |
| Adviesprijs |
Manufacturer's Suggested Retail Price (incl. 21% VAT) |
varchar(11) |
| SPA |
- |
varchar(3) |
| Besteleenheid |
Order unit |
varchar(13) |
| Merk |
Brand |
varchar(60) |
| Kleur |
Colour |
varchar(60) |
| Distributiecontract |
Selective distribution contract |
varchar(60) |
| Groep |
Group |
varchar(60) |
| Subgroep |
Sub groep |
varchar(60) |
| BTW |
VAT (21 / 6) |
varchar(3) |
| SPA Premie |
Rebate |
varchar(10) |
| Release Date |
Release date (yyyymmdd) |
varchar(255) |
| Niet verzendbaar |
Too big for dropshipment (0/1 = no/yes) |
varchar(16) |
| Info Keus |
- |
varchar(9) |
| Link afbeelding 1 |
Primary image |
varchar(255) |
| Link afbeelding 2 |
Image 2 |
varchar(255) |
| Link afbeelding 3 |
Image 3 |
varchar(255) |
| Link afbeelding 4 |
Image 4 |
varchar(255) |
| Link afbeelding 5 |
Image 5 |
varchar(255) |
| Link Video |
Video |
varchar(255) |
| Website tekst |
Website text |
varchar(255) |
| Changed |
Changed (0/1/2 = no/yes/new) |
varchar(7) |
