PriceLists
All price lists for a shop.
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operator. The 本製品 processes other filters client-side within the 本製品.
- Id supports the '=,IN' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM PriceLists
SELECT * FROM PriceLists WHERE Id = 'Val1'
Insert
Insert statements are mapped to the 'priceListCreate' GraphQL mutation.
The following columns can be used to create a new record:
Currency, Name, ParentAdjustmentType, ParentAdjustmentValue, ParentSettingsCompareAtMode
Update
Update statements are mapped to the 'priceListUpdate' GraphQL mutation.
The following columns can be updated:
Id, Currency, Name, ParentAdjustmentType, ParentAdjustmentValue, ParentSettingsCompareAtMode
Delete
Delete statements are mapped to the 'priceListDelete' GraphQL mutation.
You can delete entries by specifying the Id
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
A globally-unique ID. | |
| Currency | String | False |
The currency for fixed prices associated with this price list. | |
| FixedPricesCount | Int | True |
The number of fixed prices on the price list. | |
| Name | String | False |
The unique name of the price list, used as a human-readable identifier. | |
| ParentAdjustmentType | String | False |
The type of price adjustment, such as percentage increase or decrease. | |
| ParentAdjustmentValue | Double | False |
The value of price adjustment, where positive numbers reduce the prices and negative numbers increase them. | |
| ParentSettingsCompareAtMode | String | False |
The type of price list adjustment setting for compare at price. |