Variants Prices Queries

Access variant-specific pricing across price levels.

VariantPrice — Returns a single variant price by id

GraphQL

query GetVariantPrice($id: ID!) {
  VariantPrice(id: $id) {
    id
    amount
    currency { id label }
    company_id
    variant { id label }
    priceable {
      ... on Customer { id label }
      ... on Supplier { id label }
      ... on PriceLevel { id label }
    }
    priceable_type
  }
}

VariantPrices — Returns a list of variant prices with sorting, filters, and search

GraphQL

query VariantPrices(
  $where: QueryVariantPricesWhereWhereConditions,
  $orderBy: [QueryVariantPricesOrderByOrderByClause!],
  $search: String,
  $first: Int,
  $page: Int
) {
  VariantPrices(
    where: $where,
    orderBy: $orderBy,
    search: $search,
    first: $first,
    page: $page
  ) {
    paginatorInfo {
      total
      currentPage
    }
    data {
      id
      amount
      currency { id label }
      priceable_type
    }
  }
}

---

SimulateVariantPrice — Simulates the selling price of a variant

Computes the price a variant would get in a given context (customer or price level, quantity, date, currency) without creating or changing anything. Useful to preview price rules and discount rules before quoting.

Parameters:

Parameter	Type	Description
input	SimulateVariantPriceInput!	Simulation context.

Example Query:

GraphQL

query SimulateVariantPrice($input: SimulateVariantPriceInput!) {
  SimulateVariantPrice(input: $input) {
    variant_id
    customer_label
    resolved_price_level_label
    currency
    quantity
    base_unit_price
    net_unit_price
    net_line_total
    computed_from_components
    exclude_from_discount_rules
    steps { step_key applied status rule_label unit_price discount_amount discount_percentage }
    quantity_tiers { from_quantity rule_label discount_amount discount_percentage net_unit_price is_current_quantity }
  }
}

Return Type	Description
SimulatedVariantPrice	The simulated price and the steps that produced it.

---

Available fields

Field	Type	Description
id	Int	Unique identifier.
amount	Float	Price amount.
currency	Currency	Linked currency.
company_id	Int	Company identifier.
variant	Variant	Linked variant.
priceable	Priceable	Linked entity (Customer, Supplier, or PriceLevel).
priceable_type	VariantPriceType	Type of priceable entity (Customer, Supplier, or PriceLevel).

---

Filters

Field	Example
id	{ "column": "ID", "operator": "EQ", "value": 100012 }
currency	{ "column": "CURRENCY", "operator": "EQ", "value": "EUR" }
company_id	{ "column": "COMPANY_ID", "operator": "EQ", "value": 100001 }
variant_id	{ "column": "VARIANT_ID", "operator": "EQ", "value": 100076 }
variant_label	{ "column": "VARIANT_LABEL", "operator": "LIKE", "value": "%Product%" }
variant_sku	{ "column": "VARIANT_SKU", "operator": "EQ", "value": "SKU-001" }
priceable_id	{ "column": "PRICEABLE_ID", "operator": "EQ", "value": 100001 }
priceable_type	{ "column": "PRICEABLE_TYPE", "operator": "EQ", "value": "Customer" }

---

Unions

Priceable

The Priceable union can be one of:

• Customer
• Supplier
• PriceLevel

---

Data Types

SupplierVariantPriceTierInput

Field	Type	Description
from_quantity	Float!	Minimum quantity for this price tier (required).
amount	Float!	Price amount for this tier (required).

VariantPriceType

Value	Description
Customer	Customer entity.
Supplier	Supplier entity.
PriceLevel	Price level entity.

SimulatedVariantPrice

Field	Type	Description
variant_id	Int!	Variant being priced.
customer_id	Int	Customer used for the simulation, if any.
customer_label	String	Customer name.
resolved_price_level_id	Int	Price level actually applied.
resolved_price_level_label	String	Label of the applied price level.
currency	String!	Currency of the amounts.
quantity	Float!	Quantity used for the simulation.
base_unit_price	Float	Unit price before discounts.
net_unit_price	Float	Unit price after discounts.
net_line_total	Float	Net total for the quantity.
computed_from_components	Boolean!	True when the price is computed from kit or packaging components.
exclude_from_discount_rules	Boolean!	True when discount rules do not apply.
steps	[SimulatedPriceStep!]!	Price rules applied, in order.
quantity_tiers	[SimulatedQuantityTier!]!	Quantity tiers of the applied rule.

SimulatedPriceStep

Field	Type	Description
step_key	String!	Identifier of the step.
applied	Boolean!	Whether the step changed the price.
status	String!	Outcome of the step.
rule_label	String	Rule that produced the step.
unit_price	Float	Unit price after the step.
discount_amount	Float	Discount amount applied.
discount_percentage	Float	Discount percentage applied.

SimulatedQuantityTier

Field	Type	Description
from_quantity	Float!	Quantity from which the tier applies.
rule_label	String	Rule that defines the tier.
discount_amount	Float	Discount amount for the tier.
discount_percentage	Float	Discount percentage for the tier.
net_unit_price	Float	Unit price in the tier.
is_current_quantity	Boolean!	True for the tier matching the simulated quantity.

SimulateVariantPriceInput

Field	Type	Description
variant_id	Int!	Variant to price.
customer_id	Int	Customer context.
price_level_id	Int	Price level context, when no customer is given.
quantity	Float	Quantity to price (defaults to 1).
currency	String	Currency ISO code (defaults to the company currency).
exchange_rate	Float	Exchange rate to apply.
dated_at	Date	Date used to select active rules.
location_ids	[Int]	Locations used for the price.
season_id	Int	Season used for the price.