Salesforce. Map pricing table columns with fields

Avatar
Eugenia Brown
  • Updated

Availability: Business Annual* and Enterprise Annual* plans

* The integration with Salesforce is a paid add-on.

Skip to:

Besides mapping specific products to pricing tables or pricing table sections, you can also match opportunity product fields with specific pricing table columns.

You can also filter products from Salesforce and map them to specific pricing table and pricing table sections. Open this page to find out how.

Enable column mapping

Open a template that you use to create documents from Salesforce. First, find a pricing table you’d like to set column mapping for, or add a new one. Next, access the data merge either in pricing table settings on the right, or below the pricing table by clicking on +Product > Set up data merge from CRM/API. Finally, click Enable.

Enable_data_merge.pngEnable_data_merge_1.png

Set up column mapping

In the data merge pop-up, select Column mapping. 

Select_column_mapping.png

Next, below the Column mapping heading, enter the field names from Salesforce (on the left) to be matched with pricing table columns names (on the right).

Enter_a_field_name_from_Salesforce.png

The Salesforce field name can be any of the default opportunity product field names — Name, Description, Price, SKU, QTY, Discount, Tax, or Tax1 — and it’s crucial that you spell the name exactly as it’s spelled here.

The field name can also be any other opportunity product field; if so, it’s important that you enter the correct name in PandaDoc. Here’s how:

  1. Go to Salesforce and open PandaDoc Setup.
  2. Find the Configure tokens button, then click on it.
  3. At the top, select Opportunity Product. You’ll find the correct field highlighted in yellow on the right. Make sure you use it without square brackets.
  4. On the left, select the checkboxes of the fields that need to be added to the pricing table. Finally, click Save on the right.
PandaDoc_setup.pngConfigure_tokens.pngCopy_the_field_name_from_Salesforce.pngmceclip0.png

If you’d like to map more pricing table columns, start by adding them to the pricing table by clicking the plus sign on the right side. 

Then, access the data merge rules via Column mapping. You’ll see the newly added columns on the right. Now enter the field name from Salesforce on the left.

Add_a_new_column.pngNewly_added_column.pngAdded_column_in_column_mapping.png

After the column mapping has been set up, you will see the Salesforce fields under the corresponding columns highlighted in blue.

Blue_placeholders.png

And that’s it! Whenever you create a document from Salesforce using this template, the product fields will populate to the corresponding columns.

Related articles