文件CommerceCommerce Intelligence使用手冊

quote_item Table

最後更新： 2026年3月24日

建立對象：

  • Beginner
  • Intermediate
  • Admin
  • Developer
  • User

The quote_item table (sales_flat_quote_item on M1) contains records on every item added to a shopping cart, whether the cart was abandoned or converted to a purchase. Each row represents one cart item. Due to the potential size of this table, Adobe recommends you periodically delete records if certain criteria are met, such as if there are any unconverted carts older than 60 days.

NOTE
Analyzing historical, abandoned carts is only possible if you do not delete records from the quote and quote_item table. 如果您確實刪除記錄，則只能看到尚未從資料庫移除的購物車。

通用原生欄

資料行名稱
描述
base_price
Price of an individual unit of a product at the time the item was added to a cart, after catalog price rules, tiered discounts, and special pricing are applied and before any taxes, shipping, or cart discounts are applied. 以商店的基本貨幣表示。
created_at
Creation timestamp of the cart item, stored locally in UTC. Depending on your configuration in Commerce Intelligence, this timestamp may be converted to a reporting time zone in Commerce Intelligence that differs from your database time zone
item_id (PK)
Unique identifier for the table
name
Text name of the order item
parent_item_id
將簡單產品與其上層組合或可設定產品相關的Foreign key。 加入quote_item.item_id以決定與簡單產品相關聯的父產品屬性。 For parent cart items (that is, bundle or configurable product types), the parent_item_id is NULL
product_id
與Foreign key資料表關聯的catalog_product_entity。 Join to catalog_product_entity.entity_id to determine product attributes associated with the order item
product_type
Type of product that was added to the cart. Potential product types include: simple, configurable, grouped, virtual, bundle, and downloadable
qty
Quantity of units included in the cart for the particular cart item
quote_id
與Foreign key資料表關聯的quote。 Join to quote.entity_id to determine cart attributes associated with the cart item
sku
Unique identifier for the cart item
store_id
與store資料表相關聯的外部索引鍵。 Join to store.store_id to determine which Commerce store view is associated with the cart item

通用計算欄

資料行名稱
描述
Cart creation date
Timestamp associated with the cart creation date. Calculated by joining quote_item.quote_id to quote.entity_id and returning the created_at timestamp
Cart is active? (1/0)
Boolean field that returns “1” if the cart was created by a customer and has not yet converted to an order. Returns “0” for converted carts, or carts created through the admin. 透過加入quote_item.quote_id至quote.entity_id並傳回is_active欄位進行計算
Cart item total value (qty * base_price)
Total value of an item at the time the item was added to a cart, after catalog price rules, tiered discounts, and special pricing are applied and before any taxes, shipping, or cart discounts are applied. Calculated by multiplying the qty by the base_price
Seconds since cart creation
Elapsed time between the cart’s creation date and now. 透過加入quote_item.quote_id至quote.entity_id並傳回Seconds since cart creation欄位進行計算
Store name
與訂單專案相關聯的Commerce商店名稱。 透過加入sales_order_item.store_id至store.store_id並傳回name欄位進行計算

通用量度

量度名稱
描述
建構
Number of abandoned cart items
Total quantity of items added to carts that meet specific “abandonment” conditions
Operation: Sum
Operand: qty
Timestamp: Cart creation date
Filters:

- [A] Cart is active? (1/0) = 1
- [B] Seconds since cart creation > x, where “x” corresponds to the elapsed time (in seconds) since cart creation beyond which a cart is considered abandoned
Abandoned cart item value
Sum of total revenue associated with carts that meet specific “abandonment” conditions
Operation: Sum
Operand: Cart item total value (qty * base_price)
Timestamp: Cart creation date
Filters:

- [A] Cart is active? (1/0) = 1
- [B] Seconds since cart creation > x, where “x” corresponds to the elapsed time (in seconds) since cart creation beyond which a cart is considered abandoned

Foreign Key Joining Paths

catalog_product_entity

  • Join to catalog_product_entity table to create columns that return product attributes associated with the cart item.
    • 路徑： quote_item.product_id （許多） => catalog_product_entity.entity_id （一個）

quote

  • Join to quote table to create new cart-level columns associated with the cart item.
    • 路徑： quote_item.quote_id （許多） => quote.entity_id （一個）

quote_item

  • 加入quote_item以建立將上層可設定或套件SKU的詳細資訊與簡單產品關聯的資料行。 若是在Data Warehouse管理員中建置，請連絡支援以取得設定這些計算的協助。
    • 路徑： quote_item.parent_item_id （許多） => quote_item.item_id （一個）

store

  • Join to store table to create columns that return details related to the Commerce store associated with the cart item.
    • 路徑： quote_item.store_id （許多） => store.store_id （一個）
recommendation-more-help
commerce-business-intelligence-help-mbi