WooCommerce Appointments

Running a booking site? Need to export appointments between specific dates?

The built-in date filter uses order date. Not helpful when customers book weeks in advance.

This code filters by appointment start date instead.

What this code does

Replaces the standard date filter. Now your from/to dates apply to appointment start times. Not order creation times.

Export all appointments starting next week. Or last month’s completed appointments.

The complete code

//WooCommerce Appointments, Date Filters applied to appointment start date 
class WOE_Filter_By_App_Date {
	var $from_date = "";
	var $to_date = "";
	
	function __construct() {
		add_filter('woe_settings_validate_defaults',  function($settings){
			if($settings['from_date']) {
				$this->from_date= $settings['from_date'];
				$settings['from_date'] = "";
			}
			if($settings['to_date']) {
				$this->to_date= $settings['to_date'];
				$settings['to_date'] = "";
			}
			return $settings;
		});

		add_filter( 'woe_sql_get_order_ids_where', function($where, $settings ){
			global $wpdb;
			$date_sql = "";
			if ( $this->from_date OR  $this->to_date) {
				$meta_val_filter = array();
				if( $this->from_date ) 
					$meta_val_filter[] = "CAST(meta_value AS UNSIGNED) >= ". date("YmdHis", strtotime($this->from_date. " 00:00:00"));
				if( $this->to_date ) 
					$meta_val_filter[] = "CAST(meta_value AS UNSIGNED) <= ". date("YmdHis", strtotime($this->to_date. " 23:59:59"));
				$meta_val_filter = join( " AND ", $meta_val_filter);
				$date_sql = "AND ID IN (SELECT post_id FROM $wpdb->postmeta  WHERE meta_key='_appointment_start' AND $meta_val_filter )";
			}
			$where[] = "orders.ID IN (SELECT post_parent FROM $wpdb->posts WHERE post_type='wc_appointment'  $date_sql)";
			return $where;
		},10,2);
	} //end construct
}
new  WOE_Filter_By_App_Date();

//WooCommerce Appointments, Date Filters applied to appointment start date

class WOE_Filter_By_App_Date {

var $from_date = "";

var $to_date = "";

function __construct() {

add_filter('woe_settings_validate_defaults', function($settings){

if($settings['from_date']) {

$this->from_date= $settings['from_date'];

$settings['from_date'] = "";

}

if($settings['to_date']) {

$this->to_date= $settings['to_date'];

$settings['to_date'] = "";

}

return $settings;

});

add_filter( 'woe_sql_get_order_ids_where', function($where, $settings ){

global $wpdb;

$date_sql = "";

if ( $this->from_date OR $this->to_date) {

$meta_val_filter = array();

if( $this->from_date )

$meta_val_filter[] = "CAST(meta_value AS UNSIGNED) >= ". date("YmdHis", strtotime($this->from_date. " 00:00:00"));

if( $this->to_date )

$meta_val_filter[] = "CAST(meta_value AS UNSIGNED) <= ". date("YmdHis", strtotime($this->to_date. " 23:59:59"));

$meta_val_filter = join( " AND ", $meta_val_filter);

$date_sql = "AND ID IN (SELECT post_id FROM $wpdb->postmeta WHERE meta_key='_appointment_start' AND $meta_val_filter )";

}

$where[] = "orders.ID IN (SELECT post_parent FROM $wpdb->posts WHERE post_type='wc_appointment' $date_sql)";

return $where;

},10,2);

} //end construct

}

new WOE_Filter_By_App_Date();

How to use it

Copy the code into your theme’s functions.php
Go to Advanced Order Export for WooCommerce
Open your export profile
Look for the standard date range picker (From Date / To Date)
Select your appointment date range as usual
Run the export

The code intercepts your dates. Applies them to appointment start times instead.

Real example

You run a spa. Customers book massages 2 weeks out.

Today is June 1. You want all appointments for June 15-20.

Set From Date: June 15. To Date: June 20.

Standard export shows orders placed on June 1 (wrong). This code shows appointments starting June 15-20 (correct).

When you need this

You sell services by appointment. Need next week’s schedule.

Your staff needs daily appointment lists. Not order date lists.

You track no-shows. Need to export appointments from last week only.

You reconcile payments with completed appointments. Date range must match service dates.

How it works under the hood

WooCommerce Appointments stores appointment start times as post meta (_appointment_start). Values are Unix timestamps.

The code converts your human-readable dates (2026-06-15) to timestamps. Then filters appointments within that range. Then finds which orders contain those appointments.

Common mistake

The code only works with the official WooCommerce Appointments plugin (from WooCommerce.com). Not other booking plugins.

Also, your from/to dates must match your WordPress timezone. The code uses strtotime() with site time.

Empty export?

No appointments in your date range? Export will be empty.

Test with a wide range first (last 30 days). Verify appointments appear. Then narrow down.

Pro tip

Want to filter by appointment end date instead? Change _appointment_start to _appointment_end in the code.

Need both start AND end? Modify the SQL to check both meta keys.

Real talk

Most store owners want appointment date filters. Not order date filters.

This code swaps them cleanly. No need to explain to your staff “ignore the order date, look at appointment time.”

Your team exports next week’s schedule. They see exactly what they need. No confusion.