I had a hard time finding comprehensive instructions on how to properly manage pricing when it comes to Product Bundles in Microsoft Dynamics CRM. I wanted to associate products to one bundle so multiple products could be added to an Opportunity (Quote or Order), minimizing the steps it takes to add multiple products to an Opportunity. BUT, I also wanted each of the line items to reflect their own individual price once added to the Opportunity, AND I also needed those prices to be editable.
I found the information below from Microsoft on this subject, but this seemed a little vague as I was still struggling with how to get those Opportunity products to show their own individual pricing.
Here’s what I found:
When working with Bundle Products in Microsoft Dynamics, you have two ways of managing the pricing of that Bundle:
- Create a total price for the Bundled Product which reflects as one overall price – The line items under that bundle reflect as $0.00 within the Opportunity and the Estimated Revenue is calculated off of the one total price.
- Create a price for each of the products associated with the bundle – The line items under that bundle reflect the price within the Price List you are using for that Opportunity. The Opportunity Estimated Revenue is calculated by adding up the prices for each price list item.
The above is controlled by the “Required” field setting within the Bundle product association. When you are adding “Bundle Products” within the Bundle form, the below product association form populates.
- If you set the Required field to “Required”, that product within the bundle will reflect as $0.00, when adding to an Opportunity (Quote or Order).
- If you set the Required field to “Optional”, that product within the bundle will reflect the price set in the associated price list, when adding to an Opportunity (Quote or Order).
In this example, I created a Bundle with one total in the Price List and listed the associated Bundle Products as Required.
- Create the Bundle by clicking “Add Bundle” in the Products area of CRM.
- Click the + sign in the Bundle Products area of the form to add the products you want to bundle.
- Add the Products you want to include in your bundle. Keep the Required field set to “Required”.
- You should now see all the products you added in the Bundle Products area of the form.
- Next, associate this bundle with at least one Price List by clicking the + sign in the Additional Details area of the form.
- Give the bundle an Amount value.
- Make sure to publish your Bundle Product so it can be associated to other records.
- Once the Bundle is added to the products area of an Opportunity, this is how the data will display. Note how the actual products reflect $0.00 for the price, even though they have prices within the “abc” pricelist associated.
Note – The Bundle Products do not HAVE to be associated to the same Price List as the Bundle in order for them to be added to the Bundle. Additionally, only the Bundle product HAS to be a part of the Price List associated to the Opportunity in order for that Bundle to be added as an Opportunity Product.
In this example, I created a Bundle with it’s own price in the Price List and I listed the associated Bundle Products as Optional.
- Follow the first couple steps same as above, BUT when you add Products to the Bundle, set them as Optional.
- When you add the Bundle to a Price List, set the dollar value as $0.00.
Note – You can also include a price for the whole Bundle, but in this example I am not.
- If the individual Products within the Bundle are all part of the same Price List as the Opportunity and Bundle, then the price within the price list is pulled for those items. Note – If I added a dollar amount for the Bundle Product itself, when adding it to the “abc” Price List, the total of the Opportunity Estimated Revenue would include all 3 line item values.
- If the individual Products within the Bundle are NOT all part of the same Price List as the Opportunity and Bundle, then the Product missing from the associated Price List will have $0.00 as the dollar value.
Hopefully this provides some more details surrounding Bundles and Bundle pricing. Happy CRMing!
By Jessica Carsten, Dynamics CRM Application Consultant, xRM³, Microsoft Partner focused exclusively on service, support and education of Dynamics CRM, San Diego, Southern California. Contact us to get help regarding Bundle pricing or any aspect of Dynamics CRM.