SellingPlanGroupSellingPlans
Lists selling plans associated with a selling plan group, including frequency and pricing options.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- SellingPlanGroupId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM SellingPlanGroupSellingPlans WHERE SellingPlanGroupId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique identifier for the selling plan. | |
| SellingPlanGroupId | String | The globally unique identifier of the selling plan group this plan belongs to. | |
| Name | String | The customer-facing name of the selling plan, displayed during checkout or product selection. Avoid including currency-specific text, as the content is not automatically converted for multi-currency stores. | |
| Category | String | The classification of the selling plan, used internally or for reporting, such as subscription or pre-order plans.
The allowed values are OTHER, PRE_ORDER, SUBSCRIPTION, TRY_BEFORE_YOU_BUY. | |
| Description | String | A buyer-facing description that outlines the commitment or conditions of the selling plan, such as frequency or duration. | |
| Options | String | Lists all option values available within the selling plan. Plans are grouped in Liquid templates when they share the same name, originating app, and option structure. | |
| Position | Int | Determines the display order of the selling plan within its group; lower numbers appear first. | |
| CreatedAt | Datetime | The date and time when the selling plan was created. | |
| InventoryPolicyReserve | String | Defines when inventory is reserved for an order within the plan lifecycle, such as at checkout or fulfillment.
The allowed values are ON_FULFILLMENT, ON_SALE. | |
| FixedBillingPolicyCheckoutChargeType | String | Specifies the type of charge applied during checkout, such as a fixed amount or percentage-based charge.
The allowed values are PERCENTAGE, PRICE. | |
| FixedBillingPolicyCheckoutChargeValueAmount | Decimal | The fixed amount charged at checkout. Decimal money amount. | |
| FixedBillingPolicyCheckoutChargeValueCurrencyCode | String | The currency code of the fixed amount charged at checkout. | |
| FixedBillingPolicyCheckoutChargeValuePercentage | Double | The percentage-based charge applied during checkout, relative to the total price. | |
| FixedBillingPolicyRemainingBalanceChargeExactTime | Datetime | The precise date and time when the remaining balance should be captured for the selling plan. | |
| FixedBillingPolicyRemainingBalanceChargeTimeAfterCheckout | String | The duration between checkout and when the remaining balance is captured, represented in ISO8601 duration format. | |
| FixedBillingPolicyRemainingBalanceChargeTrigger | String | Specifies when the remaining balance should be captured, such as after checkout or on a specific event.
The allowed values are EXACT_TIME, NO_REMAINING_BALANCE, TIME_AFTER_CHECKOUT. | |
| RecurringBillingPolicyAnchors | String | Anchor dates that determine the recurrence points for billing cycles, represented as an aggregate value. | |
| RecurringBillingPolicyCreatedAt | Datetime | The date and time when the recurring billing policy for this selling plan was created. | |
| RecurringBillingPolicyInterval | String | Defines the frequency of billing.
The allowed values are DAY, MONTH, WEEK, YEAR. | |
| RecurringBillingPolicyIntervalCount | Int | The number of intervals between billing cycles, defining how often customers are billed. | |
| RecurringBillingPolicyMaxCycles | Int | The maximum number of billing cycles for the selling plan, after which billing stops automatically. | |
| RecurringBillingPolicyMinCycles | Int | The minimum number of billing cycles a customer must complete before cancellation is allowed. | |
| FixedDeliveryPolicyAnchors | String | Anchor dates used to calculate delivery intervals under a fixed delivery schedule. Aggregate value. | |
| FixedDeliveryPolicyCutoff | Int | A cutoff window defining how many days before the next anchor an order must be placed to qualify for the upcoming fulfillment cycle. | |
| FixedDeliveryPolicyFulfillmentExactTime | Datetime | The specific date and time when fulfillment for the order should be triggered. | |
| FixedDeliveryPolicyFulfillmentTrigger | String | Defines what event triggers the fulfillment.
The allowed values are ANCHOR, ASAP, EXACT_TIME, UNKNOWN. | |
| FixedDeliveryPolicyIntent | String | Indicates whether the delivery policy is merchant-centric or buyer-centric. Merchant-centric defines when fulfillment begins; buyer-centric defines when the customer receives the order. | |
| FixedDeliveryPolicyPreAnchorBehavior | String | Specifies how the first fulfillment behaves if the order is placed before the anchor date. Default behavior is ASAP.
The allowed values are ASAP, NEXT. | |
| RecurringDeliveryPolicyAnchors | String | Anchor dates used to calculate recurring delivery intervals. Aggregate value. | |
| RecurringDeliveryPolicyCreatedAt | Datetime | The date and time when the recurring delivery policy was created. | |
| RecurringDeliveryPolicyCutoff | Int | The number of days before the next anchor that determines whether an order qualifies for that delivery cycle. | |
| RecurringDeliveryPolicyIntent | String | Indicates whether the recurring delivery policy focuses on buyer delivery timing or merchant fulfillment timing. Currently, only merchant-centric delivery is supported.
The allowed values are FULFILLMENT_BEGIN. | |
| RecurringDeliveryPolicyInterval | String | Specifies the delivery frequency, such as day, week, month, or year. | |
| RecurringDeliveryPolicyIntervalCount | Int | The number of intervals between consecutive deliveries in the recurring delivery schedule. | |
| RecurringDeliveryPolicyPreAnchorBehavior | String | Specifies how the first delivery behaves if the order is placed before the anchor date. Default behavior is ASAP.
The allowed values are ASAP, NEXT. | |
| FixedPricingPolicies | String | Lists fixed pricing policies associated with this selling plan, defining static pricing terms. Aggregate value. | |
| RecurringPricingPolicies | String | Lists recurring pricing policies associated with this selling plan, defining ongoing or repeating pricing adjustments. Aggregate value. |
Pseudo-Columns
Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.
| Name | Type | Description | |
| Metafields | String | Contains additional metadata attached to the selling plan, allowing apps or merchants to store custom structured information. |