CheckoutItems
Returns the items associated with a checkout.
Table-Specific Information
Select
Returns all checkout items associated with your account.
Note: CheckoutId is required to fetch the data.
SELECT * FROM CheckoutItems WHERE CheckoutId = 'bc/account/checkout/78';
Insert
You can insert the following columns: AccountId, Description, ProductId, ProductType, ScopeId, ScopeType, PricingPlanInterval, PricingPlanPriceValue, PricingPlanPriceCurrencyCode, PricingPlanTrialDays, and RedirectUrl INSERT INTO CheckoutItems(AccountId, Description, ProductId, ProductType, ScopeId, ScopeType, PricingPlanInterval, PricingPlanPriceValue, PricingPlanPriceCurrencyCode, PricingPlanTrialDays, RedirectUrl) VALUES('bc/account/account/5f7a7943-e37c-45e5-8b6e-91b54f44abe9', 'Premium App Subscription', 'bc/store/product/77', 'APPLICATION', 'bc/store/scope/abc123', 'STORE', 'MONTH', '20.00', 'USD', 7, 'https://example.com/success');
Columns
| Name | Type | ReadOnly | Description |
| SubscriptionId [KEY] | String | False |
If available, the ID of the Subscription associated with this Line Item. |
| AccountId | String | False |
The ID of the Account. |
| CheckoutId | String | False |
The ID of the checkout. |
| ProductId | String | False |
The unique ID of the product. |
| ScopeId | String | False |
The unique ID of the scope. |
| RedirectUrl | String | False |
The URL used to redirect the Merchant after completing the Checkout. |
| ProductProductLevel | String | False |
A description of the product level, if applicable (for example, application tier for an application). |
| ProductType | String | False |
The type of product (for example, APPLICATION). |
| ScopeType | String | False |
Where to scope access for this item (for example, STORE). |
| PricingPlanInterval | String | False |
The billing interval for the subscription. The allowed values are ANNUAL, MONTH, ONCE, QUARTER, SEMIANNUAL. |
| PricingPlanPriceCurrencyCode | String | False |
The currency code for the pricing amount. |
| PricingPlanPriceValue | Double | False |
The pricing amount. |
| PricingPlanTrialDays | Int | False |
Number of days to delay billing to offer a free trial period. |
| Description | String | False |
A description of this line item. |
| Status | String | True |
The status of this line item. |
| CheckoutUrl | String | True |
The URL to complete the checkout. |