Adjust prices in bulk (e.g. at the turn of the year)

Raise or lower the sales and purchase prices of many items at once by a percentage, with rounding and an old/new preview. Nothing is saved until you confirm; open documents show a hint to use the new prices, and sent and issued documents stay unchanged.

At the turn of the year, or when a supplier raises prices, you don’t want to open every item one by one. With Adjust prices you change the prices of many items by a percentage in one step — and see exactly what will happen first.

How it works

  1. Open Inventory › Catalog and tick the items whose prices you want to change. With the category filter and Select all you quickly get a whole category, for example all drinks.
  2. In the selection bar, click Adjust prices.
  3. Under What to adjust? choose:
    • Sales price,
    • Purchase price or
    • Sales and purchase price.
  4. Enter the Change in %, for example 4 for +4 % or -2.5 for −2.5 %.
  5. Choose the Rounding: None (to the cent), To 0.05 or To 0.10. Prices under 1 € — such as a purchase price per gram — are calculated more precisely and not rounded.
  6. Under Effective from when? choose:
    • Immediately — the new prices become the items’ base price from now on.
    • From a date — enter the day under Effective from from which the new prices should apply, for example 1 January. The items’ current price stays as it is, and Univents keeps using it for dates before that.
  7. Click Show preview. You see the old and new price of every item and, above, how many items are skipped and why.
  8. If everything looks right, click Apply prices. Only now do the prices change. Use Back to change the percentage, rounding or date first.

Got the supplier’s new price list?

If your supplier already states the new purchase prices in a price list (PDF, photo, Excel, CSV or JSON), you don’t have to estimate a percentage: in the Price inbox (Inventory › Price inbox) Univents reads the list, matches it to your items and applies the exact prices from a set date. See Reading supplier price lists and applying cost prices from a set date. The bulk adjustment here remains the right way if you only know a percentage or also want to change sales prices.

How many items at once?

Up to 500 items get their prices adjusted per run. If you select more, the dialog tells you up front and leaves Apply prices inactive. Split the selection, for example by filtering one category at a time and running the bulk adjustment twice.

Gross or net

Each item is adjusted on the side you maintain it on:

  • Items maintained gross are raised and rounded on the gross price. With +4 % and rounding to 0.10, 5.00 € gross becomes exactly 5.20 € gross; the net price is derived from it.
  • Items maintained net are adjusted on the net price, and the gross price follows.

For the purchase price, Univents adjusts the value you entered on the item — per unit or per pack. The purchase price per unit is derived from it just like when you edit the item.

What is skipped

The bulk adjustment leaves these items alone. The preview lists them with a reason:

  • Bundles with an automatic bundle price — their price comes from the components and follows by itself when you adjust the components.
  • Payroll items and tickets.
  • For the purchase price: bundles and recipes whose purchase price is calculated from their components.
  • Items without a sales or purchase price.
  • Items whose price would not move in the requested direction after rounding — for example, 1.14 € with +0.5 % rounded to 0.10 would become 1.10 €. Such items stay unchanged.
  • Items that belong to another operation, if you work with separate operations.

If you choose Sales and purchase price and an item has no purchase price, only its sales price is adjusted.

What happens to quotes and invoices

With Immediately, the new prices become the items’ base price from now on:

  • New line items use the new price, and so do new documents created from the catalogue and your booking pages.
  • Open quotes, delivery notes and invoice drafts do not change by themselves, not even immediately. The document shows the hint “The article price of X items has changed” at the top and marks the line item. Right after Apply prices, Univents asks whether the new prices should go into the open documents and shows them all in one window, where you update selected ones or all at once. Later you can do it per document with Review and Use all. This also applies if you change an item’s tax rate. More in Article price changed: hint in the document.
  • Open bookings keep their price as well. They get the new price when you use it in the document.
  • Differing prices are still shown in the Bookings tab with a grey hint. If an unsent document shows a different price, the hint is yellow. What it means is explained in Bookings tab: total and the hint when a price differs.
  • Line item templates keep the price you saved them with. After a price round, it is best to check them once.
  • Planned shifts do not take the new price along. Only new shift line items use the current item price.
  • Sent and issued quotes and invoices do not change.

Your pricing rules (for example tiers, weekend or season) calculate on the price the line item has when you change quantity, guest count, date or room — not on the new item price. An example: an item cost €100, now €120, and the tier “from 10 pieces” gives 10 % off. If you raise the quantity of an existing line item from 1 to 12, its price stays at €90. You get the new item price through the hint in the document.

With From a date, the items’ base price stays unchanged. From the chosen day, new line items use the new price and dates before it keep the old one — even if you book them later. If the item already has a price for that day, the percentage applies to that price instead of the base price — otherwise an increase would end up below the price you already scheduled for that day. Sent and issued documents do not change, and existing quotes and drafts do not get it by themselves but show the hint to use it. More in Creating & configuring items and in the New price from section on the item.

For time-limited surcharges and discounts (for example weekends only), a Season pricing rule is still the right tool — it calculates on top of the price of the day.

Undo

There is no undo button, so check the preview. Every price change is recorded in the item’s change log. A counter-adjustment (for example −4 % after +4 %) is possible, but because of rounding it doesn’t always hit the old cent amount exactly.

With the AI assistant

You can also write in the chat, for example “Raise all drinks by 3 %”. The assistant first shows you the preview and changes nothing. Only when you confirm and click the confirmation card are the prices adjusted.

Who can do this?

Any role that may edit in the inventory can adjust prices. The bulk adjustment is available in every plan that includes the inventory; scheduling From date is part of every plan.

Univents newsletter

Three topics, pick any. Roughly once a month, no more.

Topics