vaibhav178

I am trying to show subcategory name of a product on invoice. I was successful in showing category name by adding following code in getProducts() in classes/order/orderinvoice.php file:- $sql = "SELECT `name` FROM `ps_category_lang`, `ps_product` WHERE `ps_product`.`id_product`='".(int)$row['id_product']."' AND `ps_product`.`id_category_default`=`ps_category_lang`.`id_category` AND `ps_category_lang`.`id_lang`=1"; $row['product_category'] = Db::getInstance()->getValue($sql); and then adding following code in pdf/invoice.tpl file :- {$order_detail.product_category} Can anyone please tell how to get subcategory name of product on invoice ?

When I check In stock filter, 2 issues coming :- 1) Its showing no products even if there are 21 products 2) Its hiding ul of condition filter as seen in developer tools window I am using prestashop v1.6.0.5. I thinks its javascript issue. Can anybody sort it ? Please find attached javascript file & blocklayered.tpl file in Issue number PSCSX-2198 http://forge.prestashop.com/browse/PSCSX-2198?filter=-2