JDBC Driver for Adobe Commerce

Build 24.0.9060

CatalogProductTierPriceTiers

CatalogProductTierPriceTiers is an auto generated table. The supported operations are Querying data from this table.

Table Specific Information

Select

The driver uses the AdobeCommerce API to filter the results by CustomerGroupId or Sku while the rest of the filter is executed client side within the driver.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060