Subscription Item View

The Subscription Item view provides dimensions and measures related to the items purchased within a subscription.

The measures calculated by this view are:

Name Measure Type Description
Average Adjusted Line Item Subtotal Average Average of adjusted line item subtotal total for all subscription items.
Average Days Since Created Average Average number of days elapsed since the created date.
Average Days Since Updated Average Average number of days elapsed since the updated date.
Average Discount Total Average Average of the discount total for all subscription items.
Average Extended Total Average Average of the extended total for all subscription items.
Average Fee Total Average Average of the fee total for all subscription items.
Average Handling Amount Average Average of the handling amount for all subscription items.
Average Hours Since Created Average Average number of hours elapsed since the created date.
Average Hours Since Updated Average Average number of hours elapsed since the updated date.
Average Item Tax Total Average Average of the item tax total for all subscription cancelled items.
Average Minutes Since Created Average Average number of minutes elapsed since the created date.
Average Minutes Since Updated Average Average number of minutes elapsed since the updated date.
Average Sale Price Average Average of the sale price for all subscription items.
Average Shipping Amount Before Discounts And Adjustments Average Average of the shipping amount, before discounts and adjustments, for all subscription items.
Average Shipping Tax Total Average Average of the shipping tax total for all subscription items.
Average Shipping Total Average Average of the shipping total for all subscription items.
Average Subtotal Average Average of the subtotal for all subscription items.
Average Taxable Total Average Average of the taxable total for all subscription items.
Average Total Average Average of the total for all subscription items.
Average Total With Weighted Shipping And Handling Average Average of the total with weighted shipping and handling for all subscription items.
Average Total Without Weighted Shipping And Handling Average Average of the total without weighted shipping and handling for all subscription items.
Average Unit List Price Average Average of the unit list price for all subscription items.
Average Unit Sale Price Average Average of the unit sale price for all subscription items.
Average Weighted Order Adjustment Average Average of the weighted order adjustment for all subscription items.
Average Weighted Order Discount Average Average of the weighted order discount for all subscription items.
Average Weighted Order Duty Average Average of the weighted order duty for all subscription items.
Average Weighted Order Handling Adjustment Average Average of the weighted order handling adjustment for all subscription items.
Average Weighted Order Handling Fee Average Average of the weighted order handling fee for all subscription items.
Average Weighted Order Handling Fee Discount Average Average of the weighted order handling fee discount for all subscription items.
Average Weighted Order Handling Fee Tax Average Average of the weighted order handling fee tax for all subscription items.
Average Weighted Order Shipping Average Average of the weighted order shipping for all subscription items.
Average Weighted Order Shipping Discount Average Average of the weighted order shipping discount for all subscription items.
Average Weighted Order Shipping Manual Adjustment Average Average of the weighted order shipping manual adjustment for all subscription items.
Average Weighted Order Shipping Tax Average Average of the weighted order shipping tax for all subscription items.
Average Weighted Order Tax Average Average of the weighted order tax for all subscription items.
Subscription Item Count Count The count of all subscription items.
Total Adjusted Line Item Subtotal Sum Sum of the adjusted line item subtotal for all subscription items.
Total Discount Total Sum Sum of the discount total for all subscription items.
Total Extended Total Sum Sum of the extended total for all subscription items.
Total Fee Total Sum Sum of the fee total for all subscription items.
Total Handling Amount Sum Sum of the hanlding amount for all subscription items.
Total Item Tax Total Sum Sum of the item tax for all subscription items.
Total Quantity Sum Sum of the quantity for all subscription items.
Total Sale Price Sum Sum of the sale price for all subscription items.
Total Shipping Amount Before Discounts And Adjustments Sum Sum of the shipping amount before discounts and adjustments for all subscription items.
Total Shipping Tax Total Sum Sum of the shipping tax total for all subscription items.
Total Shipping Total Sum Sum of the shipping total for all subscription items.
Total Subtotal Sum Sum of the subtotal for all subscription items.
Total Taxable Total Sum Sum of the taxable total for all subscription items.
Total Total Sum Sum of the total for all subscription items.
Total Total With Weighted Shipping And Handling Sum Sum of the total with weighted shipping and handling for all subscription items.
Total Total Without Weighted Shipping And Handling Sum Sum of the total without weighted shipping and handling for all subscription items.
Total Unit List Price Sum Sum of the unit list price for all subscription items.
Total Unit Sale Price Sum Sum of the unit sale price for all subscription items.
Total Weighted Order Adjustment Sum Sum of the weighted order adjustment for all subscription items.
Total Weighted Order Discount Sum Sum of the weighted order discount for all subscription items.
Total Weighted Order Duty Sum Sum of the weighted order duty for all subscription items.
Total Weighted Order Handling Adjustment Sum Sum of the weighted order handling adjustment for all subscription items.
Total Weighted Order Handling Fee Sum Sum of the weighted order handling fee for all subscription items.
Total Weighted Order Handling Fee Discount Sum Sum of the weighted order handling fee discount for all subscription items.
Total Weighted Order Handling Fee Tax Sum Sum of the weighted order handling fee tax for all subscription items.
Total Weighted Order Shipping Sum Sum of the weighted order shipping for all subscription items.
Total Weighted Order Shipping Discount Sum Sum of the weighted order shipping discount for all subscription items.
Total Weighted Order Shipping Manual Adjustment Sum Sum of the weighted order shipping manual adjustment for all subscription items.
Total Weighted Order Shipping Tax Sum Sum of the weighted order shipping tax for all subscription items.
Total Weighted Order Tax Sum Sum of the weighted order tax for all subscription items.

