Price Book & Vendors

Keep every product, its price and its vendors in one list that quotes, invoices and other modules use.

Copy page for AIUpdated November 21, 2026
Watch: Find a product or vendor (53 seconds)8 videos

When every estimator keeps their own price sheet, the same bag of resin is quoted three ways. At Acme Precision, the office keeps one Price Book of what each product costs and sells for, and who they buy it from, so estimates, field forms and bills all use the same names and prices.

Add it from the Marketplace

What it does

The module adds two pages under Price Book & Vendors in the sidebar, plus Reports:

  • Price Book: every product you sell or use on jobs. A product is a Material, Equipment rental, Operated equipment, Pass-through, Subcontractor labor or Other, with its unit and price. The tiles count Products, Needs review, Cost+ and Below cost. The columns show Price (Fixed or Cost+), Sell, Cost today, Markup, Margin, Vendor and Min.
  • Vendors: the suppliers, subcontractors and rental companies you buy from. The tiles count Vendors, Products carried, Custom Cost+ and With fees.
  • Click a product to open it in the side panel: its Sell, Cost today, Markup and Margin tiles, its details, and a Vendors table with each vendor's cost and price history.
  • Click a vendor to open it in the side panel: its details and terms, its Fees, and the Products it carries.
  • Reports: a ready-made Price list.

A product is priced one of two ways. A Fixed price is yours whatever the vendor charges. Cost+ follows the vendor's current cost, plus that vendor's fees, plus a markup.

Set it up

A Workspace Admin does this first.

  1. Decide who sees dollars. Give View costs and prices only to roles such as estimators, office and accounting, and give Maintain the price book together with it. Everyone else picks products by name and sees no prices. See Users and roles: create and edit roles.
  2. Open Module Settings from the ⋮ on the Price Book & Vendors sidebar row. On Preferences, set the usual Cost+ markup for each kind (out of the box: materials 25%, rentals 15%, operated equipment 15%, pass-through 10%, subcontractor labor 25%, other 20%). See Module settings and versions.
  3. On Vendors, add the companies you buy from, and any fees they charge on top, such as a fuel surcharge.
  4. On Price Book, add your products. There is no upload screen: to load a whole price sheet, ask Data Visions support, or ask the Price Book Assistant to load it.
  5. Record each vendor's price for the products they sell you, and give owned equipment an internal cost.

Find a product or vendor

  1. In the sidebar, click Price Book (or Vendors).
  2. Click a kind in the switch above the table, such as Materials or Operated equipment. On Vendors, click a type.
  3. Type in the search box. The Price Book searches the name, SKU, category and vendor; Vendors searches the name, contact, phone and city.
  4. Click a column heading, such as Margin, to sort by it.
  5. Click Show inactive to include products or vendors that were switched off. It then reads Hide inactive.
  6. Click a row to open it in the side panel.

Add a product

  1. On Price Book, click Add product.
  2. Type the Name, pick the Kind, and type the Category and Unit (such as yd, ton, day, hr or ea).
  3. Under How it is priced, pick Fixed price and type the Sell price, or pick Cost+ on the vendor's price.
  4. Click Add product. It opens in the side panel.

Its Job cost code and Taxable setting are filled in from the kind; change them with Edit. Two products can't share a name and kind.

Change a product's details and pricing

  1. Open the product and click Edit.
  2. Change the Name, Kind, Category, Unit, SKU, Job cost code, Taxable or Active.
  3. Under How it is priced, click Fixed price and type the Sell price, or click Cost+ vendor price and type a Markup % if this product needs its own.
  4. Set a Minimum qty (for example 4 for a four-hour minimum), the Default vendor, and the Internal cost for your own equipment.
  5. Click Save. The price tiles update.

Add a vendor

  1. On Vendors, click Add vendor.
  2. Type the Name, pick the Type (Supplier, Subcontractor or Rental company), and add a Contact and Phone.
  3. Click Add vendor. It opens in the side panel.
  4. Click Edit to add the Email, Address, Terms, Our account number, Notes and a Custom Cost+ markup %, then click Save.

Record a vendor's price

When a vendor sends a quote, an invoice or a new price list:

  1. Open the product and click Add price. (Or open the vendor and click Add product price, or click Add price at the top of the Price Book.)
  2. Pick the Vendor (or the Product).
  3. Type the Cost per unit and the From date.
  4. Pick Where it came from: Quote, Invoice, Price list or Entered by hand.
  5. If you like, type the Vendor's item name or SKU and Notes, and tick Make this the product's default vendor.
  6. Click Save price. Cost today and Margin update.

Prices are never edited. Earlier prices stay in the history, and a price dated in the future starts counting on that date. To correct a mistake, add the right price with the same From date; the one entered last counts.

Compare vendors and choose the usual one

  1. Open the product. The Vendors table shows each vendor's Cost, Fees, Cost + fees, Sell and Margin, with the default vendor first.
  2. Click the clock icon (Price history) on a row to see every price that vendor has given, newest first.
  3. To cost the product from a vendor, click the check icon (Set as default vendor) on its row. Or click Edit, pick the Default vendor and click Save.

