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