Improved pricing computation performance by using flattened discount tables
Important
This content is archived and is not being updated. For the latest documentation, go to What's new and planned in Dynamics 365 Commerce. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.
| Enabled for | Public preview | General availability |
|---|---|---|
| Users by admins, makers, or analysts | 
Oct 8, 2021 |
Dec 31, 2021 |
Business value
The performance of the pricing engine is a critical factor to the overall performance of a retailer’s transaction workflows. The ability to find applicable discounts and compute prices in a performant manner can significantly contribute to revenue boost, profit margin growth, and an increase of customer lifetime value.
Feature details
This feature optimizes the discount publishing and lookup procedures of the Dynamics 365 Commerce pricing engine by leveraging flattened data schema. With this feature enabled, discount data configured in Commerce headquarters is denormalized before it's sent to channel databases. The publishing of flattened discount data occurs automatically when a discount is enabled. This process helps achieve faster discount lookup and computation at runtime.
See also
Retail discounts (docs)