Export or download orders as CSV
Export all orders or a filtered set from Payments > Orders as a CSV file. JourneyCARE emails a secure download link to the logged-in user; the link is valid for 7 days, and exporting requires both the View Orders and Export Orders permissions.
Export orders
Start from the Orders page, apply the filters you want, and trigger the export; the file downloads from the emailed link.
Go to Payments > Orders.
Optionally apply filters, including order status, date range, source type (Funnel, Payment Link, Store Checkout), and product type (one-time or recurring).
Click Download.
Check your email for the download link.
The link expires after 7 days. If it expires, start a new export to regenerate it.
How rows map to orders
An order can occupy multiple CSV rows: multiple products and taxes produce separate product- or tax-level rows under the same order.
Group multi-row records by Internal order id when aggregating totals; the extra rows are not duplicate orders.
A value of 0 means the field applies and the value is truly zero; a blank means the field does not apply, such as the payment method on an unpaid order.
Unpaid or abandoned orders are included unless you filter them out.
The export shows order-level subscription presence, not subscription billing history. Use the Export or download subscriptions as CSV export for billing history.
Columns in the export
The export lists order-level columns first, followed by line item, tax, and address columns, then processing charge columns.
Column | Description |
|---|---|
Internal order id | Internal identifier for the order |
Location id | Location identifier |
Customer id | ID of the customer who placed the order |
Customer name | Customer display name |
Customer email | Email collected via checkout |
Customer phone | Phone collected via checkout |
Payment method | Method collected during checkout; blank if unpaid |
Currency | Currency of the product pricing |
Sub total | Total value of items before discounts and exclusive taxes |
Discount | Discounts applied to the order |
Total tax amount (excluded in prices) | Tax added on top of the subtotal |
Total tax amount (included in prices) | Tax already included in item prices |
Total amount | Total payable after discounts, taxes, and miscellaneous charges |
Coupon code | Code used at checkout, if any |
Status | Order payment status |
Live mode | Whether the record is test or live |
Total products | Total number of products in the order |
One-time products | Number of one-time products |
Recurring products | Number of subscription products |
Source type | Entry point where the order was created |
Source id | Internal ID of the source |
Source name | Display name of the source |
Order date | Date the order was finalized |
Order time | Time the order was finalized |
Timezone | Timezone of the order record |
Column | Description |
|---|---|
Line item name | Product name |
Line item quantity | Quantity purchased |
Line item price | Price per product unit |
Line item discount | Discount allocated to the line |
Line item subtotal | Subtotal for the product line |
Line item product id | System identifier for the product |
Line item price id | Identifier for the price or variant |
Tax name | Tax type applied |
Tax amount | Tax amount for the line |
Address line 1 | Shipping or billing street, if captured |
City | City |
State | State or region |
Country | Country |
Postal code | ZIP or postal code |
Processing charge name | Miscellaneous charge name |
Processing charge amount | Miscellaneous charge value |
Exports are generated fresh each time. Processing-charge details in the export reflect the fee configuration; see Add processing charges or additional fees to payments for how the charge is calculated, and Export or download transactions as CSV for transaction-level data.
Export abandoned checkouts
The Abandoned Checkouts page has its own search, filters, and CSV export, separate from the general Orders export above.
Go to Payments > Orders > Abandoned Checkouts.
Search by customer name or email, or add filters for Email Status, Recovery Status, or Date Range.
Select one or more records and click Export CSV.
The export includes customer, cart, product, activity, and recovery details. Select All applies only to the current page, and exports of more than 5,000 records are delivered by email. Configure Notifications opens the abandoned cart notification settings, and opening an abandoned checkout lets you copy and share its checkout URL with the customer.