Order Item View

The Order Item view provides dimensions and measures related to the items purchased within orders.

The supported filters that can be applied to this view are:

Name Data Type Description
Order Item Created Date Filter Datetime Filters results by Order Item Created Date.
Site Name Filter String Filters results by Site Name.

The measures calculated by this view are:

Name Measure Type Description
Average Days Since Product Stock Available Average Average number of days elapsed since the Product Stock Available Date.
Average Hours Since Product Stock Available Average Average number of hours elapsed since the Product Stock Available Date.
Average Item Discount Total Average Average of Discount Total for all order items.
Average Item Duty Amount Average Average of Duty Amount for all order items.
Average Item Extended Total Average Average of Extended Total for all order items.
Average Item Fee Total Average Average of Fee Total for all order items.
Average Item Handling Amount Average Average of Handling Amount for all order items.
Average Item Price Average The sum of the item catalog price less discounts averaged over the quantity sold.
AverageAverage Item Product Sale Price Average Average of Product Sale Price for all order items.
Average Item Product Tenant Override Price Average Average of Product Tenant Override Price for all order items.
Average Item Sale Price Average Average of Sale Price for all order items.
Average Item Shipping Total Average Average of Shipping Total for all order items.
Average Item Subtotal Average Average of Subtotal for all order items.
Average Item Tax Total Average Average of Item Tax Total for all order items.
Average Item Taxable Total Average Average of Taxable Total for all order items.
Average Item Total Average Average of Item Total for all order items.
Average Item Total With Weighted Shipping And Handling Average Average of Total With Weighted Shipping and Handling for all order items.
Average Item Total Without Weighted Shipping And Handling Average Average of Total Without Weighted Shipping and Handling for all order items.
Average Item Unit List Price Average Average of List Price for all order items.
Average Item Unit Override Price Average Average of Override Price for all order items.
Average Item Unit Price Extended Amount Average Average of Extended Unit Price for all order items.
Average Item Weighted Order Adjustment Average Average of Weighted Order Adjustment for all order items.
Average Item Weighted Order Discount Average Average of Weighted Order Discount for all order items.
Average Line Item Adjusted Subtotal Average Average of Adjusted Line Item Subtotal for all order items.
Average Order Value Average The total order total divided by the valid order count.
Average Product MSRP Average Average of Product MSRP Price for all order items.
Average Product Price Average Average of Product Price for all order items.
Average Quantity Average Average of Quantity for all order items.
Average Valid Order Item Total Average The average of order item total across all valid orders.
Items Per Order Average The valid order items count divided by the valid order count.
Order Item Count Count The count of all order items.
Total Item Discount Total Sum Sum of discount total for all order items.
Total Item Duty Amount Sum Sum of Duty Amount for all order items.
Total Item Extended Total Sum Sum of Extended Total for all order items.
Total Item Fee Total Sum Sum of Fee Total for all order items.
Total Item Handling Amount Sum Sum of Handling Amount for all order items.
Total Item Product Sale Price Sum Sum of Product Sale Price for all order items.
Total Item Product Tenant Override Price Sum Sum of Product Tenant Override Price for all order items.
Total Item Sale Price Sum Sum of Sale Price for all order items.
Total Item Shipping Total Sum Sum of Shipping Total for all order items.
Total Item Subtotal Sum Sum of Subtotal for all order items.
Total Item Tax Total Sum Sum of Item Tax Total for all order items.
Total Item Taxable Total Sum Sum of Taxable Total for all order items.
Total Item Total Sum Sum of Item Total for all order items.
Total Item Total With Weighted Shipping And Handling Sum Sum of Total With Weighted Shipping and Handling for all order items.
Total Item Total Without Weighted Shipping And Handling Sum Sum of Total Without Weighted Shipping and Handling for all order items.
Total Item Unit List Price Sum Sum of List Price for all order items.
Total Item Unit Override Price Sum Sum of Override Price for all order items.
Total Item Unit Price Extended Amount Sum Sum of Extended Unit Price for all order items.
Total Item Weighted Order Adjustment Sum Sum of Weighted Order Adjustment for all order items.
Total Item Weighted Order Discount Sum Sum of Weighted Order Discount for all order items.
Total Line Item Adjusted Subtotal Sum Sum of Adjusted Line Item Subtotal for all order items.
Total Valid Order Item Total Sum Sum of order item total for all valid orders.
Total Product MSRP Sum Sum of Product MSRP Price for all order items.
Total Product Price Sum Sum of Product Price for all order items.
Total Quantity Sum Sum of Quantity for all order items.
Total Valid Order Quantity Sum Sum of quantity for all order items belonging to valid orders.
Valid Order Items Count Count (Distinct) The count of order items where valid order status is yes.

