Returns a list Selling Plan Groups.

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.
• 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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御したり、INSERT ステートメントのパラメータとして使用したりすることができます。

Name	Type	Description
SellingPlansToCreate	String	List of selling plans to create.
SellingPlansToUpdate	String	List of selling plans to update.
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.