Product Bundle

Volume pricing is very handy and solves the problem of pricing based on quantity but in more complex scenario, the pricing can be based on more than just the quantity & it can be dependent on multiple attributes of a product. For example, when ordering pizza, the final price is based on the ingredients (attribute) the customer chooses. Other example is car sales where sales agent creates 2 quotes for same make and model – leather upholstery (attribute) increases net sales by $2,000 and other quote with plush interior increases net sales by $700.

Idea of attribute pricing is you can add attributes to products that affect the final product price. In below screenshot, Kilowatts is custom field (attribute) and pricing of the product is based on the electrical power. With attribute pricing, you can get rid of redundant products – GenWatt Diesel – 10KW, GenWatt Diesel – 200KW, GenWatt Diesel – 300KW and have just one base product “GenWatt Diese” and derive pricing based on “electrical power”

Attribute Pricing is a 2 step process:

• Step 1 – Attribute Pricing
  • Click on Attribute Pricing tab & click New 
  • Enter “user friendly” label that end users will see on matching attribute
  • Choose Field Name – Discount or Sale Price depending on what needs to be adjusted
  • Enter Field Value that will be applied to field selected above
  • Optionally select product if this rule is for a specific product. Keep it blank if the rule applies to all the products
  • For most cases Order can be 1, so enter 1 and click Save
• Step 2 – Attribute Value
  • Go to Attribute Value related list for the record created above and click New 
  • Attribute Name is the field API name of the attribute which will affect the value defined in step above. For example, if you have “Kilo Watts” field on Opportunity Product with API name “Kilowatts__c”, then enter “Kilowatts__c”
  • Attribute Value is the value for which the rule should be fired. For example, continuing with above example, if  “Kilo Watts” was picklist with values – 10KW, 100KW, 1000KW. Enter one of those value.
  • If you entered multiple Attribute Name-Value pairs, then each one of those must be matched for the rule to fire. For example, in below screenshot the Sale Price of 220,000 is applied to “GenWatt Disel 1000kW” product only if Rep selects KiloWatt__c: 10KW and Color: Red

Note:

You can use Dataloader to mass insert attribute pricing information.