Skip to main content

Exporting & Importing

Export Appointments​

The WooCommerce Appointments plugin features a unified export system that supports both CSV and ICS formats with comprehensive filtering options. The export system has been refactored to provide a consistent interface and enhanced functionality.

Accessing the Export Page​

  1. Go to Appointments → All Appointments.
  2. Click Export to open the export page.

Export format selection

Export System Architecture​

The export system uses a unified interface with:

  • Export Manager: Central coordination of all export operations
  • Exporter Interface: Consistent API for different export formats
  • Modular Design: Easy to extend with new export formats
  • Organized Structure: All exporters located in includes/admin/export/

Selecting Export Format​

On the export page, you'll see a Export Format dropdown at the top. Choose your preferred format:

  • CSV - For spreadsheet applications (Excel, Google Sheets)
  • ICS (iCalendar) - For calendar applications (Apple Calendar, Google Calendar, Outlook)

Export appointments

Enhanced Filtering Options​

Both CSV and ICS exports now support comprehensive filtering:

  1. Date Range - Filter appointments by start and end dates
  2. Product - Filter by specific appointable products
  3. Staff - Filter by specific staff members
  4. Export add-on fields - Include product add-on data (available for both formats)

CSV Export Features​

Column Selection​

  • Select columns - Choose which columns to include in the export
  • Customizable output - Only export the data you need
  • Improved performance - Faster processing with selective columns

Standard CSV Columns​

  • ID, Order ID, Status, Start/End, Duration
  • Customer name/email/phone
  • Product, Staff, Cost, Quantity
  • Add-on fields (if enabled)

ICS Export Enhancements​

Complete Filter Support​

ICS exports now respect all filter options:

  • Date range filtering - Only include appointments within selected dates
  • Product filtering - Export specific products only
  • Staff filtering - Export specific staff appointments
  • Add-on inclusion - Include add-on data in event descriptions

ICS Export Content​

Calendar files include:

  • Appointment date and time - Precise scheduling information
  • Product information - Service details and pricing
  • Staff information - Assigned staff details
  • Description and add-ons - Complete appointment details (if enabled)
  • Status information - Current appointment status

Export Manager​

The Export Manager provides:

  • Centralized registration - All exporters registered in one location
  • Format routing - Automatic routing to appropriate exporter
  • Error handling - Consistent error reporting across formats
  • Performance optimization - Efficient processing for large datasets

Note: ICS files are also automatically attached to email notifications for appointments (except cancelled appointment emails). See ICS Files via Email for more details.

Import/Export Products​

Appointable Products use WooCommerce’s standard product importer/exporter; appointment metadata is included.