[Gelöst] filter orders in view

[Author]

Artikel

[domenicoS]

Hi, I created a view with all woocommerce order.

I need to filter this order in base of category of the product bought. How can I do?

[Nigel]

Hi there

That's not possible. It wouldn't be possible if you were writing your own custom WP_Queries by hand, and so it is not possible with Views.

You can only filter posts by properties of those posts.

Product categories belong to products. They are not a property of orders.

You can only filter orders by fields or taxonomies of orders.

What you are aiming for would require a custom solution. You could try consulting the Toolset Contractors page for someone to develop this: https://toolset.com/contractors/

[domenicoS]

If I set a relationship between Product and Orders, could I get category rom the parent (product) and use it as filter?
What do you think? Should be possible?

[domenicoS]

OK Nigel, I find a possible solution. I set a relationship between orders and product.
So in the view I can Get the category of the product as parent, and use it as filter. It works.

I only need your help to hiw to set this relationshio automatically. When a new order is created ,should be automatically set a relationship with the product of the order. Please , can you help me in this issue?

[domenicoS]

With this code I set automatically the relationship.

// Set product-order relationship 
add_action( 'woocommerce_thankyou', 'relate_product_order_func', 999,2 );
function relate_product_order_func( $order_id ){
	
	$order = wc_get_order( $order_id );
	foreach($order->get_items() as $order_key => $order_value)
        {
	     $product_id = $order_value->get_data()['product_id'];
        }   
	
	toolset_connect_posts('prodotto-prenotazione',$product_id, $order_id);
	
}

[domenicoS]

Hi Nigel,

Now for each order I've the relative product category.

How can I filter the view in base of the category of the parent?

[Nigel]

Sorry, but filtering by fields (or taxonomies) of related posts isn't yet supported. The intention is to add such support, but among the competing demands on the developers' time it hasn't yet made it to the front.

(You can push for it to be developed here: https://toolset.com/home/contact-us/suggest-a-new-feature-for-toolset/.)

In the meantime you would need to duplicate the product category taxonomy on orders to be able to filter orders by product category. So you could modify the code you use above to connect an order with a product to instead get the product category from the product and apply it to the order post.

You would then be able to filter orders by product category.