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

# Orders report

> Generate an orders report in Firmhouse filtered by creation date for operational reporting on subscription order volumes and fulfillment timelines.

The **orders** report allows you to generate a report of all orders in your project. You can filter orders by their creation date.

## Parameters

The report accepts the following parameters:

**Orders created after** - Filter to only include orders created on or after this date. Defaults to one month ago.

## Available fields

The report includes the following fields:

* **id** - The unique order identifier
* **subscription\_id** - The associated subscription ID
* **payment\_id** - The associated payment ID
* **status** - The order status (pending, confirmed, snoozed, cancelled, fulfilled, draft)
* **track\_and\_trace\_codes** - Tracking codes for the shipment
* **shipment\_date** - The scheduled or actual shipment date
* **order\_announcement\_sent\_at** - When the order announcement email was sent
* **order\_confirmation\_sent\_at** - When the order confirmation email was sent
* **created\_at** - When the order was created
* **subtotal\_incl\_tax** - Subtotal including tax
* **subtotal\_excl\_tax** - Subtotal excluding tax
* **total\_tax** - Total tax amount
* **shipping\_costs** - Shipping costs including tax
* **shipping\_costs\_excl\_tax** - Shipping costs excluding tax
* **amount** - Total order amount
* **currency** - Order currency
* **formatted\_number** - The formatted order number
* **order\_lines\_json** - Order line items in JSON format
* **order\_lines\_quantity** - Quantities of order line items
* **order\_lines\_product** - Product names in the order
* **order\_lines\_sku** - SKUs of products in the order
* **full\_address** - Complete delivery address
* **full\_name** - Customer's full name
* **address** - Street address
* **house\_number** - House number
* **zipcode** - Postal code
* **city** - City
* **state** - State or province
* **country** - Country
* **email** - Customer email
* **phone\_number** - Customer phone number

## FAQ

### What orders are included?

Only orders from subscriptions that have completed signup are included. Draft orders and orders from incomplete signups are excluded.

### Can I include custom extra fields?

Yes, if you have configured extra fields for orders in your project, these will also be available in the report.

### How are orders sorted?

Orders are sorted by creation date in descending order, with the most recent orders appearing first.