PriceListPrices
Lists prices attached to a specific price list by currency and adjustment rules.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- 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 Id of the price list. |
| ProductVariantId [KEY] | String | The unique Id of the product variant associated with this price. | |
| OriginType | String | The origin of the price, either fixed (defined on the price list) or relative (calculated using a price list adjustment configuration). | |
| PriceAmount | Decimal | The price of the product variant on this price list, expressed as a decimal money amount. | |
| PriceCurrencyCode | String | The currency code of the product variant price on this price list. | |
| CompareAtPriceAmount | Decimal | The compare-at price of the product variant on this price list, expressed as a decimal money amount. | |
| CompareAtPriceCurrencyCode | String | The currency code of the compare-at price on this price list. |