Pricing table. Add and set your pricing table

This article will help you get started with the pricing table. 

First, add the pricing table block to your document.

Add products

To add line items, start typing in the Name column — auto-suggest will show available options from your Catalog (provided you have products in your Catalog). Alternatively, click From catalog to import products from your Catalog. You can also right-click in any cell and select Insert from catalog below to quickly add a new item. You can enter line items in your pricing table manually as well.

You can search your catalog items by product name, SKU, description, custom field names, and their values. The search result will be shown in the following priority: 

1. Product name
2. Product SKU
3. Product description, custom field name the field's value

Additionally, you can search by using the Category name and the results will show all the items within the category.

After you import an item from your Catalog, its custom fields will be automatically added as hidden columns. To display a custom field, click the plus sign on the right side of the pricing table or right-click in any cell, then choose your custom field from the hidden columns.

If you'd like to display the product description in a separate column instead of below the product name, hide the Name column by right-clicking on it > Hide column. Then, click on the plus sign on the right side of the pricing table, or right-click in any cell, and under Add hidden, select the name column and the description column adding them separately. Please note, this action cannot be reverted. 

PDF page break behavior with pricing tables

1. The grand total will be treated as a single, unbreakable unit and cannot be moved to the next page without at least one line item accompanying it. There will be no page break between the grand total and the pricing table.
2. A page break cannot separate a section header from its associated line items on the next page.
3. The pricing table header cannot be separated from the pricing table itself unless there is at least one line item from the pricing table on the same page.
4. Page breaks will not occur immediately before a section summary.

To control the placement of the pricing table header in PDFs, select the pricing table, then select Properties on the floating panel > Settings > switch on the toggle Include table header on each page.

Set pricing table currency

You can learn more about currency formatting here. 

Navigate to pricing table properties, click on Settings, and select table currency.

If you are using Document value, make sure the currency in Document value settings matches the pricing table currency. Otherwise, the pricing table will not be included in the Document value calculation.

Hide/unhide columns

Don’t want certain columns to be displayed in the pricing table? No problem! Click on any cell within the column, click on the small arrow in its upper-right corner, or right-click in any cell, and select Hide column. 

When a column is hidden, it’s still included in the calculation.

To bring back the hidden column, click the plus sign on the right side of the pricing table or right-click in any cell.

Similarly, you can hide Subtotal, Discount, Tax, and Total in the pricing table footer. Discount and Tax can be deleted as well.

Add fees, line item discounts, and taxes 

Click the plus sign on the right side of the pricing table or right-click in any cell to add a new column. You’ll have the following options:

• Text
• Tax
• Discount
• Fee
• Additional multiplier

Double-click on the cell where you’d like to add a discount — you can choose between a flat amount or a percentage in the dropdown.

You can hide or delete columns you’ve created. Simply click on a cell within that column, then click the small arrow in its upper-right corner, or right-click in any cell, and select either Hide or Delete column.

Move columns and rows

It’s easy to move columns and rows. Simply click and drag the green label at the top of the column or on the left side of the row:

Import product data from your CRM

If you’re using one of our integrations to create documents directly from your CRM, and you have the integration enabled in Settings > Integrations, the Data merge feature on your pricing table will be automatically turned on in a template. This allows you to send products from your CRM into your pricing table.

Сost and Profit Margin calculation

Availability: Business and Enterprise plans

You can easily calculate and control your profit margin based on the cost and price of items in your pricing tables.

Enable Profit Margin calculation in the Add-on store under Proposal & Quotes.

To calculate your profit margin, open a template or document containing a pricing table and follow these steps:

1. Click the right-side panel in your pricing table and choose Cost under Add hidden.
2. If you don’t have a cost added to a product in your catalog and its value is 0, click on the cell in the column and add a value to it. (Click here to learn about our catalog feature.)
3. Go to Apps on the right, then click +Add on the %Profit Margin tile.

That’s it! You can now see your profit margin automatically calculated.

In the %Profit Margin app, cost is calculated by adding the cost of all items. Profit will show as a value and Margin will show as a percentage. Profit is calculated by Price - Cost. Margin is calculated by (Price - Cost) / Price.

If your template or document contains several pricing tables, you can easily navigate through them by clicking on a table in the %Profit Margin app.

After document completion, you will only see calculations in %Profit Margin app on the right panel. If the separate cost of each item is needed, you can use the Document details API call. Learn more about API here. 

Pricing table variables

Pricing table variables help you easily reuse data from the pricing table footer in your template, document, or form. Each row you add to the footer of your pricing table will appear as a variable, as long as it has a value.

To access the list of variables, first click on a pricing table in your template, document, or form. Then, click Properties on the floating panel and select Variables on the right. Finally, click the copy icon next to the variable name and paste the variable into your document’s content.

You can also find pricing table variables in the Variables tab on the right. 

Pricing table images

It’s easy to make your proposals and quotes look even more professional by adding images of products in your catalog.

Once you import a product from your catalog to a pricing table, all images associated with the product will appear under the product description in the Name column.

To delete an image, first click on the image itself, then click the trash bin icon.

To resize an image, first click the cell options arrow button (step 1 in the screenshot below). Then, in the dropdown, hover over Image size and choose either Default or Fit to cell (step 2 in the screenshot below).

Another way to resize an image is to hover over a column’s vertical border until it’s highlighted in green, then drag the border to resize the column width. The image will resize accordingly. 

You and recipients of your document can preview a product image by clicking on it. Preview mode includes all images in the cell.

Related articles

A PandaDoc pricing table can do much more! Follow the links below to learn about other features in detail:

• Optional items and editable quantity
• Group products under sections and set up multiple choice
• Discounts and taxes
• Table formatting 

Want to learn more about importing products into PandaDoc? Check out our Perfecting Your Product Catalog course on the PandaDoc Learning Academy!