In this chapter, we will walk through a specific example of importing from Excel into the individual purchase prices register. For general principles of Excel imports, we recommend reading the first chapter - Introduction. Excel imports are available from the Business plan and above.
​
If your license includes imports of purchase invoices, they will be available in the Tools module (Tools -> Import -> Import from Excel -> Suppliers, purchase prices, their stock levels).

The import of individual purchase prices is always linked to a specific price list item. The party to whom the individual price applies can be selected in two ways — either all suppliers (in which case it is a price in a given currency), or one specific supplier. Both methods are described in the guide on individual prices.

The guide also contains a detailed description of how individual prices work.

For testing purposes, we will import the following file: dodavatele.xlsx

Your individual import may contain different columns depending on which data you need to include in the stock documents. For the purposes of this tutorial, however, we will use only a general file.

We will be importing the following columns:

The order of the selected columns for import must exactly match the order of those columns in the imported Excel file.

Price list - code/abbreviation of the price list item

Purchase price - purchase price in the relevant currency

Company - code/abbreviation of the supplier to whom the individual purchase price applies

Currency - the currency in which the purchase price is stated

Once you have selected the columns you want to import, you can confirm your selection by clicking Ok. Clicking it will open another window displaying a confirmation of the selected columns and their expected data types.

If everything looks correct, click Ok again to confirm and select the relevant file.

If the Excel file is valid and eligible for import, the window above will appear showing the number of records to be imported — either as new entries or as updates.

Press Yes to complete the import.

While working with imports, you may encounter a number of errors. Below are links to some of the most common ones.