> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sourcemedium.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# dim_order_lines

> Order line dimension for product-level attributes at line grain.

<Note>
  **Pro warehouses only.** This table is not delivered on Foundation warehouses. On Foundation, start from [`obt_order_lines`](/docs/data-activation/data-tables/sm_transformed_v2/obt_order_lines). See [Foundation and Pro](/docs/data-activation/managed-data-warehouse/overview).
</Note>

Order line dimension for product-level attributes at line grain.

* **Grain:** One row per sm\_order\_line\_key. No canonical date; \_synced\_at is a freshness timestamp (not for analysis).
* **Filters to start with:** source\_system for platform-specific line-item coverage.
* **Joins:** dim\_orders via sm\_order\_key (many:1); dim\_product\_variants via sm\_product\_variant\_key (many:1).

## Columns

| Column | Type | Description |
| - | - | - |
| `sm_order_key` | STRING | Stable SourceMedium order key. Unique per order. Key joins: `obt_order_lines` (1:many via `sm_order_key`); `dim_customers` (many:1 via `sm_customer_key`). Platform caveat: TikTok Shop coverage may be limited. |
| `sm_order_line_key` | STRING | Stable SourceMedium order line key. Unique per line. Key joins: `dim_order_lines` (1:1); `dim_orders` (many:1 via `sm_order_key`). Platform caveat: TikTok Shop coverage may be limited. |
| `sm_product_key` | STRING | Stable SourceMedium join key for products to related tables. |
| `sm_product_variant_key` | STRING | Stable SourceMedium join key for product variants to related tables. |
| `sm_store_id` | STRING | SourceMedium's unique store identifier. For Shopify stores, derived from the myshopify.com domain; for other platforms (Amazon, TikTok Shop, Walmart.com), uses platform-specific identifiers. |
| `order_line_id` | STRING | The ID of the order line. |
| `order_line_price` | FLOAT64 | The price of a single unit of the product at the time of purchase (before line-level discounts). Multiply by order\_line\_quantity to get total line revenue. |
| `order_line_product_title` | STRING | The title of the product that the order line represents. |
| `order_line_product_variant_title` | STRING | The title of the product variant that the order line represents. For Shopify workspaces on the v3 (GraphQL) feed, a deleted product leaves the line's variant reference null, so the current catalog can no longer supply the title. It is then parsed from the order-time line name, which Shopify formats as "\{product title} - \{variant title}". The current catalog title always wins where it still exists, so renamed variants read consistently with the rest of the catalog. Null where the product has only a single default variant, since no variant title exists to record. |
| `order_line_quantity` | NUMERIC | The number of units of the product variant ordered in this line item. Used to calculate total line revenue (order\_line\_price \* order\_line\_quantity). |
| `product_id` | STRING | Platform-specific product identifier from the source system. Links to the parent product that this line item's variant belongs to. |
| `product_variant_id` | STRING | A unique identifier for the product variant generated by the source system. |
| `sku` | STRING | The stock keeping unit (SKU) of the product variant. |
| `source_system` | STRING | Originating platform for the record (e.g., Shopify, Amazon, TikTok Shop, Chargebee). Used for platform‑specific behavior and coverage. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.