svarcko

@tw2113 the theme is custom, made from scratch, the terms are associated to the products custom post using a custom field created by ACF… if i add the default “twentynineteen” theme then the page /product_size/small_product/ dosnt display any products…

@tw2113
1) you are right, i forgot to remove it from the code when i copied from my other pages (the paging is not working even when i delete the numberposts from the query).
2) i am doing it before just in case, because there are some other queries that are executed before this one (i am doing it everywhere before and after the query).

if i dont put the pagination part and the limits of how many posts to be shown i get 65 products (all of them) and i need to show only 12 per page using the pager…

thanks @aimsinfosofts i sorted out the problem. the issue was that i had some broken php in the front-page.php template when the form was posted and thats why it was ignored by the system…

for now temporally i am accomplishing that like this:

                            
global $wpdb;
$sql = 'SELECT prod_id, count(*) as NUM FROM wp_yith_wcwl GROUP BY prod_id ORDER BY NUM DESC LIMIT 10';
$rows = $wpdb->get_results($sql);
if($rows):
    foreach ($rows as $key => $popular_product):
    $product_id = $popular_product->prod_id;
    $product = wc_get_product($product_id);

is this good enough? is there any better solution?