Hi
I have ew products in category but on site it display only one. I enabled debug and i can see this
SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id`, l.product_name
FROM `l1r20_virtuemart_products` as p
LEFT JOIN `l1r20_virtuemart_products_en_gb` as l
ON l.`virtuemart_product_id` = p.`virtuemart_product_id`
LEFT JOIN `l1r20_virtuemart_product_shoppergroups` as ps
ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id`
LEFT JOIN `l1r20_virtuemart_product_categories` as pc
ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`
WHERE ( `pc`.`virtuemart_category_id` = 114
AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL )
AND p.`published`="1"
AND ( p.`virtuemart_product_id` NOT IN (160,159,113,101,99) ) )
group by p.`virtuemart_product_id`
ORDER BY `pc`.`ordering` ASC, `product_name` ASC
LIMIT 0, 24
i dont know why there is this line
AND ( p.`virtuemart_product_id` NOT IN (160,159,113,101,99) ) )
any idea ? thanks
see: http://forum.virtuemart.net/index.php?topic=143904.msg509094#msg509094
isn't from the OMIT and already cached products settings for
afaik changed a while ago in any case
if(self::$omitLoaded and self::$_alreadyLoadedIds){
$where[] = ' p.`virtuemart_product_id`!='.implode(' AND p.`virtuemart_product_id`!=',self::$_alreadyLoadedIds).' ';
//$where[] = ' p.`virtuemart_product_id` NOT IN ('.implode(',',self::$_alreadyLoadedIds).') ';
}
I am sorry I dont understand.
Where do i have to click to display all products (discard this omit)
VM config->config->templates