Skip to content

Export Orders

The Export Orders function adds a CSV export button to the Voxel orders page. Download all order data including customer details, line items, and shipping information in a spreadsheet-friendly format.

Overview

Easily export your Voxel orders for accounting, analysis, or reporting purposes. The export includes comprehensive order data organized with one row per line item for easy analysis in Excel or Google Sheets.

Key Features

  • One-click CSV export
  • Comprehensive order data
  • Customer and vendor information
  • Line item details
  • Shipping/checkout information
  • Product variations included
  • UTF-8 support for international characters

Setup Instructions

Enable the Function

  1. Navigate to Voxel Toolkit → Functions in your WordPress admin
  2. Find Export Orders in the list
  3. Toggle the switch to enable the function
  4. Click Save Changes

How to Export

  1. Go to Voxel → Orders in WordPress admin
  2. Find the Export Orders to CSV button at the top of the page
  3. Click the button
  4. CSV file downloads automatically

Exported Data Fields

Order Information

FieldDescription
Order IDUnique order identifier
UserCustomer display name
EmailCustomer email address
Order ValueTotal order amount
CurrencyCurrency code (USD, EUR, etc.)
Order StatusCurrent order status
Payment MethodHow payment was made
Transaction IDPayment gateway transaction ID
Created AtOrder date/time

Item Information

FieldDescription
Item NameProduct/listing name (with variations)
Item QuantityNumber of items
Item PricePrice per unit
Item TotalLine item total

Checkout Details

FieldDescription
Checkout Customer NameName provided at checkout
Checkout EmailEmail from checkout
Checkout PhonePhone number
Address Line 1Street address
Address Line 2Apt/Suite/Unit
CityCity name
StateState/Province
Postal CodeZIP/Postal code
CountryCountry code

Export Format

File Naming

voxel-orders-export-2024-01-15-143022.csv

Files are named with the export date and time for easy identification.

Row Structure

Each line item gets its own row. Orders with multiple items will have multiple rows, all with the same order information but different item details.

Use Cases

Accounting

Export orders for bookkeeping and accounting software imports.

Sales Reports

Create custom sales reports and analysis in Excel or Google Sheets.

Customer Data

Extract customer information for marketing or communication purposes.

Backup

Keep offline records of all orders for backup purposes.

Troubleshooting

Export Button Not Showing

  • Verify the function is enabled
  • Ensure you’re on the main Voxel Orders page (not viewing a single order)
  • Check user has manage_options capability

CSV Opens Incorrectly

  • Export includes UTF-8 BOM for Excel compatibility
  • In Google Sheets, use File → Import and select UTF-8 encoding
  • International characters should display correctly with proper encoding

Missing Data

  • Some fields may be empty if not collected at checkout
  • Order details depend on Stripe checkout configuration

Built by Code Wattz.