The dimensions included in this view are:

Name Data Type Description
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.
Catalog ID Number Unique identifier for the product catalog to which the product category belongs.
Days Since Product Stock Available Number Number of days elapsed since the Product Stock Available Date.
Duty Amount Number Duty or tariff for this item.
Handling Amount Number The combined price for all handling costs calculated together for shipped orders, not for digital or in-store pickup. This includes all handling costs per the product line items and options, excluding taxes and discounts.
Hours Since Product Stock Available Number Number of hours elapsed since the Product Stock Available Date.
Is Product Discounted Yes/No Will be yes if the order item has a sale price lower than the list price.
Item Discount Total Number Amount of discounts applied to the order item.
Item 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.
Item Fee Total Number The monetary sum of all fees incurred for the order item.
Item Fulfillment Location Code String The code that identifies the location used to fulfill the order item. This code can include physical store locations for in-store pickup, warehouse locations providing the products for shipment, or the location for the digital file(s).
Item Fulfillment Method String The method used to fulfill this order item. The method includes direct ship or in-store pickup.
Item Fulfillment Status String The current fulfillment status of the item such as Fulfilled, NotFulfilled, or PartiallyFulfilled.
Item Locale String The two character locale code, per the country code provided.
Item Sale Price Number The set sale price for the item consisting of a price with a discount already applied.
Item Shipping Total Number The calculated total shipping amount for the order item including tax.
Item Subtotal Number Amount of the order without sales tax, shipping costs, and other fees.
Item Tax Total Number The total monetary sum of tax for an order item.
Item 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.
Item Total Number The total monetary amount of the order item including item subtotal, sales tax, shipping costs, and other fees.
Item Unit List Price Number The price the item is listed for in the storefront.
Item Unit Override Price Number The override price of the item set by the merchant for a given order.
Line ID Number The line id assigned to the order item. Visible only in the Admin, this is set from the Admin or in CommerceRuntime when a cart is converted to an order.
Order ID Number Internal unique identifier of the order with which the item is associated.
Order Item Created Date Datetime The timestamp of the date and time the order item was created.
Order Item ID String Internal unique identifier of the order item.
Order Item Updated Date Datetime The timestamp of the date and time the order item was most recently updated.
Order Number String Storefront identifier of the order.
Order Status String The current status of the order such as "Abandoned," "Accepted," "Cancelled," "Completed," "Errored," "Pending," "PendingReview," "Processing," or "Validated."
Product Code String The unique user-defined identifier for a product.
Product Goods Type String The type of goods in a bundled product. A bundled product is composed of products associated to sell together. Possible values include "Physical" and "DigitalCredit." This comes from the productType of the product. Products are defaulted to a Physical goodsType. Gift cards have a goodsType of DigitalCredit.
Product Name String The user supplied name of the product.
Product Price Number Full price of the product.
Product Price MSRP Number The manufacturer's suggested retail price (MSRP) for the product. This content may be defined by the supplier.
Product Price Sale Price Number The set sale price for a product consisting of a price with a discount already applied. For price list entries, this property is the product's sale price if the priceListEntryPrice.salePriceMode is set to Overridden.
Product Price Tenant Override Price Number The override price defined by the tenant for this cart or order item.
Product SKU String Product stock keeping unit.
Product Stock Available Date Datetime Date when product stock is available.
Product Type String Used to classify different types of products such as "Standard" or "Gift Certificate."
Product SKU String The universal product code (UPC) is the barcode defined for the product. The UPC is unique across all sales channels.
Purchase Location String The location where the item was purchased.
Quantity Number The number of units of the item ordered.
Site ID Number Unique identifier for the site. This ID is used at all levels of a store and catalog to associate objects to a site.
Site Name String The human readable name for the site associated with the Site ID.
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.
Unit Price Extended Amount Number The total shipping amount for the line item before discounts and adjustments.
Valid Order Status Yes/No Returns yes if the order status is not one of "Submitted," "PendingReview," "Pending," "Abandoned," "Cancelled," or "Errored."
Variation Product Code String Merchant-created code associated with a specific product variation. Variation product codes maintain an association with the base product code.
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.