How to Build the Final Price from Several Suppliers

Store supplier prices in separate groups and calculate the final price for exports.

When the same product comes from several suppliers, do not overwrite all prices into one field. Store supplier prices separately and calculate the final price with a rule. This keeps source prices visible, lets you change the strategy, and prepares different exports without losing data.

Price groups in consolidated catalog settings
It is usually best to create a separate price group for each supplier or independent price source.

Price Groups

Prefer creating a separate price group for each supplier. A group can contain several values: purchase price, recommended price, promotional price, or another price type sent by that supplier.

  • Price group describes the source or owner of the price: supplier, branch, price list, sales channel.
  • Price inside the group describes the value type: purchase, retail, promo, incoming price.
  • Priority helps select a price when the rule uses group or price-type order.

Final Price Rules

A final price rule decides which price will be used next: in the product card, export, partner file, or marketplace template. Rules can be configured separately for products and offers.

Final price rule list
The list shows active rules and the strategy they use to calculate the price.

What the Rule Defines

  • Application scope. Choose what the rule applies to and which price groups participate in calculation.
  • Scenario. Choose minimum, maximum, average, first available by priority, or a custom calculation.
  • Adjustments. Add markup, discount, rounding, or protection against incorrect values when needed.
  • Rule priority. If there are several rules, priority defines their order.
Final price rule configured by supplier groups
The rule selects price groups and the calculation scenario.

Calculation Example

SupplierIncoming priceWhat the rule does
Supplier A10.00participates in the calculation as a price from its group
Supplier B9.40can become the final price with the minimum-price scenario
Supplier C10.50remains available for other rules or analysis

If you choose the minimum-price scenario, the final value is the lowest matching price from selected groups. If a stable supplier matters more, use the first available price by group priority.