Glossary (Price Setting)

This glossary summarizes various terms used in Price Setting Accelerator.

Core Terms

Term

Description

Term

Description

Pricing Levels
Price Setting Levels
Pricing Structure
Dependency Structure
Dependency Configuration

You can calculate product prices on more levels, e.g. 1) Global 2) Regions 3) Countries 4) Shop.

The prices on lower levels can depend on prices from higher levels, i.e. the lower level price can be derived from the higher level price.

Prices for various Pricing Levels are then calculated in separate price grids/lists.

The various pricing levels and their dependencies are also referred to as Price Setting Levels, Pricing Structure, Dependency Structure, or Dependency Configuration.

The word “Dependency” is sometimes used in the meaning of “Level”, e.g. in the term “Dependency Mapping”.

Product Segmentation
Segmented Product Portfolio
Product Attribute Hierarchy

The various pricing factors (e.g. margin uplift in the Cost+ method) can depend not only on the Pricing Levels, but also on a combination of several product attributes, e.g. Industry, Business Unit, Product Group.

Those product attributes are not necessarily hierarchical, but for the definition of the pricing factors it is very useful (and needed) to have them in certain order.

A certain combination of values of those product attributes is known as a product segment. The product segment can be either very narrow (e.g. products with industry A, business unit B, product group C), but also more broad (e.g. products with industry A, business unit “any”, product group “any”).

Dependency Mapping

Technique how to find data relevant for certain Pricing Level (Dependency).

Data for different Levels can be stored either in separate tables, for example: a separate table for each country (this is called “Table”), or together in a single table where one field is dedicated to distinguishing which row belongs to each Level (this is called “Lookup”), or together in a single table without any differentiation to which level each row belong (this is called “None”).

Additional Terms

Terms

Description

Actual Price Lookup

Lookup for the current product price which is fetched based on the configuration.

Adjusted Price Corridor

Deviation between the global adjusted price and the final list price

Allow Manual Price Override

Defines whether the ManualPrice and ManualPriceReason elements should be visible.

Allow Manual Strategy Override

Defines whether the PriceSelector element should be visible.

Base Currency

Currency of the price list/grid.

Base Strategies

Ordered list of base strategies that precede normal price strategies.

Base Strategies are usually defined on a more generic level to have some basic pricing rules across the complete product portfolio.

They are used, for example, to make promotions override the standard strategy configuration.

Calculated Prices

Calculated prices for every defined strategy.

Changes From Monitor

If isPLCMTarget is true, it contains ResultMatrix describing to the user why this element was added to the price grid. Currently supported only for Global LPGs.

Competition Data

Data about competitors' pricing, read from the PCOMP table. 

Cost

Cost of the product, read from the PX configured in the "PriceSettingConfig" PP. If not found, null is returned.

Country

Country for which the current calculation runs. If Global mode is used, the country will be "Global". If Headquarter mode is used, a value configured in the "PriceSettingConfig" PP will be used. Otherwise, the country has to be selected from a drop-down list in a given PL/LPG configuration. A list of available countries will be created dynamically based on the "CountryInformation" PP.

Country Adjustment

Percentage by which global prices will be multiplied to obtain local prices.

Country Lookup

Row from the "CountryInformation" PP.

Discount

Percentage discount applied when calculating the transition from a gross to net price.

Discount Group

Discount group for a specific product in a specific country.

Exceptions

Message with exceptions (if any). The value will be:
Price Exception: <value>
Strategy Exception: <value>
Price Exception: <value> (+1) – if both exceptions are present

Exceptions Manager

Interface used for managing exceptions / manual overrides and making them allowed. Exceptions/Allowance logic is implemented here.

Exchange Rate

Exchange rate between global and current local currencies.

Final List Price

Value copied from used list price. This is the price before applying a discount.

Final Price

Used list price in case of a gross calculation; net price in case of a gross/net calculation.

Forecast Data

Cached map with forecast data for every product. It is calculated based on the PP configuration.

Global Adjusted Price

Final price from the global price list, adjusted with the country adjustment.

Global Calculated Item

Calculation result for the product on the global level.

Global Currency

Currency of the headquarter country or global price list. The data is loaded from the "CountryInformation" PP.

Global Decision

Decision extracted from a Global Calculated Item. It can be a strategy name, an exception table type message or a manual reason.

Global Level Adjusted Prices

Prices from the global price list, adjusted with the country adjustment.

Global Min Price

Minimum price read from a PX checked against final price. (coming soon)

Global Price

Price from the global calculation result extracted from a Global Calculated Item, after applying exchange rates.

Last Year Sales Volume

Volume from last year.

Last Year Turnover

Turnover from last year.

List Price Corridor

Deviation between the global price and final list price

Lookup Keys

Keys in the format Map<String, List<String>> where the key is a dimension and a List is a sorted list of keys (dimensions) for hierarchical lookups. Currently, only the Product dimension is supported.

Manual Price

Empty field acting as an input field for the user. Fill it with an override price if necessary. Its visibility depends on the configuration in Exceptions Manager. This value pops up automatically if there is an ExceptionsTable price exception.

Manual Price Reason

Empty field acting as an input field for the user. Fill it with a reason why a price has been overridden. Its visibility depends on the configuration in ExceptionsManager. If there is an ExceptionsTable price exception, the value is "Price Exception".

Margin

Margin calculated based on the final price and product cost.

MinimumMargin

Minimum margin for a specific product checked against “Margin”.

Net Price

Used list price with a discount applied.

Net Price Level

Indicates if a net price will be calculated.

OverrideRemover

Used for clearing manual/table overrides/exceptions when the default strategy does not allow it.

Pop Up Data

Calculates margin values for a popup data input.

Price Decision

Reason for a given price. ManualPriceReason if the price was overridden; a pricing strategy from Price Selector otherwise. If there was an ExceptionsTable exception, the value is "ExceptionTable - <exception type>".

Prices

PopUpData formatted into a user friendly MatrixResult.

Price Selector

Combo box with calculated prices and their strategies. Users can override a default strategy here.

Prices Summary

Generates data for a popup and price selector. It also collects prices from the global price list and applies a country adjustment to it. 

Price Strategies

Ordered list of possible pricing strategies for the current product, read from the "StrategySelection" PP.

Sales Volume Forecast

Volume forecast for the upcoming period with values taken from the specific strategy set on the PriceSettingConfig PP.

Sales Volume YTD

Volume from this year.

Strategy Selection Entry

Lookup result from the "StrategySelection" PP. It is only in the country price list because only there more than one element can utilize this result.

Transaction Data

Cached map with transaction data for every product. It is split into the last year and year to date results.

Turnover Forecast

Turnover forecast for the upcoming period with values taken from the specific strategy set on the PriceSettingConfig PP.

Turnover YTD

Turnover from this year.

Used List Price

Value selected in PriceSelector or inserted in ManualPrice.

Warnings

User friendly table showing all warnings which occurred during the calculation.