Set & Manage Prices

Every customer’s price, on the record.

Keep your pricing logic in one model, derive each customer’s price list from it by formula, send what breaks policy for review, and publish the approved list to the customer and the systems that use it.

Price & Quote Management/Customer Price Books/Summit Building Supply Q1 2027

One customer’s price list, generated from the shared pricing model and resolved line by line. The data is illustrative.

The customer
Summit Building Supply’s Q1 2027 price list holds 1,260 items, generated from the Customer Price Books model.
What it shows
86 items take a contract price, 1,131 take list less Summit’s program discount (6% on PVC, 4% on brass) and 43 take list. The 1" brass ball valve is $9.25 less 4.0%, $8.88.
What happens next
3 contract prices sit under the floor after copper rose, such as the 2" gate valve at $20.80, so they wait in Pricing Review. The other 1,257 lines are approved.
01 · Start from one model

One pricing model, a price list for every customer.

The Customer Price Books model holds every column and formula once. Each customer gets a price list built from it, holding only that customer’s items, so a change to the logic reaches every customer on the next refresh.

Columns

Bring the inputs together on the model.

List price comes from the Contractor Q1 2027 price list. The customer’s program discount and contract prices come from datasets loaded from your agreements. Each is a lookup, matched on customer and item.

Generate price lists

One list per customer, in one run.

Split the model’s source by the Customer column and a background job creates a price list for each customer, with the customer filled in as a header.

How it works: models, customer lists and refresh
Model and lists
Columns and formulas are added on the pricing model. A customer’s price list holds its rows and inherits the model’s columns; columns cannot be added to a single list.
Rows, then refresh
Loading rows copies the data; a refresh computes the formulas. From the model, you can refresh every price list built from it at once.
Headers
Each list carries an effective date, an expiration date and header fields you add, such as Customer or currency. A header can be set by formula.
Lookups bind by name
A lookup names its source, so renaming the Contractor Q1 2027 list or a dataset can leave a column empty. Lineage shows what depends on a source before you change it.
02 · Derive the customer’s price

Write the precedence once, as a formula.

Customer Price takes the contract price when there is one, otherwise list less the customer’s program discount. The 2" PVC coupling takes its $5.95 contract price; the 1" brass ball valve takes $9.25 less 4.0%, $8.88; the 1/2" copper tee has no program and takes list, $2.02.

Commercial Execution/Commercial Models/Customer Price Books

The customer price is a formula on the shared model: contract first, then program, then list. The data is illustrative.

  • Contract, then program, then listThe order is in the formula, where anyone can read it, not in whichever spreadsheet is newest.
  • Lookups across RevomoRead list price from another price list, and programs and contract prices from datasets.
  • Checked before it countsVerify a formula as you write it. Saving checks every column it names.
Price Source

Show which price applied, on every line.

A Price Source column names the rule each line used, so “which list is he on?” has an answer in the grid. On Summit’s list, 86 lines take a contract price, 1,131 take the program and 43 take list.

Floor check

Catch a contract price that fell under policy.

Floor Price comes from your margin corridors. After copper rose, the 2" brass gate valve’s $20.80 contract price sits under its $21.08 floor.

How it works: formulas you own
No fixed hierarchy
Revomo does not ship a base, market and customer hierarchy. Precedence is a formula on your model, built from coalesce, if and case, and you can add a market or quote level the same way.
Two checks
Verify checks syntax, functions and lookup sources as you write. Column names are resolved when you save, so a misspelt column is caught there.
Your floor
The floors here come from this example’s Margin Corridors ruleset (22% on brass and 24% on PVC for contractors). Revomo does not supply a floor; you set the policy.
Effective dates
A contract price with start and end dates is read with a filter and a sort in the lookup, so the current agreement applies and an expired one does not.
03 · Review what breaks policy

Only the exceptions wait for a person.

When Summit’s list recalculates, an automation approves every line whose floor check reads OK. The 3 contract prices under the floor wait in Pricing Review, where a pricing manager decides whether to honor them to term.

Price & Quote Management/Customer Price Books/Summit Building Supply Q1 2027

