How to export orders placed by unregistered users only

Hello

please, open section “Filter By Order” and use “Custom Fields”.

select key “_customer_user”
select operation “=”
select value “”0”
press (+)

Thanks, seems to work.

Is it possible to trash or delete the exported orders through this plugin or another method.

Hello

we have separate hook for it
https://docs.algolplus.com/algol_order_export/actions-after-export/

Can you do this with query

UPDATE wp_posts SET post_status = 'trash' FROM wp_posts as p JOIN
wp_postmeta as pm ON p.ID = pm.post_id
WHERE pm.meta_key = 'woe_order_exported'

• This reply was modified 3 years, 5 months ago by dnex11.
• This reply was modified 3 years, 5 months ago by dnex11.

yes, you can use global $wpdb;

Thanks

exported orders moved to trash using this code

add_action('woe_order_exported', function ($order_id) {
    $order = new WC_Order($order_id);
    $order->update_status('trash', 'Exported !');
} );

you’re welcome

Last question.
There is an option to export Order Note field. Is there a way to export Order Note date which is the comment_date column in wp_comments table.
Cant find it in commentmeta

• This reply was modified 3 years, 5 months ago by dnex11.
• This reply was modified 3 years, 5 months ago by dnex11.

you should program it .

visit https://docs.algolplus.com/algol_order_export/add-new-fields/
and seek for date_processed

thanks