Skip to main content

Setting Up a Price List - WUI

How to populate a price list in the web interface by importing from Excel, and which data to import

Written by Lenka Haringerová

For many companies, the Inventory module containing the Price List is used very frequently. Price list items can be either stock items (when used in documents, a warehouse must always be specified) or non-stock items.

The best way to populate the price list is by importing from Excel. In the Price List module, start the import by clicking the … (More functions) button in the footer of the list and selecting Import from Excel. The only mandatory field for the import is the Code/abbreviation of the price list item; however, the import offers a large number of unique fields related to each price list item.

At a minimum, you should import the following values:

  • Code/abbreviation,

  • Name,

  • unit of measure,

  • stock item (specifies whether the item is a stock or non-stock item),

  • VAT rate (if you don't specify it, the 21% rate is filled in automatically),

  • price type (if you don't specify it, "excluding VAT" is filled in automatically),

  • inventory type,

  • selling price (according to the price type).

💡 We recommend trying the import with a single item first, checking the result, adjusting and completing it if necessary, and only then running the import for all items.

💡 Need help? Email us at podporaflexi@abra.eu or use the chat in the bottom-right corner.

Did this answer your question?