SellingPlanGroups
Returns a list Selling Plan Groups.
Select
The cmdlet uses the Shopify API to process WHERE clause conditions built with the following column and operator. The cmdlet processes other filters client-side within the cmdlet.
- Id supports the '=,IN' comparison operators.
- Name supports the '=,!=' comparison operators.
- CreatedAt supports the '<,>,>=' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM SellingPlanGroups
SELECT * FROM SellingPlanGroups WHERE Id = 'Val1'
SELECT * FROM SellingPlanGroups WHERE Name = 'Val1'
SELECT * FROM SellingPlanGroups WHERE CreatedAt < '2023-01-01 11:10:00'
Insert
Insert statements are mapped to the 'sellingPlanGroupCreate' GraphQL mutation.
The following columns can be used to create a new record:
AppId, Name, Description, Options, Position, MerchantCode, SellingPlansToCreate
The following pseudo-columns can be used to create a new record:
ProductIds, ProductVariantIds
Update
Update statements are mapped to the 'sellingPlanGroupUpdate' GraphQL mutation.
The following columns can be updated:
Id, AppId, Name, Description, Options, Position, MerchantCode, SellingPlansToCreate, SellingPlansToUpdate
The following pseudo-columns can be updated:
SellingPlansToDelete
Delete
Delete statements are mapped to the 'sellingPlanGroupDelete' GraphQL mutation.
You can delete entries by specifying the Id
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
A globally-unique ID. | |
AppId | String | False |
The ID for app, exposed in Liquid and product JSON. | |
Name | String | False |
The buyer-facing label of the selling plan group. | |
Description | String | False |
The merchant-facing description of the selling plan group. | |
Options | String | False |
The values of all options available on the selling plan group. Selling plans are grouped together in Liquid when they are created by the same app, and have the same 'selling_plan_group. name' and 'selling_plan_group. options' values. | |
Position | Int | False |
The relative position of the selling plan group for display. | |
Summary | String | True |
A summary of the policies associated to the selling plan group. | |
MerchantCode | String | False |
The merchant-facing label of the selling plan group. | |
ProductCount | Int | True |
A count of products associated to the selling plan group. | |
CreatedAt | Datetime | True |
The date and time when the selling plan group was created. | |
SellingPlansToCreate | String | False |
List of selling plans to create. | |
SellingPlansToUpdate | String | False |
List of selling plans to update. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.
Name | Type | Description |
SellingPlansToDelete | String |
List of selling plans to delete as a simple, comma-separated list. |
ProductIds | String |
The IDs of the Products to add to the Selling Plan Group as a simple, comma-separated list. |
ProductVariantIds | String |
The IDs of the Variants to add to the Selling Plan Group as a simple, comma-separated list. |