Lines that pass the floor check are approved by an automation; the three that don’t wait for a person. The data is illustrative.

  • Routine lines move onAn automation approves the 1,257 lines that pass, when the price list recalculates.
  • Exceptions get a decisionThe reviewer approves or rejects the lines waiting on them, with an optional reason.
  • Renewals stay in viewA contract price under the floor becomes a renewal conversation, not a margin loss nobody saw.
Refresh policy

A price agreed by hand survives the refresh.

Customer Price uses Preserve Edits. If a pricing manager sets one of Summit’s prices by hand, the next refresh keeps it until someone reverts it, and the audit log records who set it.

History and audit

Know what changed, and go back.

  • VersionsTake a snapshot of Summit’s list before a change, open an earlier version, and restore it.
  • RevisionsReopen an approved list as a new revision, and compare each price with the previous one.
  • Audit logEvery action on the list, with who, when and the values that changed.
How it works: approvals and changes by hand
Your policy
The lifecycle policy on the model names the states, the actions that move a list, and who may take each one. Review can run on the whole list or line by line.
Automations
An automation fires when a price list recalculates and acts on records that match its conditions. It runs on refresh, not continuously.
Contract changes
Changing an agreed price means updating the contract price it reads. Contract Pricing & Renewals keeps agreements as their own records with their own approvals.
Many prices at once
A bulk update filters records, sets each field by value or formula, simulates the effect, then submits it for approval.
04 · Publish the approved list

Send the approved list where it is used.

Once the 3 exceptions are decided, generate Summit’s price book from a publishing template, share it as a link, and download the list as a CSV for the systems that take a file.

Publishing

A branded price book for the customer.

A publishing template sets the layout and which columns appear, so cost, floor and margin stay internal. Generate it as a PDF, Excel file or web page, or create a share link with an expiry and a password.

Download

A CSV for the ERP’s price import.

Download exports the list in its current layout and filters, as a background job. Load the file through your ERP’s own price import.

How it works: documents, links and exports
Documents and links
Documents are PDF, Excel or HTML, or a live link. Share Links lists every link on the list, and any link can be revoked.
Exports
Download produces a CSV of the list. Exports also reach connected Databricks and Salesforce destinations as background jobs.
No ERP write-back
Revomo does not write prices into your ERP directly. The method for each system is agreed in the Activation and Success Plan.
Templates
A template is set up once and reused for every customer, and can replace the previous version of a document when you publish again.
05 · What powers it

What powers it.

The capabilities that do the work, what every subscription adds, and where to start.

Capabilities it uses

In every subscription

Start here

Related solutions: Manage Contract Pricing & Renewals, Manage Quotes & Deal Pricing, Price Increase Management, Cost Recovery & Repricing.

FAQ

Common questions

We have tens of thousands of customer-specific prices. Does that migrate?

Yes. Load your existing contract prices as a dataset, from a CSV or Excel file or through a connector, and each customer’s price list looks them up by customer and item. Prices that follow a rule, such as a program discount off list, become a formula instead of a stored row, so only true exceptions stay as prices someone maintains.

How does Revomo decide which price a customer pays?

Your formula decides. A typical customer price takes the contract price when one exists, otherwise list price less the customer’s program discount. A Price Source column records which one applied on every line. There is no fixed precedence chain in Revomo; the order is whatever the formula on your pricing model says.

What happens to customer prices when list prices change?

Refresh the customer price lists. Each one looks its list price up from the segment list, so a refresh recomputes every customer price that follows list. Contract prices stay as agreed, and a floor check you define flags any that now sit under policy, so they can wait for review.

Can sales still negotiate customer-specific prices?

Yes. A deal is priced as a quote from the customer’s standing list, with the concession in its own column and lines under your floor routed for approval. A price agreed for the long term goes into the customer’s contract prices, so the next list picks it up, and every change is in the audit log.

What happens in the ERP?

The ERP keeps executing orders. Revomo does not write prices into it directly: download the approved list as a CSV for your ERP’s price import, or export it to a connected Databricks or Salesforce destination. The method for each system is agreed in the Activation and Success Plan.

Can a customer receive their own price list?

Yes, as a generated document. A publishing template sets the layout and which columns appear, so cost, floor and margin stay internal. The list generates as a PDF, an Excel file or a web page, or as a share link with an expiry and an optional password.

Put every price on the record.

Bring your messiest customer price list. We’ll show you the model, the formula and the first reviewed list.

Plate B2 · Series 2026