Exporting orders to CSV
Overview
The orders CSV export gives you a flat-file copy of every order matching your current filters — useful for board reports, custom reconciliation, or feeding a separate accounting tool. The export honors any filters and sorting applied to the orders list.
Before you start
Set the filters you want included (date range, status, event, rep).
Decide whether to include cancelled and refunded orders or filter them out.
Have a destination spreadsheet or BI tool ready.
Step-by-step
Go to Sidebar > Orders.
Apply filters: date range, status (any of
pending,committed,completed,cancelled,refunded,failed,refund_requested), event, sponsor, or rep.Click Export in the header and choose Orders CSV.
Optionally choose columns to include — defaults cover all standard fields.
Click Generate export. A toast appears when the file is ready.
Download the file from the toast or from Settings > Exports.
What's in the file
Order ID, status, payment method, total, currency.
Sponsor business and primary contact.
Line items with sponsorship name, event, quantity, price, and discounts.
Created/updated/completed timestamps in ISO-8601.
Assigned rep and any tags.
Tips & best practices
Re-export weekly for a rolling backup outside Chamberly.
For QuickBooks, use the dedicated QuickBooks export — it formats dates and account fields specifically for QB import.
Save filter combos as views before exporting for repeatable reports.
FAQ
Is there a row limit?
Exports above 25,000 rows generate asynchronously and email you when ready.
Can I schedule recurring exports?
Not directly today. Use an automation with a custom CSV email block as a workaround.
Related articles
Exporting invoices to QuickBooks
Reading order activity history
