New Column on Orders Page

[johannesmutter]

Add a new column on orders page:

Appointment Date (+ Time).

Sort first by Appointment Date than Appointment Time (first line: date; second line: time)

Reason:

The creation date of an order an the appointment date are in almost all cases different. Currently it’s impossible to filter or sort the orders for appointments on a specific day, e.g. to create a report for a specific day or to see how many appointments were sold that day.

This will also allow users to create reports for appointments with many popular WooCommerce Reporting Plugins e.g. “Product Sales Report Pro” by Potentplugins. As these plugins scan all the meta values from the posts of type "shop_order". It will also allow users of the plugin “wordpress admin columns” to adapt the page to their needs.

This would of course mean, if a corresponding order is created for an appointment, that a new meta_key is created named e.g. appointment_date_time.

I'm not sure if it is a memory issue to save the appointment date twice in the database, once for the appointment and once for the order, but I don’t see another elegant solution that will also add support for the reporting plugins.

[Željan Topić]

Not sure where you're going here, but order meta fields are already create and synced with appointment data.