admin管理员组

文章数量:1130349

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'

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'

本文标签： pluginsFiltering WooCommerce Orders by Category

版权声明：本文标题：plugins - Filtering WooCommerce Orders by Category 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://it.en369.cn/questions/1749018733a2304059.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。