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.

Catalog

Customers

B2B

Fulfillment

Inventory

Locations

Marketing

Orders

Publishing

Order Routing

Reporting

Search

Subscriptions

System

Call Center

Content

Import/Export