The Sales_Flat_Order_Item Table

The sales_flat_order_item table is an order items table. Each row represents one line item included in an order.

 

Common Columns

Column Name	Description
item_id	Unique identifier for the table
qty_ordered	Quantity of an item which is included in an order
price	Cost of a each individual line item
name	An item's name
order_id	Foreign key associated with the 'sales_flat_order` table
sku	An item's associated SKU
product_id	Foreign key associated with the `catalog_product_entity` table
product_type	Determines if the product is 'simple', 'configurable', 'bundle' or 'downloadable'

 

Common Calculated Columns

Column Name	Description
Order item total value	The `price` multiplied by `qty_ordered`
Order date	The `created_at` date column from the `sales_flat_order` table. This is a joined column

 

Common Metrics

Click to view full list

Metric Name	Metric Description	Metric Construction
Items Sold	Represents the quantity of items sold	Operation Column: qty_ordered  Operation: Sum  Timestamp Column: created_at
Revenue by item	The total item value sold. As this is calculated on the line item level, shipping, taxes, and other order level costs are not included.	Operation Column: Order item total value  Operation: Sum  Timestamp Column: created_at

 

Connections to Other Tables

sales_flat_order

• Create joined columns to segment and filter by order level attributes on the sales_flat_order_item table via the following path:
• sales_flat_order_item.order_id (many) => sales_flat_order.entity_id (one)

catalog_product_entity

• Create joined columns related to product attributes:
• sales_flat_order_item.product_id (many) => catalog_product_entity.entity_id (one)