CatalogProductTierPriceTiers
CatalogProductTierPriceTiers is an auto generated table. The supported operations are Querying data from this table.
Table Specific Information
Select
The add-in uses the AdobeCommerce API to filter the results by CustomerGroupId or Sku while the rest of the filter is executed client side within the add-in.
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 |