When is a single price book appropriate?
At least one price book must be configured and active in order to add products to either an opportunity or a quote.
When are multiple price books appropriate?
The use of multiple price books will allow organizations to price products independently for different groups of customers.
[toggle title_open=”Close Example” title_closed=”Open Example” hide=”yes” border=”yes” style=”default” excerpt_length=”0″ read_more_text=”Read More” read_less_text=”Read Less” include_excerpt_html=”no”]My organization sells a number of different products to individual consumers, enterprise, and SMB customers. The standard sale price of each product for individuals is MSRP, while Enterprise and SMB customers are offered lower pricing on some products.
For instance, the product “Generator X90” has an MSRP of $90,000. However, Enterprise customers are expected to pay $60,000, while SMB customers pay $80,000.
Another product “Generator Accessory A” has an MSRP of $5,000. Enterprise customers pay $4,800, while SMB customers pay the MSRP of $5,000.
Generator X90 MSRP: $90,000.
Enterprise Price: $60,000. Discount from MSRP: 33%
SMB Pricing: $80,000. Discount from MSRP: 11%
Generator Accessory A MSRP: $5,000.
Enterprise Price: $4,800. Discount from MSRP: 4%
SMB Price: $5,000. Discount from MSRP: 0%
In this scenario I would create 3 price books:
- MSRP (using default prices)
- Enterprise
- SMB[/toggle]
How can you determine which price books are assigned to a user?
By default, the org-wide default setting for price book is “Use”. This means that any user with read access to both the “Product” and “Price Book” object will be able to select any active price book.
How can I restrict visibility/use to certain price books?
1. Set the org-wide default for price book to “View Only” or “No Access”.
2. Share each individual price book with the appropriate role, group, and users.
How are price books selected?
If only a single price book is active, or the user only has “Use” permissions to a single price book, then that price book is automatically selected.
If the user has “Use” access to more than one active price book, then they must manually select the price book prior to adding products to an opportunity or a quote.
Important Note:
- The products object does not use the standard record sharing model. Access to manipulate products is controlled by object-level security (profile & permission sets).
Is there a way to grant access to pricebook using the SOAP api?
Sharing can be facilitated through the API, yes
Hi John, i so far did not come across any way to have SF used to do sales & service for recurring products like telephone subscriptions etc. Pricing also don’t seem to support recurring price type.
Am I missing something or it is a different licence product that I need to go for.
Regds
Nikhil
Typically a CPQ product is used to model more complex pricing and product modules (e.g. bundles)
While assigning Pricebook to product , will the standard pricebook be assigned automatically to product if no pricebook is selected.
No – you need to assign a price book. To auto assign one, you can use process builder.
Hi John,
Thank you for this chapter.
Did I understand it correctly that sharing when OWD is most restrictive:
Price Book – can be done only by using the ‘sharing’ button (by user with Edit rights or Admin)
Product – is done via permission set, profile
Thank you,
Gil
Both products and price books have object-level security controls at the profile/permission set. The big difference is that you can’t set record-level permission on products, and record-level permissions on the price book are only set through manual sharing (no sharing rules). Hope that clarifies!
Hi John,
in your statment – The products object does not use the standard record sharing model. Access to manipulate products is controlled by object-level security (profile & permission sets).
Does that mean Product does not have a share button as price books have? Products can be accessed only through profile settings?
Yes Vijay. On the product detail view, there is no sharing button. So providing access to view/ update products has to be via profile or permission sets.
Hi John..
Can we have duplicate products in price books?
can we have same products with different currencies in single price book?
To set up different prices, you would use different price books. E.g. USD Price Book, EUR Price Book
hi John, I have question like
What if i have more then one price book …and i want to set each one with different security level as view only or use .
Like
Price book 1- No access
Price book-2 -no access
price book 3 – Use/Active
Can i do that at OWD settings…i m confuse..as owd only working for standard object …not on record?
or what other privacy settings i need to do to achieve this ..?
No, you would set the OWD to No Access and then share out the individual price books.
https://help.salesforce.com/apex/HTViewHelpDoc?id=products_sharing.htm&language=en
Can you do multiple currencies in pricebooks?
Yes – typically you would want the price established in each currency for each product sold. You also need to factor in the corporate currency and opportunity currency. This article might help: https://success.salesforce.com/answers?id=90630000000gzoCAAQ
Throughout the discussion of using price books, quotes and opportunities are the only objects mentioned. We have a custom object “Parts” (the detail in a master-detail relationship) that tracks the use of parts that we use for repairs, then totals up the costs in a roll-up summary field to its parent object. It seems (based on the beginnings of experimentation) that we could create multiple lookups between Parts and Products objects to bring data from the Products object into the Parts object. Yes? Or am I missing/misunderstanding something? Thanks!
Yes, I think so from your description – would need to understand your org better to say for sure.
Knowing that it might be possible makes helps. So, thanks again!
Hello John,
I am looking for the answer of this question. We have a price book entry for a product in standard price book and a different price book entry for the same product in a custom price book. If we delete the price book entry in the standard price book, what will happen to the price book entry in the custom price book?
The product has to have a standard price – that price is not associated with any price book. When create a price for a specific price book you can specify the price or use the standard price.
If you have a standard price book entry (using the standard price) and a custom price book using a specified price, there is no impact to the custom price book entry if you delete the standard price book entry (a standard price still exists, but is ignored). If that doesn’t make sense, I would test it out in a dev org- hard to explain but fairly straightforward.
Hi John,
I tried deleting the standard price book entry for a product that is also associated to another custom price book. I got a warning below:
Your attempt to delete XXXX Product (Standard Price Book) could not be completed because it is still associated with records in other price books. These records are shown below
Click OK to continue and also delete the records shown or Cancel to return to the previous page.
I think this means deleting a standard price book entry does have impact on custom price book entries for the same product, right?
Let’s say I want to use products from multiple pricebooks for an opportunity. Will I need to add these products manually since I can’t use multiple products from different pricebooks?
You cannot choose more than one price book – I’m not sure exactly how that scenario would play out but yes there would be some additional manual steps or perhaps customization that would need to occur.
I can’t find the org-wide default settings. Where should I look?
Security Controls –> Sharing Settings
Hi John
The OWD on price book is ‘USE’ . users under a specific profile is unable to access the opportunity products when creating an opportunity and gets the error” insufficient privilege access to perform this operation” . We have multi-currency org. Products were created and added to pricebook in all the currencies and opportunity line item table were uploaded with the correct currency code.
Don’t understand where i’m missing and try to fix this.
Appreciate your help! Thank you very much in advance!
Does the user have access to edit the opportunity they are adding products to?
“Generator X90 MSRP: $90,000.
Enterprise Price: $60,000. Discount from MSRP: 33%
SMB Pricing: $80,000. Discount from MSRP: 11%”
—> how do you set those discounts?
The standard price (MSRP) is established on the product, then Enterprise and SMB prices are established via separate price books.
Any idea why Products don’t support Record Types? Seems logical, e.g. for product and service companies, to have different picklist values and layouts (e.g. service might have an associated geographical area).
Thanks for pointing this out – products now support record types. However, the standard security policies do not apply (I believe this has to do with reducing processing time for security).