Note: this update process is only available for VendorLink Support.
When you use the import process 'Update Vendors', you need to upload a file containing supplier data. For this, you use the template that you can download in step 2 of the import process.
Below all columns from the import template are explained. If the import file does not meet these requirements, the import will fail.
Suppliers provided in the template (based on SupplierPortalExternalId) will be updated with all new values supplied in the columns to the right in the template. Empty columns will not be updated.
| Column | Explanation | Requirements | Mandatory |
| SupplierPortalExternalId | The external reference of the supplier. The reference must exist for a supplier. The reference is shown in the 'Ref.' field in the supplier details. | Maximum 50 alphanumeric characters. | ✅ |
| SupplierPortalName | The name of the supplier. | Maximum 100 alphanumeric characters. | ✅ |
| SupplierPortalMainAddress | The street name of the supplier. | Maximum 255 alphanumeric characters. | ❌ |
| SupplierPortalMainAddressNum | The house number of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierPortalMainAddressNumAdd | The house number addition of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierPortalMainZipcode | The postcode of the supplier. | Maximum 15 alphanumeric characters. | ❌ |
| SupplierPortalMainTown | The town/city of the supplier. | Maximum 255 alphanumeric characters. | ❌ |
| SupplierPortalMainCountry | The country of the supplier. | Maximum 100 alphanumeric characters. | ❌ |
| SupplierPortalVatCode | The VAT code of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierPortalKvkNumber | The Chamber of Commerce (KVK) number of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierPortalDunsNumber | The DUNS number of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierTel | The telephone number of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierFax | The fax number of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierOrderEmail | The order email address of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierGeneralEmail | The general contact email address of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierBankAccountType | The type of bank account of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierBankAccount | The bank account number of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierBankSwiftCode | The Swift code of the supplier. | Maximum 50 alphanumeric characters. | ❌ |
| SupplierPortalRemarks | Remarks for this supplier. | Maximum 1000 alphanumeric characters. | ❌ |
| SupplierRatingNorm | The Vendor Rating standard that this supplier must meet. | A numeric value without decimals. | ❌ |
| SupplierPurchaseRisc | The risk level of this supplier. | A numeric value without decimals. | ❌ |
| SupplierPortalWebsiteUrl | A link to the supplier's website. | Maximum 100 alphanumeric characters. | ❌ |
| SupplierTypeName | The exact name of the supplier type (as found in: Admin > Vendor settings > Tables > Supplier types) | Maximum 100 alphanumeric characters. | ❌ |
| SupplierPakketCode |
The category ID of the category to which the supplier should be linked. You can find this in Admin > Tables > Categories. Note: already assigned categories will not be unlinked by this, only additions will be made. |
A numeric value without decimals. The ID must be from an existing category in Admin > Tables > Categories. | ❌ |