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

Field	Type	Description
`id`	Int	Unique identifier.
`label`	String	Name of the price level.
`type`	PriceLevelType	Defines if it is rules for purchasing or selling.
`active`	Boolean	True if the price level is active.
`variant_price`	VariantPrice	Resolves the specific price for a variant under this price level. Requires `variant_id` argument.

Filters

Field	Example
`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`

Value	Description
`selling`	Applies to sales documents (Quotes, Invoices, etc.).
`purchasing`	Applies to purchase documents (Purchase Orders, etc.).

Value	Description
`selling`	Applies to sales documents (Quotes, Invoices, etc.).
`purchasing`	Applies to purchase documents (Purchase Orders, etc.).