Prestashop: Remove Manufacturer List Scroll

Posted Leave a commentPosted in Prestashop

theme folder -> manufacturer-list.tpl To remove top scrool, around line 70, delete the following: <div class=”top-pagination-content clearfix bottom-line”> {include file=”$tpl_dir./pagination.tpl” no_follow=1} </div>   For the bottom one,    Delete around line 153   <div class=”content_sortPagiBar”> <div class=”bottom-pagination-content clearfix”> {include file=”$tpl_dir./pagination.tpl” […]

Prestashop: Manufacturer Page Slow

Posted Leave a commentPosted in Prestashop

-> Classes-> Manufacturer.php   /* $results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(‘ SELECT p.`id_manufacturer`, COUNT(DISTINCT p.`id_product`) as nb_products FROM `’._DB_PREFIX_.’product` p USE INDEX (product_manufacturer) ‘.Shop::addSqlAssociation(‘product’, ‘p’).’ LEFT JOIN `’._DB_PREFIX_.’manufacturer` as m ON (m.`id_manufacturer`= p.`id_manufacturer`) WHERE p.`id_manufacturer` != 0 AND product_shop.`visibility` NOT IN (“none”) ‘.($active […]