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_itemtable 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)