The dimensions included in this view are:

Name Data Type Description
Aggregate Inventory Number The total inventory of the item.
Allows Back Order Yes/No Whether the product supports backorder.
Are Discounts Restricted Yes/No If yes, the system cannot apply any discounts to this product.
Created Date Datetime The timestamp of the date and time the subscription item was created.
Currency Code String In addition to the original transactional currency, monetary amounts will also be converted to this currency.
Discount Applied On Sale Price Number The discount applied on the item.
Fulfillment Location Code String A user-provided unique ID for the fulfillment location.
Fulfillment Method String The method used to fulfill this order item such as direct ship or in-store pickup.
Fulfillment Method Status String The fulfillment status of the item.
Goods Type Name String The type of good that the product is. Possible values include Physical (for physical objects) and DigitalCredit (for gift cards).
Height Unit String Physical dimensions of the package required to ship the product and its height.
Height Value Number Physical dimensions of the package required to ship the product and its height.
Is Assembly Required Yes/No Indicates whether assembly is required for this order item.
Is Packaged Standalone Yes/No Indicates if the product must be shipped alone in a container. This is used for products and products within a bundle. If yes, this product cannot be shipped in a package with other items and must ship in a package by itself.
Is Product Discounted Yes/No Will be yes if the order item has a sale price lower than the list price.
Is Product on Backorder Yes/No Returns yes if product is currently backordered.
Is Recurring Yes/No Indicates if the product is purchased on a recurring schedule. If yes, the item can be purchased or fulfilled at regular intervals, such as a monthly billing cycle. For example, digital or physical product subscriptions are recurring cart items.
Is Stock Available Yes/No Whether there is stock of the product available.
Is Taxable Yes/No Indicates if the item is subject to taxation. If yes, the entity is subject to tax based on the relevant tax rate and rules.
Length Unit String Physical dimensions of the package required to ship the product and its length.
Length Value Number Physical dimensions of the package required to ship the product and its length.
Line ID Number The line id assigned to the order item. Visible only in the Admin, this is set from the Admin or in the Commerce APIs when a cart is converted to an order.
Manage Stock Yes/No Indicates if the item's stock is managed. If yes, Kibo eCommerce manages inventory levels for this product.
Price Number The full price of the product.
Price List Code Number A user-provided unique identifier for the price list.
Price List Entry Mode Number The configured mode for the price list entry.
Sale Price Number The sale price of the product.
Unit List Price Number The price that the item is listed for in the storefront.
Unit Sale Price Number The set sale price for the item consisting of a price with a discount already applied.
Product Description String The text description for the product.
Product Name String A user-provided, human-readable name for the product.
Product Type String Used to classify different types of products, such as Standard or Gift Certificate.
Product Usage Name String The usage type that applies to this product, such as Standard (a single product without configurable options).
Quantity Number The number of units of the item ordered.
Subscription Created Date Datetime The timestamp of the date and time that the subscription was created.
Days Since Created Datetime Number of days elapsed since the created date.
Subscription Updated Date Datetime The timestamp of the date and time that the subscription was most recently updated.
Days Since Updated Datetime Number of days elapsed since the updated date.
Hours Since Created Datetime Number of hours elapsed since the created date.
Hours Since Updated Datetime Number of hours elapsed since the updated date.
Minutes Since Created Datetime Number of minutes elapsed since the created date.
Minutes Since Updated Datetime Number of minutes elapsed since the updated date.
Adjusted Line Item Subtotal Number The adjusted subtotal of the line item including all manual adjustments, discounts, shipping charges and discounts, and duty or any other additional line item fees.
Discount Total Number The total monetary amount of all applied discounts.
Extended Total Number The total price of the item extended to the shopper. This begins with the unit price then uses any of the following prices if they are defined, in the following order: Override Amount, Sale Amount, List Amount.
Fee Total Number The sum of all fees incurred.
Handling Amount Number The handling cost, excluding taxes and discounts.
Item Tax Total Number The total amount of calculated tax for the item.
Shipping Amount Before Discounts And Adjustments Number The total shipping amount before discounts and adjustments.
Shipping Tax Total Number The total amount of tax incurred on the shipping charges.
Shipping Total Number The calculated total shipping amount, including tax.
Subtotal Number The total amount without sales tax, shipping costs, and other fees.
Taxable Total Number The monetary amount of an item that is subject to tax. This amount typically represents the line item subtotal before applied discounts for an order.
Total Number The total monetary amount including items, sales tax, shipping costs, and other fees.
Total With Weighted Shipping And Handling Number The total charge for the line item with all weighted order level shipping and handling charges.
Total Without Weighted Shipping And Handling Number The total charge for the line item without any weighted order level shipping and handling charges.
Transactional Currency Code String The currency in which the transaction was denominated.
Updated Date Datetime The timestamp of the date and time that the subscription item was most recently updated.
Variation Product Code String Merchant-created code associated with a specific product variation. Variation product codes maintain an association with the base product code.
Weight Unit String Physical dimensions of the package required to ship the product and its weight.
Weight Value Number Physical dimensions of the package required to ship the product and its weight.
Weighted Order Adjustment Number The total weighted order item level manual adjustment amount.
Weighted Order Discount Number The total weighted order item level discount amount.
Weighted Order Handling Adjustment Number The total weighted order handling adjustment amount.
Weighted Order Handling Fee Number The total weighted order item level handling fee amount.
Weighted Order Handling Fee Discount Number The total weighted order item level handling fee discount amount.
Weighted Order Handling Fee Tax Number The total weighted order item level handling fee tax amount.
Weighted Order Shipping Number The total weighted order item level shipping charge.
Weighted Order Shipping Discount Number The total weighted order item level shipping discount amount.
Weighted Order Shipping Manual Adjustment Number The total weighted order item level shipping discount manual adjustment amount.
Weighted Order Shipping Tax Number The total weighted order item level shipping tax amount.
Weighted Order Tax Number The total weighted order item level tax amount.
Width Unit String Physical dimensions of the package required to ship the product and its width.
Width Value Number Physical dimensions of the package required to ship the product and its width.