Select Page

Change prices

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

  1. Go to Edit → Administration → Change Prices…. The Change prices window opens.
  2. Find the items with Filter or Groups, as in Items.
  3. Click a price and type the value. Press Enter or click another cell to keep it.
  4. Click Apply and answer “Do you want to save the changes?” with Yes.
  5. 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 €.”

Change prices window with Filter, the item list with the Purchase Price, Last Cost, Wholesale price, Retail price and price group columns, and the Close, Apply, Edit, Clear, Groups, Export, Settings, Location and Partner buttons
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

  1. List only the items you want to change: the calculation runs on every row of the list.
  2. Click Edit. The Edit Price for All Items in the List window opens.
  3. In Set the price in: select the price to change.
  4. Select Fixed value and enter the price, or select Calculated value and choose a source price, an operation and a number.
  5. Click OK. The list shows the changes, and nothing is saved yet.
  6. Check the list and click Apply.
Edit Price for All Items in the List window with Set the price in, the Calculated value and Fixed value options, a source price, an operation and a value

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.

Related pages

Documentation