This article explains how to import supplier information and add it to your products.


To learn about supplier info in general, click here.



What you need:

  • An Excel file containing the supplier's info
  • A product to add the supplier's info to
  • Access to the supplier's tab

How to set up your Excel file


Essentials:

To import supplier info successfully, these three columns should at least be present:

  • Article code (of supplier)
  • GLN or supplier name
  • Product identifier

Check the column header syntaxes in the table below:

Required columns
Article code (of supplier)GLN or supplier nameProduct identifier
Possible syntaxesArticle Code
Leverancier
GTIN

Artikel Code
Supplier
Article ID

Product Code
Leverancier naam
Manufacturer code + order number *

Artikelcode (van lev.)
Supplier name
Manufacturer code + type number *

ArticleCode (supplier)
GLN
Manufacturer name + order number *


Leverancier GLN
Manufacturer name + type number *


Supplier GLN

* Include these identifiers as separate columns


Logistics:

Once we identified the product, we can move on to add logistical information to the product. Right now, these fields can be added:

 

ValueSyntax ENSyntax NL
Minimum delivery time:Delivery TimeLevertijd
Minimum purchase quantity:Minimum orderMinimale afname 
VAT CodeVAT CodeBTW Code
Gross priceGross priceBruto prijs
Net priceNet priceNettoprijs
Status:StatusStatus
VAT percentage:VATBTW
Depth:DepthDiepte
Height:HeightHoogte
Width:WidthBreedte


These are the available fields for the import file. You can also find these fields by clicking the information popup in the import menu. For reference, we also added an example file as an attachment.