# Price Book & Vendors

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

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](/tenant/?open=settings/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](article:88d4e232-d5b8-4909-b452-cfe96d3d550f).
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](article:fb7c92e4-6dcc-4ef4-80bc-1b6e7482e540).
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.

## Print the price list

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](article:88d4e232-d5b8-4909-b452-cfe96d3d550f). **Out of the box** shows the module's starting roles that have it.

| Permission | What it lets someone do | Out of the box |
|---|---|---|
| **View products and vendors** | See 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 prices** | See 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 book** | Add 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](article:073c6465-d85c-4364-8768-acf42a3a6a48).

## 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](article:1d8a33a4-3a13-4874-b8e5-5ef9da22df95).

## 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.


Source: https://datavisions.ai/docs/module-guides/price-book-vendors
