Use Edit → Administration → Change Prices… to change the sale prices of many items in one list, without opening each item. You can type prices one by one or set a price for all listed items with a calculation. Saved operations do not change.
Change prices in the list
- Go to Edit → Administration → Change Prices…. The Change prices window opens.
- Find the items with Filter or Groups, as in Items.
- Click a price and type the value. Press Enter or click another cell to keep it.
- Click Apply and answer “Do you want to save the changes?” with Yes.
- Click Close.
A raised price turns green and a lowered one red until you apply it. The bar at the bottom shows the change of the edited cell, for example “The price for this item is increased from 3.99 € to 4.50 €.”

| Control | What it does |
|---|---|
| Close | Closes the window. It does not ask: prices you did not apply are lost. |
| Apply | Saves the changed prices, after a question. The window stays open. |
| Edit | Opens Edit Price for All Items in the List. |
| Clear | Asks “Do you want to undo all unsaved changes?” and restores the saved prices. |
| Groups | Shows the item groups, so you can list only one group. |
| Export | Exports the listed items with their prices. |
| Settings | Opens a panel with Calculate markup using cost and Calculate markup using last cost, the base of the Markup % columns. |
| Location | Selects a location and adds the Location price column. |
| Partner | Selects a partner and adds the Partner price column. |
The price columns
| Column | What it shows |
|---|---|
| Purchase Price, Last Cost | The current and the last purchase price. They cannot be changed here. Users with hidden purchase prices do not see them. |
| Wholesale price, Retail price, Price group 1 to Price group 8 | The sale prices of the item. They are the same at all locations. Your database may show other names for the groups. |
| Markup % | One column for each price, with the markup over the purchase price. Hidden by default. Right-click a column header to show it, or to show Measure. |
| Location price | A price for the selected location only. A grey value means none is set and the location uses its price group. Empty the cell to remove the price. |
| Partner price | A price for the selected partner only. It works like Location price. |
If a price is lower than the purchase price, the program asks “The value you entered for “Retail price” is lower than the purchase price. Do you want to continue?”. Do not warn me anymore clears Warn if the sale price is lower than the purchase price in Tools → Settings….
Set a price for all listed items
- List only the items you want to change: the calculation runs on every row of the list.
- Click Edit. The Edit Price for All Items in the List window opens.
- In Set the price in: select the price to change.
- Select Fixed value and enter the price, or select Calculated value and choose a source price, an operation and a number.
- Click OK. The list shows the changes, and nothing is saved yet.
- Check the list and click Apply.

For example, to raise all retail prices by 10%, select Retail price in both lists, the * operation and enter 1.1. To set the wholesale price to the last cost plus 2, select Wholesale price in Set the price in:, then Last cost, the + operation and 2. The source list offers all prices, Last cost, and Location price or Partner price when you selected a location or a partner.
Permissions
All permissions are set in Edit → Administration → Permissions….
| Permission | What it allows | Not allowed by default for |
|---|---|---|
| Administration → Change Prices… | The menu item. | Operators |
| Items… → Edit | The Edit button of this window. | Operators |
Troubleshooting
| Problem | Solution |
|---|---|
| Apply is disabled | No price has changed. Press Enter in the edited cell. |
| A sale still has the old price | A price rule, a partner price or a location price may apply. See Price rules. Saved sales keep their prices. |
| “Division by zero is impossible.” | Enter a number other than 0 for the / operation. |