PriceListPrices
A list of prices associated with a price list.
View-Specific Information
Select
The add-in uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- PriceListId supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM PriceListPrices
SELECT * FROM PriceListPrices WHERE PriceListId = 'Val1'
Columns
| Name | Type | References | Description |
| PriceListId [KEY] | String |
PriceLists.Id | The unique identifier of the price list. |
| ProductVariantId [KEY] | String | The unique identifier of the product variant associated with this price. | |
| OriginType | String | The origin of a 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. Decimal money amount. | |
| PriceCurrencyCode | String | The price of the product variant on this price list. Currency of the money. | |
| CompareAtPriceAmount | Decimal | The compare-at price of the product variant on this price list. Decimal money amount. | |
| CompareAtPriceCurrencyCode | String | The compare-at price of the product variant on this price list. Currency of the money. |