To help with the export of order details into excel I am using the woocommerce-store-exporter-deluxe plugin. When I export the orders table from Woocommerce it is hard to filter out the parent orders from the sub orders (required to prevent double counting). I contacted the plugin dev and he said that he'll update the plugin to work for dokan if he can.
He asked me to identify how orders with sub-orders are grouped, is it either by using the Post Parent field within wp_posts table or by a custom Post meta assigned to sub-Orders to group them to their parent Orders?
Can you guys advise on the above please? Once he knows he can add it as a column to the orders export reports.
In wp_posts table Post Parent of the parent order is 0 and for the sub-order Post Parent is parent order ID. Now those parent orders which has sub-order will have a meta key has_sub_order with value set true and which parent order don't have any sub-order will not have that meta key.