A hotfix package will be released today September 9th, 2026 to Solteq Commerce Cloud. It will fix a problem that caused ingredient and product option selections to be missing from the final receipt in certain circumstances. The hotfix is applied to the Kiosk module only. Back Office, POS (normal & pilot), Mobile POS and the integrated webshop will all be functioning normally and without any interruptions.
for Retail and Restaurant
for Retail and Restaurant
Breadcrumbs

Mass Changes to Product Prices with Excel: Video Tutorials

This page contains examples on how you can mass edit selling prices for products in certain category.

In the example below, the selling prices for products in the product group Beer need to be modified (for example, due to supplier increasing purchase prices); minimum margin for the products needs to be calculated, so that the new prices can be set.

Exporting Product Information and Editing it in Excel

  1. Filter products belonging to the product group Beer.

  2. Export the filtered list of products to Excel format.

  3. Remove unneeded columns from the Excel file.

  4. Add new column Margin and calculate the margins for the products.

  5. Adjust product prices to improve margins.

The formula used on the video is: 

margin % = (((selling price - Inprice) / selling price)* 100)

In addition, we calculate the inprice with tax by using the tax percent of the product:

=(E2-(G2*(1+D2/100)))/E2

Original Excel file exported from the Back Office:

DEMO_Import.xlsx

Edited Excel file:

DEMO_Import.xlsx

Importing Edited Product Information to Back Office

  1. Import the edited Excel file back to the Back Office.

  2. Check the Import Result e-mail for errors.

  3. Make changes to the Excel file to fix the error.

Imported Excel file:

DEMO_Import.xlsx