How to Export Orders as CSV in Sparkforge
Export orders to CSV from Payments → Orders in Sparkforge. Filter by status, date range, source type, or product type. The file arrives via a 7-day email link and uses a multi-row format with products and taxes broken out under a shared order ID.
The Orders CSV export pulls detailed order records for reporting, reconciliation, financial analysis, fulfillment, and product performance tracking.
How to export orders
- Go to Payments → Orders.
- (Optional) Apply filters: order status, date range, source type (Funnel, Payment Link, Store Checkout), product type (one-time vs recurring).
- Click Download.
- Check your email for the secure download link.
The link expires after 7 days. If it expires, start a new export.
CSV format
An order can contain multiple products and multiple taxes, so a single order can spread across multiple rows. This breakout is intentional for product-level pricing and tax detail required by bookkeeping and analytics.
Data consistency
0 vs blank
- 0 appears only when the field applies and the value is truly zero.
- Blank appears when the field does not apply (for example, a payment method on an unpaid order).
Stable structure for reporting
- Column ordering is consistent for pivots, imports, and BI pipelines.
- Multi-row orders are expected when products and tax entries exist. Group totals using Internal order id.
Column reference
| Column | Description | Example |
|---|---|---|
| Internal order id | Sparkforge order identifier | 69369a9968f735180bfeb6ed |
| Location id | Sub-account identifier | NyGCsdhgRZ8Ffa8Ssagfhd |
| Customer id / name / email / phone | Customer identity from checkout | Jordan Lane, jordan@example.com |
| Payment method | Method captured at checkout (blank if unpaid) | Credit Card, Cash, Instant Transfer |
| Currency | Currency of product pricing | USD |
| Sub total | Items before discount and exclusive taxes | 120.00 |
| Discount | Discounts applied to the order | -20.00 |
| Total tax (excluded in prices) | Tax added on top of subtotal | 8.40 |
| Total tax (included in prices) | Tax already inside item prices | 0.00 |
| Total amount | Total payable after discounts, taxes, misc charges | 108.40 |
| Coupon code | Code used at checkout | SPRING20 |
| Status | Payment status | Completed, Pending |
| Live mode | Live or test environment | Yes, No |
| Total products / one-time / recurring | Product counts in the order | 3 / 2 / 1 |
| Source type / id / name | Where the order originated | Store Checkout, Form, Funnel |
| Order date / time / timezone | When the order finalized | Dec 10, 2025, 10:45 AM, America/Chicago |
| Line item name / quantity / price / discount / subtotal | Per-product details | Premium Coaching Plan, 1, 100.00, 20.00, 80.00 |
| Line item product id / price id | Product and price/variant identifiers | prod_52ZS, price_00382 |
| Tax name / amount | Tax line per unique tax | Sales Tax, 5.60 |
| Address line 1 / city / state / country / postal code | Shipping or billing address if captured | 123 Main St, Austin, TX, US, 73301 |
| Processing charge name / amount | Miscellaneous charge | Handling Fee, 2.80 |
How multi-row orders work
Example 1
An order with 3 products and 2 exclusive taxes can produce 6 rows total — multiple product rows plus a row per tax-name-per-product. All rows share the same order id.
Example 2
An order with 3 products where the first has 2 exclusive taxes, the second has 2 inclusive taxes, and the third has no tax can produce 5 rows. The first 2 tax rows use the format Tax Name 1 and Tax Name 2; the next 2 use Tax Name 1 (Included in prices) and Tax Name 2 (Included in prices); the 5th row has no tax columns populated. All share the same order id.
Frequently Asked Questions
Why am I seeing multiple rows for the same order?
Why is Payment Method empty on some orders?
Will unpaid or abandoned orders be included?
Can I check subscription billing details from this export?
Who can download order exports?
Was this article helpful?
Thanks for the feedback.