Returns a list Selling Plan Groups.

Table-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.

• 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

The following columns can be used to create a new record:

AppId, Name, Description, Options, Position, MerchantCode, SellingPlansToCreate (references SellingPlanGroupSellingPlans)

The following pseudo-columns can be used to create a new record:

ProductIds, ProductVariantIds

Update

The following columns can be updated:

AppId, Name, Description, Options, Position, MerchantCode, SellingPlansToCreate (references SellingPlanGroupSellingPlans), SellingPlansToUpdate (references SellingPlanGroupSellingPlans)

The following pseudo-column can be updated:

SellingPlansToDelete

Delete

You can delete entries by specifying the following column:

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.