Filtering WooCommerce Orders by Category

I am using WooCommerce as an ordering system online.

I will be having many categories for each products. How can I allow the admin or the shop manager to filter the orders page by product category?

I’m currently using the plugin “WooCommerce Filter Orders by Product” however, I am lost in the SQL queries used in showing these items.

I was able to show the categories using only a SQL query however it doesn’t work in the dropdown menu.

SELECT wp_terms.term_id,wp_terms.name
FROM wp_terms
LEFT JOIN wp_term_taxonomy
ON wp_terms.term_id = wp_term_taxonomy.term_id
WHERE wp_term_taxonomy.taxonomy = ‘product_cat’

Read more here:: Filtering WooCommerce Orders by Category

Leave a Reply

Your email address will not be published. Required fields are marked *