Magento Business Intelligence Help Center

The Sales_Flat_Quote_Item Table

The sales_flat_quote_item (quote_item in Magento 2.x) table 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, many businesses delete records from this table after a certain set of criteria are met (i.e. delete all non-converted carts 60 days after created).  

Note that analyzing historical abandoned carts is only possible if you do not delete records from the sales_flat_quote and sales_flat_quote_item table. If you do delete records, you will only be able to see the carts not yet removed from your database.

 

Common Native Columns

Column Name Description
item_id Unique identifier for the table. Each `item_id` represents a unique cart item 
created_at Creation date for the cart item, usually stored in UTC 
quote_id Foreign key associated with the `sales_flat_quote` table 
product_id Foreign key associated with the `catalog_product_entity` table 
price Price of each individual cart item 
qty Quantity of an item which is included in the cart 
row_total Total value of a cart item row, represented by (price x qty) 
name  Name associated with a cart item 
sku  A cart item's associated SKU 
product_type Determines if the product is 'simple', 'configurable', 'bundle', or 'downloadable' 

 

Common Calculated Columns

Column Name Description
Cart creation date  The `created_at` timestamp associated with the cart creation date 
Seconds since cart creation  Total elapsed time since the cart was created  
Cart is active? (1/0)  Returns `is_active` value associated with cart 
Cart's item count  Returns the total `items_count` associated with cart 

 

Common Metrics

Click to view full list
Metric Name Metric Description Metric Construction
Number of abandoned cart items  Total quantity of items abandoned 

Operation Column: qty

Operation: Sum

Timestamp Column: Cart creation date

Filters:

[A] Cart is active? (1/0) = 1

[B] Cart's item count > 0

[C] Seconds since cart creation > x, where "x" corresponds to the number of seconds since cart creation before it is considered abandoned

Abandoned cart item value  Sum of total abandoned cart item value 

Operation Column: row_total

Operation: Sum

Timestamp Column: Cart creation date

Filters:

[A] Cart is active? (1/0) = 1

[B] Cart's item count > 0

[C] Seconds since cart creation > x, where "x" corresponds to the number of seconds since cart creation before it is considered abandoned

 

Connections to Other Tables

sales_flat_quote

  • Links cart items to cart level details, such as the cart creation date or status of a cart:
    • Magento 1.x: sales_flat_quote_item.quote_id (many) => sales_flat_quote.entity_id (one)
    • Magento 2.x: quote_item.quote_id (many) => quote.entity_id (one)

catalog_product_entity

  • Links cart items to product level details, to determine product attributes associated with cart items:
    • Magento 1.x: sales_flat_quote_item.product_id (many) => catalog_product_entity.entity_id (one)
    • Magento 2.x: quote_item.product_id (many) => catalog_product_entity.entity_id (one)

 

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk