This topic contains 2 reply and 2 voices, and was last updated by Fearg 3 years, 10 months ago
Viewing 2 Posts - 1 through 2 (of 2 total)
Author Posts
October 6, 2015 at 9:15 pm 74221
Fearg Hi guys, 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. Thanks
October 7, 2015 at 3:11 pm 74245
Nayem Nayem

Hello,

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.

Thanks.

October 7, 2015 at 5:05 pm 74256
Fearg Fearg

Thanks Nayem, will pass on that info.

Viewing 2 Posts - 1 through 2 (of 2 total)