Importing a price list and bulk price changes

The price list goes into the Products module. If it isn’t on, turn it on in the Company menu, Modules and features. The import is then in the product list (Products, All products) under the Import button.

Save your Excel file as CSV. Columns are recognised by the names in the first row, in Czech or English: Name, SKU or Code, EAN, Price, Purchase price, Unit, Stock, Description. There is no limit on the number of products and the file can be up to 20 MB, so even a price list with thousands of items goes in at once.

You can upload the price list again and again. A product with the same code or EAN that you already have is not created twice but updated from the file. The preview marks it as “will be updated”. Only what the file contains is overwritten: a missing column or an empty cell doesn’t change the existing value. For regular price updates, a file with the code, name and price is enough.

Units in stock. A new product with the Stock column filled in is created as goods and the number becomes its opening balance. For goods you already have, the unit count is not silently overwritten: the number in the file is compared with today’s stock and the difference is recorded as an Import movement. The product card then shows when the import changed the stock and by how much. For a service the Stock column is ignored. More in Goods or service, and units in stock.

Products that aren’t in the new file stay in your price list unchanged.

Didn’t find the answer?

Write to us and we will help.

Ask a question