Variants Prices Queries

Access variant-specific pricing across price levels.

VariantPrice — Returns a single variant price by id

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

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
    }
  }
}

Available fields

FieldTypeDescription
idIntUnique identifier.
amountFloatPrice amount.
currencyCurrencyLinked currency.
company_idIntCompany identifier.
variantVariantLinked variant.
priceablePriceableLinked entity (Customer, Supplier, or PriceLevel).
priceable_typeStringType of the priceable entity.

Filters

FieldExample
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

FieldTypeDescription
from_quantityFloat!Minimum quantity for this price tier (required).
amountFloat!Price amount for this tier (required).