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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。ON_FULFILLMENT, ON_SALE | |
| FixedBillingPolicyCheckoutChargeType | String | Specifies the type of charge applied during checkout, such as a fixed amount or percentage-based charge.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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.
使用できる値は次のとおりです。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
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| Name | Type | Description | |
| Metafields | String | Contains additional metadata attached to the selling plan, allowing apps or merchants to store custom structured information. |