Search price tiers | Distru Documentation

Searches the price tiers of the company: discounts that lower the unit price of sales order items.

Inputs

Every tool also takes the common inputs.

Field	Type	Required	Description
limit	integer	No	Default: `10`
cursor	string	No	nextCursor of the previous call; keep the other arguments unchanged.
ids	string[]	No	Price tier IDs.
search	string	No	Case-insensitive substring of name or externalName.
customerIds	string[]	No	Matches oneOfCompanies. Resolve via distru-search-companies.
customerGroupIds	string[]	No	Matches oneOfCompanyGroups. Resolve via distru-search-lookups (type COMPANY_GROUP).
productIds	string[]	No	Matches oneOfProducts. Not tiers reaching a product only via its category, brand, group or tag. Resolve via distru-search-products.
productTagIds	string[]	No	Matches oneOfProductTags. Resolve via distru-search-lookups (type PRODUCT_TAG).
productCategoryIds	string[]	No	Matches oneOfProductCategories. Resolve via distru-search-lookups (type PRODUCT_CATEGORY).
productSubcategoryIds	string[]	No	Matches oneOfProductSubcategories. Resolve via distru-search-lookups (type PRODUCT_CATEGORY, each row's subcategories).
productGroupIds	string[]	No	Matches oneOfProductGroups. Resolve via distru-search-lookups (type PRODUCT_GROUP).
brandIds	string[]	No	Matches oneOfProductBrands. Resolve via distru-search-products (each row's brand) or distru-search-companies.
menuIds	string[]	No	Tiers shown on any of these active menus: menuMode ALL, or SPECIFIC with the menu in menus. Resolve via distru-search-menus.
validAt	string	No	Tiers active at this moment: validFrom <= it (or null), validUntil > it (or null). Without it, expired and future tiers are listed too. ISO 8601 with a UTC offset, e.g. "2026-09-01T00:00:00-07:00"; the company timezone is on distru-get-me.
pricingType	enum `AMOUNT_OFFFLAT_PRICEPERCENT_OFF`	No
ownerIds	string[]	No	Resolve via distru-search-users.
includeDeleted	boolean	No	Also list deleted tiers, with deletedAt set.
sortBy	object	No	Default: most recently updated first.
sortBy.direction	enum `ASCDESC`	Yes
sortBy.field	enum `INSERTED_ATNAMEUPDATED_AT`	Yes	NAME = internal name, not externalName.

Output

Presence on a nested field assumes its parent exists.

Field	Type	Presence
hasMore	boolean	Always
nextCursor	string	Can be absent
totalCount	integer	Can be absent
items	object[]	Always
items[].id	string	Always
items[].name	string	Always
items[].externalName	string	Null or absent
items[].pricing	object	Always
items[].pricing.type	enum `AMOUNT_OFFFLAT_PRICEPERCENT_OFF`	Always
items[].pricing.value	string	Null or absent
items[].validFrom	string	Null or absent
items[].validUntil	string	Null or absent
items[].deletedAt	string	Can be null
items[].menuMode	enum `ALLNONESPECIFIC`	Always
items[].menus	object[]	Can be absent
items[].menus[].id	string	Always
items[].menus[].name	string	Always
items[].owner	object	Null or absent
items[].owner.id	string	Always
items[].owner.fullName	string	Null or absent
items[].conditions	object	Always
items[].conditions.oneOfProducts	object[]	Can be absent
items[].conditions.oneOfProducts[].id	string	Always
items[].conditions.oneOfProducts[].name	string	Always
items[].conditions.notOneOfProducts	object[]	Can be absent
items[].conditions.notOneOfProducts[].id	string	Always
items[].conditions.notOneOfProducts[].name	string	Always
items[].conditions.oneOfProductCategories	object[]	Can be absent
items[].conditions.oneOfProductCategories[].id	string	Always
items[].conditions.oneOfProductCategories[].name	string	Always
items[].conditions.notOneOfProductCategories	object[]	Can be absent
items[].conditions.notOneOfProductCategories[].id	string	Always
items[].conditions.notOneOfProductCategories[].name	string	Always
items[].conditions.oneOfProductSubcategories	object[]	Can be absent
items[].conditions.oneOfProductSubcategories[].id	string	Always
items[].conditions.oneOfProductSubcategories[].name	string	Always
items[].conditions.notOneOfProductSubcategories	object[]	Can be absent
items[].conditions.notOneOfProductSubcategories[].id	string	Always
items[].conditions.notOneOfProductSubcategories[].name	string	Always
items[].conditions.oneOfProductGroups	object[]	Can be absent
items[].conditions.oneOfProductGroups[].id	string	Always
items[].conditions.oneOfProductGroups[].name	string	Always
items[].conditions.notOneOfProductGroups	object[]	Can be absent
items[].conditions.notOneOfProductGroups[].id	string	Always
items[].conditions.notOneOfProductGroups[].name	string	Always
items[].conditions.oneOfProductTags	object[]	Can be absent
items[].conditions.oneOfProductTags[].id	string	Always
items[].conditions.oneOfProductTags[].name	string	Always
items[].conditions.notOneOfProductTags	object[]	Can be absent
items[].conditions.notOneOfProductTags[].id	string	Always
items[].conditions.notOneOfProductTags[].name	string	Always
items[].conditions.oneOfCompanyGroups	object[]	Can be absent
items[].conditions.oneOfCompanyGroups[].id	string	Always
items[].conditions.oneOfCompanyGroups[].name	string	Always
items[].conditions.notOneOfCompanyGroups	object[]	Can be absent
items[].conditions.notOneOfCompanyGroups[].id	string	Always
items[].conditions.notOneOfCompanyGroups[].name	string	Always
items[].conditions.oneOfProductBrands	object[]	Can be absent
items[].conditions.oneOfProductBrands[].id	string	Always
items[].conditions.oneOfProductBrands[].name	string	Null or absent
items[].conditions.notOneOfProductBrands	object[]	Can be absent
items[].conditions.notOneOfProductBrands[].id	string	Always
items[].conditions.notOneOfProductBrands[].name	string	Null or absent
items[].conditions.oneOfCompanies	object[]	Can be absent
items[].conditions.oneOfCompanies[].id	string	Always
items[].conditions.oneOfCompanies[].name	string	Null or absent
items[].conditions.notOneOfCompanies	object[]	Can be absent
items[].conditions.notOneOfCompanies[].id	string	Always
items[].conditions.notOneOfCompanies[].name	string	Null or absent
items[].conditions.minQuantity	object	Null or absent
items[].conditions.minQuantity.quantity	string	Always
items[].conditions.minQuantity.unitType	object	Null or absent
items[].conditions.minQuantity.unitType.id	string	Always
items[].conditions.minQuantity.unitType.name	string	Always
items[].conditions.totalThcPercentageRange	object	Null or absent
items[].conditions.totalThcPercentageRange.min	string	Null or absent
items[].conditions.totalThcPercentageRange.max	string	Null or absent

What the AI reads

Searches the price tiers of the company: discounts that lower the unit price of sales order items. One row per tier with its pricing, active window, menus, owner and conditions. For which tiers priced which orders and the discounts given, deleted tiers included, use distru-report-sales-orders with rowsPer LINE_ITEM. externalName is the name buyers see; null means they see name. pricing.type PERCENT_OFF takes value percent off the unit price, AMOUNT_OFF subtracts value from it, FLAT_PRICE replaces it with value; the price never goes below 0, and when flat and other tiers both apply to an item, flat tiers win. A tier applies to an order item only when every condition is met: the item matches an entry of each oneOf* list and none of any notOneOf* list, reaches minQuantity (in its unitType when set), and has a total THC percentage within totalThcPercentageRange (null bounds are open). A missing condition key means no condition of that kind. menus is present only when menuMode is SPECIFIC; ALL means every active menu and NONE no menu. validFrom and validUntil bound the active window; null means no limit on that side. Tiers the caller's team restrictions hide are omitted. List filters match any value. Condition filters (Matches oneOf*) skip tiers without that condition or that only exclude the values.