How to use pricing formulas
A pricing formula prices your work from its parts: a flat base, your hourly rate, what the product costs you, and your markup. Change one number in the formula later and every item built on it is repriced in one pass, with a record of what moved.
Find the formulas screen
Where to clickAdminPricing RulesNew Formula
Press Admin at the bottom of the left sidebar, then pick Pricing Rules from the admin menu that appears. The page itself is headed Pricing Formulas, and it lists everything you have built so far.
Press New Formula at the top right to start one. The admin area is owner only, so this stays your screen and not your crew's.
Build the formula
Where to clickAdminPricing RulesNew FormulaAdd Component
Name it in Formula Name so you can tell it apart later, then build the math in the Formula Components card. Press Add Component for each piece and pick a Component Type.
There are five types: Base Cost for a flat amount on every item, Labor Hours for your hourly rate, Product Cost for a multiplier on what you pay for the product, Material Cost for a fixed materials amount, and Markup % for a percentage on the running total.
Markup % applies to the total of the lines above it, so keep that one last. The Test Calculator underneath runs sample numbers through the formula, so press Create Formula once the result looks like what you would actually charge.
Price an item with it
Where to clickAdminPrice BookNew ItemUse Pricing Formula (Recommended)
Press Admin in the left sidebar, pick Price Book, and press New Item. Scroll to the Pricing card, where Pricing Method already sits on Use Pricing Formula (Recommended).
Choose the formula under Select Pricing Formula, then fill in the item specific parts: the hours the job takes and what the product costs you. Anything tagged (From Formula) is locked here on purpose, because those are the numbers a repricing depends on.
Calculated List Price updates as you type and is what gets saved on the item. Pick Manual Pricing for the odd item you would rather price by hand.
Change one number and reprice everything
Where to clickAdminPricing RulesEditSave ChangesApply Changes
When your hourly rate or your markup moves, edit the formula instead of touching the items one by one. Open Pricing Rules, press the pencil on the formula, and change the value.
A banner tells you how many price book items the formula is used by, and pressing Save Changes opens Preview Cascade Impact rather than saving. Read it, then press Apply Changes to write the new prices or Cancel to leave the price book alone.
Every run is kept. Press View History on the same edit screen for Cascade History, which shows who ran each change, how many items moved, and the total, and lets you undo a run for 24 hours afterwards.
Common questions
Can I undo a repricing?
Yes. Every run is listed on the Cascade History page for that formula, reached with View History on the edit screen, and the undo button stays on the row for 24 hours after the run.
Does every price book item have to sit on a formula?
No. Choose Manual Pricing on the item and you type the price yourself, and a later repricing leaves that item exactly where it is.
Can I keep more than one formula?
Yes, and most companies end up with a few, such as one for residential work and one for commercial. Each item points at one formula, and only formulas with Active ticked show up in the item picker.
Why can I not delete one of my formulas?
The formula carrying the star is your default and its delete button is switched off, so press the star on another formula to move the marker first. A formula that price book items still point at also refuses to delete until you move those items onto something else.
Who can build and change formulas?
Owners. The whole admin area is owner only, so dispatchers and technicians work from the prices without being able to change the math behind them.