PriceLists
All price lists for a shop.
Select
The add-in uses the Shopify API to process WHERE clause conditions built with the following column and operator. The add-in processes other filters client-side within the add-in.
- 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. |