Managing SKUs with Salesforce

When an SKU is created in RevOps, an associated Product and Price Book Entry are also created in Salesforce. This ensures that when you connect a RevOps Deal to an Opportunity, RevOps is able to insert Opportunity Products (also known as Opportunity Line Items) to your Opportunity. 

In this guide, we’ll walk through how RevOps synchronizes and enriches SKUs with Salesforce Product and Price Book. As a prerequisite, this guide assumes that you have connected your RevOps account to Salesforce.

 

Configuring your default Price Book

By default, when SKUs are created in RevOps, Price Book Entries will be created in your Standard Price Book. If you navigate to the Price Book tab in your Salesforce setting, you’ll notice that this PricebookID is already configured.

If you prefer to have these Price Book Entries created in a separate Price Book, add that PricebookID in your Salesforce Settings.

Since Salesforce Opportunities can only be associated with one Price Book, we do not recommend creating RevOps SKUs in multiple price books if they are likely to appear on the same deal together. When SKUs of different Price Books are included on the same Deal, RevOps is not able to sync the Line Items of your Deal to your Opportunity. When syncing your Deal to Salesforce, you will notice a "Mixed Price Book Error".

Syncing SKUs to Products and Price Books

When creating an SKU, if you head to the "Salesforce Integration" tab, you'll first notice that the ProductID field is blank and the PricebookID field is populated. Once you’ve clicked “Save”, a Product will be created in Salesforce with a matching Price Book Entry in the listed Price Book.

If this product already exists in Salesforce, you may search for it using the Product ID or Name. 

At any point, you may update the SKU so that the associated ProductID or Price Book Entry is in a different Price Book. When doing so, RevOps will not delete the Product or Price Book Entry in Salesforce. However, a new associated Price Book Entry may be created.

In order to appropriately sync the line items on your order form to an Opportunity, RevOps relies on each SKU to have an associated Product2ID and for that Product2 to be ‘Active’. Please note that if you deactivate any Products within Salesforce or your SKU does not have a matching Product2ID, RevOps is unable to write the line item to your Opportunity. 

SKU Enrichment Mapping

RevOps will use the following properties to create Products and Price Book Entries in your Salesforce account. To enrich any additional custom fields on the Opportunity Line Item, you can add the mapping on your SKU.

Product

RevOps Object

RevOps Property

Salesforce Object

Salesforce Field

SKU

Name

Product2

Name

SKU

Line Item Description

Product2

Description

 

Price Book Entry

RevOps Object

RevOps Property

Salesforce Object

Salesforce Field

SKU

List Price

PriceBookEntry

Unit Price

 

Each time your SKU is updated, RevOps will update the corresponding field on your Product or Price Book Entry. For example, if you update the list price of your SKU, RevOps will update the Unit Price field on your Price Book Entry.

If you create a Scheduled SKU with different list prices across different periods, RevOps will set the price book entry unit price as the average across all periods.

SKU Pricing Models

One of the challenges when dealing with Salesforce Price Book Entries is that Salesforce does not have a standard field to help identify the “pricing schedule” of Subscription Products. Each Price Book Entry simply contains a “Unit Price” field and all prices are assumed to be a single one-time fee. 

However, when selling subscription-based products, products are typically priced on a regular recurring basis for access to the products and services. Each list price is associated with a pricing schedule that represents this recurring price. For example, $79 per unit per month or $2000 per unit per year.

RevOps will only enrich the “Unit Price” field with your SKU’s "List Price" property. However, we recommend that you capture the unit pricing schedule of the Product to distinguish between your recurring revenue and non-recurring revenue as well as products priced at different pricing schedules.

To do this, you'll want to add a Salesforce custom field in your Opportunity Line Item, then map the SKU property `unitPricingSchedule` to that field. It’ll look similar to this:

Since Usage SKUs typically include volume pricing of various quantity tiers, the corresponding Price Book Entry will have a list price of $0 and a Unit Pricing Schedule of Months.

If you are noticing that the Line Items on your Deals are not syncing to Salesforce, it may be because your SKUs do not have an associated Product ID and Price Book Entry. By going to the Salesforce Integration tab on your SKU, you can confirm whether the SKU is associated with a Salesforce Product.

Other Resources