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

# Orders

> Order lines by the day the order was placed, shipped or not: units, revenue, orders and margin over a date range.

Order lines by the day the order was placed, shipped or not: units, revenue, orders and margin over a date range.

## Example

```sql theme={null}
FROM orders
  SHOW units_sold, line_count
  GROUP BY product
  ORDER BY units_sold DESC
```

## Metrics

| Metric | Type | Description |
| - | - | - |
| `units_sold` | Number | Units sold in the selected period. |
| `line_count` | Number | Number of order lines placed in the period. |
| `total_revenue` | Currency | Gross revenue from sales in the period. |
| `unit_cost` | Currency | Cost per unit; 0 when no cost is set. |
| `total_cogs` | Currency | Cost of goods sold (units sold × unit cost) in the period. |
| `gross_profit` | Currency | Revenue minus cost of goods sold in the period. |
| `landed_cogs` | Currency | Cost of goods sold at true landed cost, including allocated freight and duties. |
| `landed_gross_profit` | Currency | Revenue minus landed cost of goods sold - margin after freight and duties. |
| `period_days` | Number | How many days the report's date range covers. |
| `landed_margin_pct` | Percent | Landed gross profit as a percentage of revenue. |
| `profit_margin` | Percent | Gross profit as a percentage of revenue. |
| `order_count` | Number | Number of orders placed in the period. |
| `avg_order_value` | Currency | Revenue per order in the period, counting only the lines in this report's scope. |

## Dimensions

| Dimension | Description |
| - | - |
| `product` | Product with image, rendered as a single cell (variants roll up). |
| `sku` | Variant SKU - splits a product-grain report into variant rows. |
| `variant` | Variant title (e.g. "Small / Blue"), shown as a dash for products without options. Group by product too - on its own, variants sharing a title across different products fall into one row. |
| `barcode` | Variant barcode (GTIN/UPC/EAN/ISBN), grouping under a blank value when none. |
| `category` | Shopify product category (full taxonomy path). |
| `collection` | Shopify collection - a SKU appears under each collection it belongs to (cross-collection totals overlap), grouping under a blank value when it is in none. |
| `location` | Sales location. |
| `vendor` | Product vendor. |
| `product_type` | Shopify product type. |
| `tag` | Individual product tag - a SKU appears under each of its tags (cross-tag totals overlap). |
| `location_role` | Whether the fulfilling location acts as a hub or a fulfillment location. |
| `order_channel` | The channel the order came through, such as the online store, POS, or a marketplace. Orders with no recorded channel group under Unknown. |
| `order_source` | Where the order was placed: web, POS, or a channel app. Coarser than order channel; use it to split online from in-person. |
| `promotion` | The declared promotion covering the sale date, from the promotion calendar. Days outside every declared window group under None. |

## Filters

| Filter | Type | Description |
| - | - | - |
| `collection` | Number | Restrict to products in the selected collection(s). |
| `category` | Text | Restrict to products in the selected category (matches sub-categories too). |
| `sales_channel` | Number | Restrict to products published to the selected sales channel. |
| `region_catalog` | Number | Restrict to products in the selected region (market) catalog. |
| `b2b_catalog` | Number | Restrict to products in the selected B2B (market) catalog. |
| `company_location_catalog` | Number | Restrict to products in the selected company-location catalog. |
| `order_channel` | Text | The channel the order came through. Distinct from sales channel, which filters on where a product is listed rather than where an order came from. |
| `order_source` | Text | Where the order was placed: web, POS, or a channel app. |
| `vendor` | Text | Product vendor. |
| `product_type` | Text | Shopify product type. |
| `product_title` | Text | Product title. |
| `sku` | Text | Variant SKU. |
| `barcode` | Text | Variant barcode. |
| `location_name` | Text | Sales location name. |
| `promotion` | Text | Name of the declared promotion covering the sale date. Null outside every declared window. |

## Related datasets

* [Sales](/stockfulql/datasets/sales)
* [Sales trends](/stockfulql/datasets/sales_history)
* [Returns](/stockfulql/datasets/returns)
* [Promotions](/stockfulql/datasets/promo)


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