Changes between Initial Version and Version 1 of Ticket #11302, comment 25
- Timestamp:
- 08/26/2015 06:46:48 PM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #11302, comment 25
initial v1 3 3 I think I've figured out the SQL to do this. Can anybody tell me if I'm missing something? 4 4 In this case 493 is the term_id of the product category. 5 5 {{{ 6 6 DELETE term_relationships 7 7 INNER JOIN term_taxonomy … … 12 12 count = 0 13 13 WHERE term_taxonomy.term_id = 493 14 14 }}} 15 15 16 16 ANOTHER SOLUTION which may be easier for you guys to implement as it eliminates a lot of complexity and potential for serious bugs and user misunderstanding is to have a second icon/link column in the Product Category page, next to the "Count" column. When clicked it takes you to a completely new page that lists all the products in the category (not the page that you go to when you click "count").