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