Price Levels Queries

Retrieve price levels for tiered pricing strategies.

PriceLevel — Returns a single price level by id

Example Query:

query GetPriceLevel($id: ID!) {
  PriceLevel(id: $id) {
    id
    label
    type
    active
  }
}

Example Result:

{
  "data": {
    "PriceLevel": {
      "id": 10001,
      "label": "Wholesale Price",
      "type": "selling",
      "active": true
    }
  }
}

PriceLevels — Returns a list of price levels with sorting and filters

Example Query:

query PriceLevels(
  $where: QueryPriceLevelsWhereWhereConditions,
  $orderBy: [QueryPriceLevelsOrderByOrderByClause!],
  $search: String,
  $first: Int,
  $page: Int
) {
  PriceLevels(
    where: $where,
    orderBy: $orderBy,
    search: $search,
    first: $first,
    page: $page
  ) {
    paginatorInfo {
      total
      currentPage
    }
    data {
      id
      label
      type
      active
    }
  }
}

Example Variables:

{
  "where": {
    "AND": [
      { "column": "ACTIVE", "operator": "EQ", "value": true },
      { "column": "TYPE", "operator": "EQ", "value": "selling" }
    ]
  },
  "search": "Retail",
  "first": 50,
  "page": 1
}

Available fields

FieldTypeDescription
idIntUnique identifier.
labelStringName of the price level.
typePriceLevelTypeDefines if it is rules for purchasing or selling.
activeBooleanTrue if the price level is active.
variant_priceVariantPriceResolves the specific price for a variant under this price level. Requires variant_id argument.

Filters

FieldExample
id{ "column": "ID", "operator": "EQ", "value": 10001 }
label{ "column": "LABEL", "operator": "LIKE", "value": "%Retail%" }
type{ "column": "TYPE", "operator": "EQ", "value": "purchasing" }
active{ "column": "ACTIVE", "operator": "EQ", "value": true }

Enums

PriceLevelType

ValueDescription
sellingApplies to sales documents (Quotes, Invoices, etc.).
purchasingApplies to purchase documents (Purchase Orders, etc.).