Salesforce: Pricebooks

Do you use our Salesforce integration? Using our integration, you'll be able to automatically pull Pricebook items into your Quotes!

In this article:

• Creating an Opportunity template
• Adding the Products Variable
• Filtering the Products display
• Pulling products into your Qwilr Page

Creating an Opportunity template

To use this part of our integration, you'll need to have Price Book items associated with an Opportunity record in your Salesforce account. You'll find details on this process in the Salesforce docs.

Step 1. In your Qwilr account, create a page that you'll use as your template.

Step 2. Now let's convert that page to a template. Head to the top right corner and click the Make template button. Then click the button to confirm.

Step 3. Now, head back to the top right corner, and click on the Variables icon. Then click the CRM tab, and then Add to CRM to confirm.

Step 4. Enable the Use in Salesforce switch, and then choose Opportunity as the object. Click Confirm.

And that's it! When you click the Variables icon again, you'll now see the list of available Opportunity record Variables.

Adding the Products Variable

If your Salesforce account is enabled for Price Books, you'll now see a Products Variable in the Variables list. This single Variable will pull in all your product details from Salesforce.

Depending on your Quote widget(s) in your template, there are a couple of locations where you can place this Variable:

• In a Plan card
• In a Table section

Adding the Variable to a Plan card

This option is great if you have subscription or recurring pricing plans set up in in your Price Book.

Step 1. Start by adding a Quote Plan card section widget to your Qwilr Template. Do this by clicking on the widget menu '+' in the content of a block or use the Block adding mechanism with the center '+' sign to start a Quote block off with plan cards.

Step 2. A blank plan card will appear inside the widget. We will delete this plan card later. Right now, click on the '+' symbol beside the plan card and select Salesforce Products.

Step 3.  You should now see a Plan card section in your Quote widget to appears like the image below.

Step 4. See the section past the next section for filtering rules with products variables.

Adding the Variable to a Table section

This option is great for products that are set up with a One-Time price in Salesforce.

Step 1. Add a Quote widget to your template. Select the Quote section under Pricing in the widget list to get a Quote table widget.

Step 2. Add a new Line item use the '+' symbol at the bottom of the Quote table widget and the select Salesforce Products.

Step 3. This table section also contains a default empty line, which you won't need. Delete that by clicking on the line for the context editor to come up and click on the trash can icon to delete the extra line. You should now have a Quote table widget that looks like this.

Step 4. See the section below on filtering this display. 

Filtering the Products display

Whichever way you add the Products Variable to your quote, it's set by default to pull in all of the products you have attached to an Opportunity record. You can see that default filter above the Variable.

There might be cases, however, where you want only some of the associated products to pull in. For that, you can open the filter and choose a criteria.

This filter is especially useful if you're using a combination of Plan cards widgets and Quote table sections in your quote. By setting a filter for each area, you can pull different products into different areas of the quote.

The filter options are as follows:

• Display all
• Description
• Line item ID
• Name
• ProductCode
• Quantity
• Sales Price

Once you select one of this options, the Display products if menu allows you to set rules.

Those rules are:

• is
• is not
• includes
• does not include
• starts with
• does not start with

Pulling products into your Qwilr Page

In your Salesforce account, take these steps.

Step 1. Locate the Opportunity record you want to create a Qwilr page from. 

Step 2. Make sure you have one or more Product line items associated with this Opportunity, and you've entered a quantity for each product. 

Step 3. Locate the Qwilr widget. Click the Create Qwilr button, then select the Opportunity template you just created.

In the new Qwilr page, the Quote widgets will automatically list products wherever there's a Products Variable, using the filter you've set for each instance.

If you need any help, feel free to email help@qwilr.com.