Focus: The focus of this self-help article is to provide steps and information to about the PandaDoc Editor content block “Pricing Table”
What is the Pricing Table Block?: This is available for the Professional, Business and Enterprise plans. The Pricing Table block is used when you want to create a pricing table for your template/document. The Pricing Table block also works in conjunction with the “Catalog”, found on the left. Click here for more information about the Catalog. Please note: For Price columns, Qty columns, discount and taxes, you can have up to 14 decimal places, with a total of 15 digits.
Watch this 2-minute overview about PandaDoc’s CPQ (configure price quote) module
Step 1: Create a document/template. Click on “New Document/New Template” on the upper right and then click on “Create a Doc”/”Create a template”.
Step 2: Adding the Content Block. Over on the right, click and drag the Pricing Table block over and then you can add your text.
Step 3-A: Pricing Table Content Block Options. With the Pricing Table block, there are many options in order to configure the pricing table. Including Currency, Taxes, Discounts, Headers, Borders, and Show Profit and Margins (Available by Request). Please note: You delete the Price and QTY fields so they will not show in the table, but it still will calculate the Subtotal.
Step 3-B: Currency With this option, you can select a different currency that will be displayed within your pricing table.
Step 3-C: Decimal Places Here, you can set the number of decimal places that will be shown in the pricing able. There are options for 0,1,2 decimal places.
Step 3-D: Taxes With taxes, you have the options to add Line Item tax, which will add a column for Tax or you can add Total tax, which will add a total tax at the bottom of the pricing table. In the red section below, you can also rename the tax and this name will show up in the table. Please note: that you can have more than one tax per each table.
Step 3-E: Discounts With Discounts, you have the options to add Line Item discount, which will add a column for Discount or you can add Total Discount, which will add a total discount at the bottom of the pricing table. Please note that you can have more than one disount per each table.
Step 3-F: Headers and Borders With Headers and borders you can configure how the pricing table is displayed. For Headers, this will enable/disable the top gray bar that includes the column names. For Borders, this will enable/disable the lines that go in-between the columns and rows and the outside boarder around the table.
Step 3-G: Totals You will see options to include, “Subtotal”, “Grand Total” and “Total Quantity”. Check each box if you want to have this data to be displayed at the bottom of the pricing table.
Showing Section Subtotal: You will also see the option to enable section subtotal if you are using “sections” in the pricing table. Example showing below:
Changing the names of the totals. You can click on each of the total names to make any changes you need.
Step 3-H: Show Profit and Margin Currently, this is only available by request and can be used with Enterprise plans only. If you would like this enabled, please let us know. The cost and profit information will show up at the bottom of the pricing table. Cost is added to the pricing table per the total of all the Cost fields for all items in the pricing table and Profit will show the value and percentage. Profit is calculated by (Price-Cost) / Price. Please note: If you do not use a value or (0-Zero) for the Cost field, when the calculation is performed is will use the Price value for the Cost value. This information does not show to your clients. To learn more about this feature, click here.
Step 3-I: Tokens Tokens are shown for pricing table and be used through your template and document to autofill this information. Currently there are four tokens for the pricing table, “Total”, “Subtotal”, “Total Discount” and “Quantity Total”. What is a token?
Step 3-J: Column alignment and deleting columns. With the following option, you can change the column alignments and delete columns of data. Such as “Name”, “Price”, “QTY”, “Subtotal”, or any custom column you add. You will see the options for “left”, “center” and “right” alignment and an option to remove.
Step 4-A: Adding more Rows, Columns and Sections to the table. At any time, you can use the buttons “+ Add Column” ,“ +Add Row” “+ Add Section” to increase the size of the table. When you click on “+Add Column”, you will given a choice to add SKU or “Create Empty”
Step 4-B Rearranging Rows and Columns. With this option, at any time, you can change the order of the rows and columns. To do this, select the row or column, as shown below. For example for “Columns”, you would need to select the column header to re-arrange or remove. Hold down your mouse and then you can move them around. You can delete columns of data as well (except For Price) by using the right side bar, scrolling down and click on “Remove Column”.
Step 4-C: Using Cost. Here you will see a Cost field that can be filled out and to be used with Step 3-H: Show Profit and Margin.
Step 5-A: Using your Catalog Items In the Name Field, type in the first few letters of your Catalog item, click on it and you will see it appear, or you can click on the +Add from Catalog (Catalog Picker) to add multiple items at one time. Click here for more information about the Catalog.
Step 5-B: Adding SKU Column and Custom Fields to the pricing table. Once you have added your Catalog items, you can add a new column “SKU” and if your Catalog items have custom Fields, you can also add these as columns to the pricing table.
Step 5-C: Catalog images. If you have added images in your Catalog item, you will see the images be displayed underneath the description field in the pricing table. At any time, you can click on the “X” on the top right of the picture to remove it. When you or your client clicks on the image, a large version will be displayed.
Step 6: Configuring “Rows” and options. With each of the “Rows” or items that you have added to the pricing table, there are two additional options that can be used. They are “Optional” and “QTY” Editable. Please note: For your Recipients to use the optional and QTY editable feature, you need to have a field assigned to the recipient.
A. Optional – You can set your item to be “Optional”. This will allow your client to “choose” this item when they view the document. If selected, it will be calculated on the pricing table.
B. QTY editable – You can set your item to have the option for “QTY editable”. This will allow your client to update the QTY for the item in the pricing table.
Example of Optional and QTY editable added.
Example of Tables: Showing two examples, one without Custom and another with Custom Fields, Optional/QTY editable, taxes and discounts.
Example 1: Plain table added:
Example 2: Custom Fields, Optional/QTY editable, taxes and discounts.
Step 7: Advanced CSS: The CSS Classes option can be found by clicking into a block and then clicking Advanced on the block settings panel. So, if we add the CSS Class of “user-customclass” below, it allows you to target a specific element on the page with that class in our CSS editor.
Please Note: This is advanced stuff and assumes you have some knowledge of HTML and CSS. Proceed with caution. You can add multiple CSS classes separated by a space.
Step 8: Adding other content. Once you have the Table content added, be sure to look at the other Content Blocks for the PandaDoc Editor.