Exclude all orders containing at least one product in a category

hello

Please, open section “Filter By Products” and select “product_cat” in the dropdown “Product taxonomies” .

Use “=” or “<>”

thanks, Alex

It doesn’t work though, I have an order which contains various products from the excluded category, I enclose a screen, but these are included in both the preview and the generated csv.
I have tried both with the “Export all products from the order box” ticked and without the tick.

• This reply was modified 12 months ago by famarast.

It seems to remove only the products I have excluded but I want the entire order to be removed from the export

Please, open section “Misc Settings” and add this php code.
You must edit list of excluded categories in code!
?
add_filter( 'woe_order_export_started', function ( $order_id ) {
$order = new WC_Order($order_id);
$skip_categories = array( "74","64","84","68","87","86","77","71","82","72");
foreach ( $order->get_items('line_item') as $item_id=>$item ) {
$terms = get_the_terms( $item['product_id'], 'product_cat' );
foreach ( $terms as $term ) {
if( in_array($term->term_id,$skip_categories) )
return false;
}
}
return $order_id;
});