Skip to main content
The order lines report allows you to generate a detailed report of all individual line items from orders in your project. This report provides granular data about each product in every order.

​
Parameters

The report accepts the following parameters: Orders created after - Filter to only include order lines from orders created on or after this date. Defaults to one month ago. Orders created before - Filter to only include order lines from orders created on or before this date. Defaults to today.

​
Available fields

The report includes the following fields:
  • id - The unique identifier of the order line
  • order_id - The associated order ID
  • subscription_id - The associated subscription ID
  • invoice_id - The associated invoice ID
  • status - The order status (numeric)
  • status_label - The order status label (pending, confirmed, snoozed, cancelled, fulfilled)
  • 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 line was created
  • quantity - The quantity of the product
  • title - The product title
  • slug - The product slug
  • sku - The product SKU
  • name - Customer first name
  • last_name - Customer last name
  • address - Street address
  • house_number - House number
  • zipcode - Postal code
  • city - City
  • state - State or province
  • country - Country
  • salutation - Customer salutation
  • email - Customer email
  • phone_number - Customer phone number
  • amount_including_tax - The line amount including tax
  • next_billing_date - The next billing date for the subscription
  • formatted_number - The formatted invoice number
  • subscription_active_plan_name - The name of the active plan
  • ordered_product_type - The type of ordered product
  • fulfilled_orders - Count of fulfilled orders for the subscription
  • subscription_first_applied_code - The first discount code applied to the subscription
  • queued_products - Count of queued products for the subscription

​
FAQ

​
What order lines are included?

Only order lines from completed signups are included. Draft orders and order lines from incomplete signups are excluded.

​
How are order lines sorted?

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

​
What is the difference between the Orders report and Order Lines report?

The Orders report provides one row per order with summarized information, while the Order Lines report provides one row per product in each order. Use Order Lines when you need detailed product-level data.