$conf, $runtime; function_exists('chdir') AND chdir(APP_PATH); $r = 'mysql' == $conf['cache']['type'] ? website_set('runtime', $runtime) : cache_set('runtime', $runtime); } function runtime_truncate() { global $conf; 'mysql' == $conf['cache']['type'] ? website_set('runtime', '') : cache_delete('runtime'); } register_shutdown_function('runtime_save'); ?>plugins - Filtering WooCommerce Orders by Category|Programmer puzzle solving
最新消息:Welcome to the puzzle paradise for programmers! Here, a well-designed puzzle awaits you. From code logic puzzles to algorithmic challenges, each level is closely centered on the programmer's expertise and skills. Whether you're a novice programmer or an experienced tech guru, you'll find your own challenges on this site. In the process of solving puzzles, you can not only exercise your thinking skills, but also deepen your understanding and application of programming knowledge. Come to start this puzzle journey full of wisdom and challenges, with many programmers to compete with each other and show your programming wisdom! Translated with DeepL.com (free version)

plugins - Filtering WooCommerce Orders by Category

matteradmin9PV0评论

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' 
Post a comment

comment list (0)

  1. No comments so far