This article describes how to import article and price files by using a csv-file. Requirement for using this function is a manual integration, that means no API-integration.

First, click on Files and Imports in the side navigation. There you will find an overview of all previous imports. By clicking on an entry, you can view the imported values.

You can upload a new file by clicking on New Import. The following chapters show you how to upload a new product or price file.

Product file
Price file

Product file

First select the type you want to upload – in this case SKUs/products and the corresponding article type.

Select also for this file type the number format used in the file – European or English. The csv column separators are automatically detected and can be changed if needed.

In the next step you can select the file or insert it by drag and drop (file type csv). A preview shows you the first three lines of your file. If the preview is correct, you can continue by clicking the Upload file button.

The file will be checked regarding errors by Procurement for Suppliers. After a successful check you can confirm and apply the changes and import the articles. The chapter further notes is intended to help you in case of errors.

Now all articles of this file are imported into Procurement.

Note

You can import all articles of a product type, even if you do not want to offer them to all customers. Articles are only visible when the respective article has a price in the price agreement stored for the customer.

Price file

First select the type you want to upload – in this case prices. Now you can select the pricing agreement for which you want to upload new prices. In the next step select the number format used in the file – European or English. The csv column separators are usually detected automatically, but this can be adjusted if needed.

In the next step select the file or insert it by drag and drop. Only csv-files can be inserted. Afterwards, a preview of the first three lines of your file will be displayed automatically. If the preview is correct, you can upload the file by clicking the Upload file button.

Procurement for Suppliers checks the file regarding errors, e.g. whether there is a corresponding article for each SKU. After successful check you can confirm the changes and import the records.

Now all data is imported into Procurement.

Note

If you want to upload prices for a new customer or for a new product type, you have to create a new price agreement. Click on price agreement in the side navigation and create a new agreement. Connect the agreement in the respective customer contract. Now you can import new prices for this price agreement. More information can be found in the article Price Agreements.
We recommend to export csv files in UTF-8 format.
For new product types you have to upload articles first and then the price file in step 2.

Further notes

The following chapter describes typical error messages. Clicking on it will show you an explanation and how you can possibly fix the problem.

Price file – order quantity

Error message: Maximum order quantity cannot be lower than Minimum order quantity
Explanation: The values Minimum order quantity and Maximum order quantity cannot have the same value. Example: A price is valid for the quantity 1 pcs. A different price applies to a quantity of 2 or more. In this case, enter 1 in the Minimum order quantity field. You can leave the cell for Maximum order quantity empty.

Article file – attributes

Error message: Name taken from another article with different attributes
Explanation: It is important that all attributes on article-level have the identical values. Attributes on article-level describe elementary differences of the product. Perhaps an adjustment of the product name can describe the product better. Regarding attributes you find more information in our docs.

Article file – valid entries

Error message: [...] is not a valid entry.
Explanation: For some attributes/properties we only allow certain values. You can find all possible entries in our docs. The possible entries are given in English, but we translate them automatically for you. If something is missing, feel free to contact us!

Article file – order number

Please note that each order/SKU number can only be assigned once.

Note

You can find out how to download a price or product template in the Export article.