Export or Download Orders as CSV

Modified on: Tue, 9 Dec, 2025 at 11:15 PM

This help guide explains how to export Orders records into a CSV file for reporting, reconciliation, financial analysis, fulfillment, and product performance tracking.


Overview

The Orders CSV Export feature allows you to download detailed order records from your Payments → Orders dashboard.

You can export:

  • All Orders, or

  • Only Orders that match filters/search selection

Exports are sent via email as a secure download link.


TABLE OF CONTENTS


How to Export Orders

  1. Go to Payments → Orders

  2. (Optional) Apply filters such as:

    • Order status

    • Date range

    • Source type (Funnel, Payment Link, Store Checkout, etc.)

    • Product type (one-time vs recurring)

  3. Click Download

  4. Check your email for the download link

Security Reminder: The export link expires after 7 days.
If expired, simply start a new export.


Understanding the CSV Format

Orders may include multiple:

  • Products

  • Taxes

Therefore, a single order can spread across multiple rows in the file.

This helps display product-level pricing and tax clarity needed for bookkeeping and analytics.


Column Reference Guide (with examples)

Column NameDescriptionExample
Internal order idHighLevel internal identifier for the order69369a9968f735180bfeb6ed
Location idSub-account identifierNyGCsdhgRZ8Ffa8Ssagfhd
Customer idID of the customer who placed the orderjbtyjkzMjvd8cLi9HUC
Customer nameCustomer display nameJordan Lane
Customer emailEmail collected via checkoutjordan@example.com
Customer phonePhone collected via checkout+44 7700 900111
Payment methodMethod collected during checkout; blank if unpaid orderCredit Card, Cash, Instant Transfer
CurrencyCurrency of product pricingUSD
Sub totalTotal value of items before discount & exclusive taxes120.00
DiscountDiscounts applied to the order-20.00
Total tax amount (excluded in prices)Tax added on top of subtotal8.40
Total tax amount (included in prices)Tax already part of item prices0.00
Total amountTotal payable after discounts + taxes + misc charges108.40
Coupon codeCode used at checkout (if any)SPRING20
StatusOrder's Payment statusCompleted, Pending
Live modeConfirms Test vs Live environmentYes, No
Total productsTotal number of products in the order3
One-time productsNumber of one-time products in order2
Recurring productsNumber of subscription products in order1
Source typeEntry point where order was createdStore Checkout, Form, Funnel
Source idInternal ID of the sourceafalfgn4ag12neogho
Source nameDisplay name of the sourceGift Card Store
Order dateDate the order was finalizedDec 10, 2025
Order timeTime the order was finalized10:45 AM
TimezoneTimezone of the order recordAmerica/Chicago
Line item nameProduct namePremium Coaching Plan
Line item quantityQuantity purchased of this product1
Line item pricePrice per unit of product100.00
Line item discountDiscount allocated to this line20.00
Line item subtotalSubtotal for the product line80.00
Line item product idSystem identifier for productprod_52ZS
Line item price idIdentifier for price or variantprice_00382
Tax nameTax type appliedSales Tax
Tax amountAmount of tax for this line5.60
Address line 1Shipping/billing street (if captured)123 Main St
CityCityAustin
StateState/RegionTX
CountryCountryUS
Postal codeZip or postal code73301
Processing charge nameAny miscellaneous charge nameHandling Fee
Processing charge amountValue of misc charge2.80

How Multi-Row Orders Work (Important)

Example 1:
A single order with:

  • 3 products

  • 2 taxes - both exclusive

The CSV could generate a total of 6 rows:

  • 2 rows for each products

  • 6 rows for taxes, where tax amount against each tax name for each product is a new row
    → All share the same Order id


Example 2:
A single order with:

  • 3 products

  • 2 taxes - both exclusive on product 1, both inclusive on product 2 and no tax on product 3.

The CSV could generate a total of 5 rows:

  • 2 rows for 2 products and 1 row for the 3rd product

  • 4 rows for taxes i.e. first 2 taxes are in the format <Tax Name 1> and <Tax Name 2> and next 2 taxes are in the format <Tax Name 1 (Included in prices)> and <Tax Name 2 (Included in prices)>; 5th row doesn't have any values in the tax columns
    → All share the same Order id


FAQs

1. Why am I seeing multiple rows for the same order?

Because each product and product tax requires a separate accounting line for accurate reporting.


2. Why is Payment Method empty on some orders?

Orders only show a payment method if a transaction occurred.


3. Will unpaid or abandoned orders be included?

Yes — unless filtered out.


4. Can I check subscription billing details from this export?

This export shows order-level subscription presence (count), not subscription billing history.
Use Subscriptions CSV Export for that.


5. Can I re-export past orders?

Yes — exports are always generated fresh.


6. Who can download order exports?

Users with permissions to:
✔ View Orders
✔ Export Orders

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article