Salesforce CPQ Data Model: A Complete Guide

Quote

• The central object that represents a proposal given to a customer.
• It is linked to an Opportunity and contains all relevant quote lines, pricing, and customer-specific details.

Quote Line

• Represents individual items on a quote.
• Each line corresponds to a specific product, quantity, and price.

Product

• Defines what can be sold.
• Products can be simple (standalone) or part of complex bundles.

Price Book and Price Book Entry

• Price Books define different pricing contexts (e.g., standard, partner pricing).
• Price Book Entry links a product to a specific Price Book with a list price.

Product Options and Product Features

• Used in bundle configurations.
• Options represent choices within a bundle; Features group these options logically.

Configuration Attributes

• Capture additional user inputs during product configuration (e.g., color, size).

Quote Line Group

Allows grouping of quote lines for better organization, often used in complex proposals.

• Quote → Quote Line (Master-Detail): One Quote can have multiple Quote Lines.
• Quote Line → Product (Lookup): Each line item is tied to a specific product.
• Quote → Opportunity (Lookup): A quote is typically linked to a sales opportunity.
• Product → Price Book Entry (Lookup): Each product must be in a Price Book to be used in quotes.
• Product Bundle → Product Options (Lookup): Complex product bundles reference various options.

• They select an Opportunity.
• Add a Quote linked to that Opportunity.
• Choose products (like licenses, support packages).
• Each product appears as a Quote Line.
• The pricing is fetched from the Price Book.
• The final Quote is shared with the customer.

• Product Rules

  • Used to enforce logic during product configuration.
  • Types include Validation Rules, Selection Rules, and Alert Rules.
  • Example: If Product A is selected, automatically add Product B.

• Price Rules

  • Dynamically modify pricing fields on the quote or quote line.
  • Useful for volume-based pricing, discounts, or special conditions.

• Constraint Rules

  • Limit or require certain product options based on user selections.
  • Example: If a customer selects a high-end server, certain accessories become mandatory.

• Sales reps use CPQ to configure custom software bundles for enterprise clients.
• Product Rules ensure only compatible modules are selected.
• Price Rules adjust pricing based on the number of users.
• Quotes are generated and sent out quickly, reducing sales cycle time.
• Upon approval, quotes convert directly to Orders and Contracts, feeding into billing.