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)