Hi,
I cannot get the product categories widget sort to work. Not matter what I set the “Sort order” field to, it always does the same. I have specified the Categories to show.
The SQL always seems to do:
SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('product_cat') AND t.term_id IN ( 50,95,92,93,90,91 ) ORDER BY t.term_order DESC
If I change the sort order on the widget, the t.term order DESC is always set, even if I change the sort order. It does not appear to sort by the Menu Order or the “As IDs or slugs provided order”.
Can you please let me know how to resolve this (or what I am doing wrong).