What is Order Export?
Order export allows you to download order data from your system into CSV files. This gives you a snapshot of your orders that you can use for analysis, record-keeping, or processing in external systems. If DATEV integration is enabled, you can also export in DATEV format for German accounting systems.
Why Export Orders?
Exporting order data helps you:
- Analyze Performance: Review sales trends and patterns
- Keep Records: Maintain backups for accounting and compliance
- Share with Team: Distribute order information to fulfillment or accounting teams
- Process Externally: Use data in spreadsheets or other software
- Create Reports: Build custom reports and dashboards
- Audit Orders: Review and verify order details
- Import to Other Systems: Transfer data to accounting, ERP, or analytics tools
When to Export Orders
Common scenarios for exporting:
- End of month or quarter accounting
- Preparing tax documentation
- Sharing fulfillment lists with warehouse teams
- Analyzing sales performance
- Creating custom reports for management
- Backing up order data before major changes
- Migrating to another system
- Providing data to accountants or bookkeepers
- Investigating order issues or patterns
Export Formats
The system exports orders with all available order data. The fields included in the export are pre-defined and
cannot be customized.
cannot be customized.
CSV Format
- Standard comma-separated values format
- Includes all order data fields
- Compatible with Excel, Google Sheets, and LibreOffice
- Universal compatibility
DATEV Format (if enabled)
- German accounting standard format
- Available only if DATEV integration is configured
- Includes required DATEV accounting fields
Step-by-Step Export Guide
1. Filter Your Orders
Select which orders to export:
- Use date range filters
- Filter by order status
- Filter by payment status
- Filter by tags or customer
- Filter by product or collection
- Use saved filters for common exports
2. Access Export Feature
- Go to the Orders section
- Click the Export button or menu
- Or navigate to Batch Jobs > Export Orders
3. Choose Export Format
- CSV: Default format for all exports
- DATEV: Available if integration is enabled
4. Start Export
- Click Export to begin
- A batch job is created
- Export runs in the background
5. Monitor Progress
- Open the Batch Jobs dashboard
- Locate your export job
- Monitor progress status
6. Download Your File
- Click the download link when export completes
- File is saved to your computer
- File name includes a timestamp
7. Open and Verify
- Open the file in a spreadsheet program
- Verify row count and data accuracy
- Spot-check several orders
Understanding Export Files
CSV File Structure
- Header Row: Column names
- Data Rows: One row per order or line item
- Comma-Separated: Fields divided by commas
Line Item vs. Order Level
Order Level Export
- One row per order
- Multiple products combined
- Simpler structure
Line Item Export
- One row per product
- Multiple rows per order
- Better for product analysis
Best Practices
- Export only what you need
- Verify data after export
- Secure exported files
- Use clear file naming
- Delete sensitive files when no longer needed
Security and Privacy
- Limit access to exported data
- Encrypt files when sharing
- Follow GDPR, CCPA, and other privacy laws
- Use secure transfer methods
Troubleshooting
- Check permissions if export fails
- Reduce date range for large exports
- Verify file format and encoding
- Re-download file if corrupted
Next Steps
- Analyze exported data
- Share with relevant teams
- Create reports and dashboards
- Schedule recurring exports if needed