With no default vendor, the active vendor with the latest price is used.

Add a vendor fee

  1. Open the vendor and, under Fees, click Add fee.
  2. Type a Name, such as Fuel surcharge or Delivery.
  3. Under How much, pick Percent of the cost, or Fixed amount and then Per Line (once) or Unit. Type the Amount.
  4. Tick the kinds it Applies to, or none for everything.
  5. Click Save fee.

Click the pencil (Edit fee) to change a fee or untick Active to pause it. The bin (Remove fee) deletes it after asking; lines priced earlier keep their price.

Set markups

A markup sets the sell price of a Cost+ product. The most specific one wins:

  1. For a kind: Module Settings, then Preferences.
  2. For a vendor: open the vendor, click Edit, type the Custom Cost+ markup % and click Save.
  3. For a product: open the product, click Edit, click Cost+ vendor price, type the Markup % and click Save.

The product's Sell tile says which rule priced it, for example Cost+ (the vendor's markup). Fixed-price products are not affected.

Cost your own equipment

  1. Open the rental or operated-equipment product and click Edit.
  2. Type the Internal cost per unit and, if it has one, the Minimum qty. Click Save.

With no vendor price, Cost today reads Own equipment (internal cost) and the margin shows. If you also use Equipment & Tools, units linked to the rate show as Own equipment · N units in the Vendor column, and under Units at this rate on the product; click a unit to open it.

Check items that need review

When a loaded price sheet disagrees with itself or has no price, the item is marked needs review.

  1. On Price Book, click the Needs review tile.
  2. Open an item. The notice shows the price in the sheet's text and the price in its price column.
  3. If needed, click Edit, fix the Sell price and click Save.
  4. Click Mark reviewed.

The Below cost tile works the same way for products selling under their cost.

Switch items off and export lists

  1. Click Export CSV to save what the list shows.
  2. Or tick rows and open Actions: Export selected to CSV, Mark reviewed, Make active or Make inactive. On Vendors, Make inactive… asks first.
  3. To switch off one item, open it, click Edit, untick Active and click Save.

Nothing in the lists is deleted. An inactive product or vendor leaves the pickers but keeps its prices and history.

Rearrange the columns

  1. Drag a column header left or right, or click Columns at the right of the table's header row.
  2. In Columns, untick a column to hide it, and use the arrows to move it.
  3. Click Reset to go back to the original layout, then Done.

Your layout is saved for you only, on every device.

  1. In the sidebar, open Reports under Price Book & Vendors.
  2. Under Ready-made, click Price list: every active product with its unit and sell price, grouped by category.
  3. Keep or change the Report name and click Create report. The report opens, ready to print, and stays under Saved reports for next time.

Who can do what

Each action in the module needs a permission. A Workspace Admin gives permissions to roles; see Users and roles: create and edit roles. Out of the box shows the module's starting roles that have it.

PermissionWhat it lets someone doOut of the box
View products and vendorsSee and pick products and vendors by name (with units, kinds, contacts and terms) on forms, dailies and estimates, with no prices at all.Admin, Operator, Viewer
View costs and pricesSee vendor costs and price history, fees, sell prices, markups and margins, and see prices on lines in estimates and other modules. Give with care.Admin
Maintain the price bookAdd and change products, vendors, vendor prices and fees, set default vendors, mark items reviewed, switch items on and off, and load a price sheet. Give with care.Admin
  • Add price and Add fee show only to people with both Maintain the price book and View costs and prices.

Ask its agent

The Price Book Assistant answers from your own Price Book and has your access, no more: without View costs and prices it answers with names only. Try:

  • "What is the margin on the epoxy resin system, 5 gal?"
  • "List our operated equipment with its internal cost and minimum."
  • "Change the sell price of Stainless fasteners, assorted to $72 a box."

Before any change, it says exactly what will change and waits for your yes. It can also load a vendor's price list from a spreadsheet, PDF or pasted table after showing a preview. See Agent chat.

Good to know

  • Crews pick products by name on forms and dailies and never see a price.
  • An estimate line keeps the price it was added at. Use Re-price… on the estimate to bring old lines up to date.
  • A fixed-amount fee charged Per Line (once) is left off dailies, since a rental appears on every daily while it is on site.
  • The Sales tax % in Preferences isn't used yet. Accounting adds sales tax with its own rate on products marked Taxable.
  • Dashboards and reports can use three Price Book data sets: products, prices and margins, and vendors. See Dashboard.

More help

Open Help at the top right of the Price Book or Vendors page for the full reference, including how a price is worked out. Help also has how-tos for each job and answers to common questions. Price Book & Vendors works with Equipment & Tools for your own equipment, with estimates and field forms that price their lines from it, and with Accounting for billing.

Can't find what you need? Contact support.