SellingPlanGroupSellingPlans
Lists selling plans associated with a selling plan group.
View-Specific Information
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operators. The 本製品 processes other filters client-side within the 本製品.
- 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 Id for the selling plan. | |
| SellingPlanGroupId | String | A globally unique Id for the associated selling plan group. | |
| Name | String | A customer-facing description of the selling plan. If the store supports multiple currencies, avoid including country-specific pricing (for example, 'Buy monthly, get 10$ CAD off') since this text is not converted for other currencies. | |
| Category | String | The category used to classify the selling plan for reporting purposes.
使用できる値は次のとおりです。OTHER, PRE_ORDER, SUBSCRIPTION, TRY_BEFORE_YOU_BUY | |
| Description | String | The buyer-facing description of the selling plan commitment. | |
| Options | String | The option values available in the selling plan. Selling plans are grouped together in Liquid when created by the same app and share the same 'selling_plan_group.name' and 'selling_plan_group.options' values. | |
| Position | Int | The relative display order of the selling plan. Lower values are shown before higher values. | |
| CreatedAt | Datetime | The date and time when the selling plan was created. | |
| InventoryPolicyReserve | String | Specifies when to reserve inventory for the order.
使用できる値は次のとおりです。ON_FULFILLMENT, ON_SALE | |
| FixedBillingPolicyCheckoutChargeType | String | The type of checkout charge applied by the fixed billing policy.
使用できる値は次のとおりです。PERCENTAGE, PRICE | |
| FixedBillingPolicyCheckoutChargeValueAmount | Decimal | The fixed checkout charge amount, expressed as a decimal value. | |
| FixedBillingPolicyCheckoutChargeValueCurrencyCode | String | The currency code for the fixed checkout charge amount. | |
| FixedBillingPolicyCheckoutChargeValuePercentage | Double | The checkout charge as a percentage of the product price. | |
| FixedBillingPolicyRemainingBalanceChargeExactTime | Datetime | The exact date and time when to capture the remaining balance. | |
| FixedBillingPolicyRemainingBalanceChargeTimeAfterCheckout | String | The duration between the checkout event and capturing the remaining balance. Expressed as an ISO8601 duration. | |
| FixedBillingPolicyRemainingBalanceChargeTrigger | String | Specifies when to capture payment for the remaining balance.
使用できる値は次のとおりです。EXACT_TIME, NO_REMAINING_BALANCE, TIME_AFTER_CHECKOUT | |
| RecurringBillingPolicyAnchors | String | The anchor dates used for calculating billing intervals. | |
| RecurringBillingPolicyCreatedAt | Datetime | The date and time when the recurring billing policy was created. | |
| RecurringBillingPolicyInterval | String | The billing interval unit.
使用できる値は次のとおりです。DAY, MONTH, WEEK, YEAR | |
| RecurringBillingPolicyIntervalCount | Int | The number of interval units between billings. | |
| RecurringBillingPolicyMaxCycles | Int | The maximum number of billing cycles allowed. | |
| RecurringBillingPolicyMinCycles | Int | The minimum number of billing cycles required. | |
| FixedDeliveryPolicyAnchors | String | The anchor dates used for calculating delivery intervals. | |
| FixedDeliveryPolicyCutoff | Int | The cutoff period (in days) for including orders in the next fulfillment cycle. | |
| FixedDeliveryPolicyFulfillmentExactTime | Datetime | The exact date and time when fulfillment should occur. | |
| FixedDeliveryPolicyFulfillmentTrigger | String | Specifies what triggers fulfillment.
使用できる値は次のとおりです。ANCHOR, ASAP, EXACT_TIME, UNKNOWN | |
| FixedDeliveryPolicyIntent | String | Indicates whether the delivery policy is merchant-centric or buyer-centric. Currently, only merchant-centric delivery policies are supported. | |
| FixedDeliveryPolicyPreAnchorBehavior | String | Specifies fulfillment behavior if an order is placed before the anchor date.
使用できる値は次のとおりです。ASAP, NEXT | |
| RecurringDeliveryPolicyAnchors | String | The anchor dates used for calculating recurring delivery intervals. | |
| RecurringDeliveryPolicyCreatedAt | Datetime | The date and time when the recurring delivery policy was created. | |
| RecurringDeliveryPolicyCutoff | Int | The cutoff period (in days) for including orders in the current delivery cycle. | |
| RecurringDeliveryPolicyIntent | String | Indicates whether the delivery policy is merchant-centric or buyer-centric. Currently, only merchant-centric delivery policies are supported.
使用できる値は次のとおりです。FULFILLMENT_BEGIN | |
| RecurringDeliveryPolicyInterval | String | The delivery interval unit. The unit for the delivery interval (day, week, month, or year). | |
| RecurringDeliveryPolicyIntervalCount | Int | The number of interval units between deliveries. | |
| RecurringDeliveryPolicyPreAnchorBehavior | String | Specifies fulfillment behavior if an order is placed before the anchor date.
使用できる値は次のとおりです。ASAP, NEXT | |
| FixedPricingPolicies | String | Represents fixed pricing policies associated with the selling plan. | |
| RecurringPricingPolicies | String | Represents recurring pricing policies associated with the selling plan. |
Pseudo-Columns
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| Name | Type | Description | |
| Metafields | String | Additional metadata attached to the selling plan resource. |