CatalogProductTierPriceTiers
CatalogProductTierPriceTiers is an auto generated table. The supported operations are Querying data from this table.
Table Specific Information
Select
The component uses the AdobeCommerce API to filter the results by CustomerGroupId or Sku while the rest of the filter is executed client side within the component.
You must specify the CustomerGroupId and Sku columns must be specified in the WHERE clause to retrieve results from CatalogProductTierPriceTiers. CustomerGroupId and Sku can be used only with the equals (=) operator.
For example:
SELECT * FROM [CatalogProductTierPriceTiers] WHERE CustomerGroupId = '234' AND Sku = '123'
Columns
| Name | Type | Description |
| CustomerGroupId [KEY] | Int | Customer group id |
| Sku | String | sku |
| ExtensionAttributes | String | This is an auto-generated column |
| Qty | Double | Tier qty |
| Value | Double | Price value |