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'