PriceListPrices
Lists pricing entries tied to a specific price list, including product, variant, and region-specific prices.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- PriceListId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM PriceListPrices WHERE PriceListId = 'Val1'
Columns
| Name | Type | References | Description |
| PriceListId [KEY] | String |
PriceLists.Id | The unique identifier of the price list that defines this pricing entry. |
| ProductVariantId [KEY] | String | The unique identifier of the product variant associated with this specific price list entry. | |
| OriginType | String | Specifies how the price was determined—either as a fixed price manually set on the price list, or as a relative price derived from an adjustment configuration. | |
| PriceAmount | Decimal | The selling price of the product variant defined in this price list, expressed as a decimal money value. | |
| PriceCurrencyCode | String | The ISO 4217 currency code representing the currency of the listed price, such as USD or EUR. | |
| CompareAtPriceAmount | Decimal | The original or reference price of the product variant on this price list, used to show discounts or savings. Expressed as a decimal money value. | |
| CompareAtPriceCurrencyCode | String | The ISO 4217 currency code representing the currency of the compare-at price, such as USD or EUR. |