Price Calculation Setup (Reference)
The heart of the configuration: each line represents one sales price list the engine maintains — typically one per sales channel (SHOP, AMAZON, EBAY, B2B …). Open the list by searching for Price Calculation Setup or from the setup card.
Live example price
The column Example Price (Cost 100.00) shows per line which sales price 100 of cost would produce — margin formula and rounding become tangible at a glance, without starting a run.
Basics
| Field | Meaning |
|---|---|
| Price List Code | Code of the BC sales price list; if it does not exist yet, the engine creates it with the first price |
| Enabled | Only enabled lines are calculated |
| Source No. | Optional: customer price group of the list |
| Cost Source | Best Supplier Offer (default) · Item Unit Cost · Purchase Price List — the two BC sources work without any supplier connector |
| Item Filter | Limits the items of this list (e.g. 1000..1999\|A*); items outside are skipped with "No Offer" |
| Vendor Filter | Restricts the offer or purchase-line selection to certain vendors |
| Prefer Offers in Stock | The cheapest offer with stock wins; when no vendor has stock, the item is still priced — on the cheapest remaining offer, marked as Priced Without Stock. Suppliers that report no stock count as deliverable (default: on; Best Supplier Offer source only) |
| Coverage Quantity | Quantity the list must be able to procure at its cost basis — the price rests on the offer that covers this quantity, not on the cheapest one (0 = off; Best Supplier Offer source only) → Coverage quantity |
The three cost sources
| Cost source | Cost basis | Note |
|---|---|---|
| Best Supplier Offer | cheapest hub offer, shaped by the supplier cost conditions — with a coverage quantity the cheapest at which that quantity can be procured | platform default |
| Item Unit Cost | unit cost of the item card | no vendor; conditions are not applied |
| Purchase Price List | lowest active BC purchase line (minimum quantity ≤ 1, valid today) | its vendor feeds the margin hierarchy |
With the BC sources, the stock-driven margin judges your own inventory instead of the supplier sum, and the list price cap stays inactive without supplier list prices.
Coverage quantity
The cheapest offer is only a price if the item can be bought there in the quantity the channel sells. Typical case: a vendor has not yet passed on a price increase and offers its last unit at the old price. Without a coverage quantity, that single unit sets the price for the whole channel — from the second unit ordered on, you sell below cost.
With a coverage quantity, the offer selection counts the offers from the lowest cost basis upward and takes the offer whose stock, together with that of all cheaper offers, reaches the quantity:
| Coverage quantity 10 | Stock | Cost | Result |
|---|---|---|---|
| Vendor A (old price) | 1 | 1,750.00 | too little stock |
| Vendor B | 192 | 2,022.00 | cost basis |
- The price rests on the offer that completes the quantity — not an average. An average would still sell the tenth unit below what it costs.
- Stock adds up: A with 4, B with 4 and C with 4 units reach 10 only at C — C carries the price.
- If the cheapest offer covers the quantity on its own, it stays the cost basis. The coverage quantity only makes a price dearer where the stock demands it.
- Suppliers without stock reporting (flag Stock Not Reported, e.g. manufacturer price lists) cover any quantity.
- Offers without stock never count — whether or not Prefer Offers in Stock is set.
- If all offers together hold less than the quantity, the price rests on the dearest offer in stock. If nothing is in stock at all, the cheapest offer applies as without a coverage quantity, marked as Priced Without Stock. An item never ends up without a price.
The price explanation shows in the offer comparison which offer covers the quantity, and for cheaper offers that they lost on stock. When a vendor's stock changes, the item is recalculated.
Which quantity?
Go by the typical order quantity of the channel: 1 for channels selling single units, 5–10 for your own shop, the largest quantity tier for B2B lists. After a change, run Recalculate Prices — the field alone does not start a run.
Coverage quantity or vendor filter?
The Vendor Filter excludes a vendor permanently — even when it really is the cheapest. The coverage quantity decides anew with every calculation, based on stock. You only need the filter for vendors that never qualify for this channel.
Margin
| Field | Meaning |
|---|---|
| Margin Formula | Trade Margin: price = cost ÷ (1 − margin %) · Markup: price = cost × (1 + margin %) |
| Margin % | Default margin of the list; overridden by the category margins |
| Min. Margin % / Min. Margin Amount | Floors that are never undercut per item — not even by competitor adjustments |
Switching the margin formula
Both formulas describe the same price with different numbers: 20 % trade margin = 25 % markup — a cost of 100 becomes 125 either way. Switching the formula of an existing list therefore asks two questions:
- Convert the percentages so the prices stay the same? (default: Yes) — converted are the list's Margin % and Min. Margin %, all category margins (Margin %, Min. Margin %) and all margin tiers of the list. Internally with 5 decimals, displayed with 2 — so even large prices stay the same to the cent. With No the percentages stay, are read the new way, and the prices change.
- Recalculate all items of this list now? — right away if you like, together with every enabled list derived from it (chain via Base Price List Code, base first), with one combined result message.
| Not converted | Why |
|---|---|
| Safety Min Markup % | is always a markup, whatever the formula |
| Competitor Min. Margin % | is always a trade margin |
| High/low stock adjustments | are margin points on whichever margin applies — there is no fixed counterpart |
A trade margin of 100 % or more blocks the switch
A trade margin of 100 % or more has no price. If such a value sits on the list, a category margin or the margin tiers, the conversion is refused — as is a switch to trade margin with No that would produce such a value. The message names the affected row.
Converting requires write permission on category margins and margin tiers (the Price Engine Admin permission set). The cockpit view Below minimum margin also reads the Min. Margin % through the list's formula — on markup lists as a markup on cost.
Gross, VAT, and currency
| Field | Meaning |
|---|---|
| Prices Including VAT | B2C lists calculate gross: VAT per item is added before fees, rounding and competitor steps — 99.99 really means 99.99 including VAT |
| VAT Bus. Posting Gr. (Price) | Posting group used to determine the VAT rate per item |
| Currency Code | Foreign-currency lists: calculated in local currency, converted at the current rate — without a rate on file no price is published |
Rounding and cap
| Field | Meaning |
|---|---|
| Rounding Method | Commercial, to .99/.95/.90, whole amounts — or Price Points from your own tier table (action Price Points) |
| Use List Price as Max | Never above the lowest supplier list price (compared gross on gross lists, converted on currency lists) |
Safety limits
If a price violates a limit it is rejected instead of published — the old price stays, the log names the reason.
| Field | Meaning |
|---|---|
| Min. Price | absolute floor |
| Safety Max Change % | largest allowed change vs. the current price — the guard against supplier data errors |
| Safety Min Markup % | minimum markup on the cost (compared net) |
| Safety Min Contribution | "never below x per unit" (compared net) |
Smoothing, approval, derivation, stock
| Field | Meaning |
|---|---|
| Min. Price Change % | Hysteresis: smaller changes are suppressed — no price flapping on the channel |
| Force Update After (Days) | after that many days even a small drift is published |
| Approval Threshold % | larger changes park as proposals in the price approvals instead of going live (0 = off) |
| Base Price List Code / Base Price Adjustment % | Channel derivation: "eBay = Shop + 5 %" — margin and offer selection are skipped, every check still applies |
| High/Low stock thresholds and adjustments | Stock-driven margin: overstock lowers, scarcity raises the margin — the margin floors remain the last word |
The competitor fields (strategy, offset, corridor, governance) are described in Repricing.
Actions
| Action | Effect |
|---|---|
| Recalculate Prices | Full run for the selected list (with progress and result summary) |
| Recalculate All | Full run for every enabled list |
| Price Points / Quantity Tiers | Rounding tiers and B2B quantity discounts of the selected list |
| Category Margins / Supplier Cost Setup / Marketplace Fees | the rule tables in direct access |
| Simulation / Price Approvals | dry run and approval workbench |