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 Account menu, Modules/Features. The import is then in the product list (Products, Show inventory) 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.

Products that aren’t in the new file stay in the inventory unchanged.