killerkhan

Hello Nemo, Your tutorial is perfect and this works. But my requirement is something else. I want to show the sub-category image in the menu. Something like this site http://jdm-expo.com/ Can you explain me the steps how can i fetch the menu thumbnails of the sub-category. Waiting for your reply. Thanks,

Hello, I have 2409 products in one of my category. And i am sowing 52 products on one page. But whenever i am clicking on Show ALL the page fetches for a long time and then becomes blank. I am on shared hosting. And the hosting is saying that the following Query is taking more than expected time. SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, l.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,DATEDIFF(product_shop.`date_add`, DATE_SUB("2016-08-06 00:00:00", INTERVAL 0 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 16 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY cp.`position` ASC; I am using Prestashop 1.6.1.5 When i try to run this query in my PhpMyAdmin it takes 7 min 22 sec to give me the result. In the Forum i searched and found to remove the DATEDIFF(product_shop.`date_add`, DATE_SUB("2016-08-06 00:00:00", INTERVAL 0 DAY)) > 0 AS new, But still i am getting the same result. Any help is appreciated in this. Thanks,

Confirmed, This works for me. Thanks for sharing the solution.

Hello, I bought the module and tried importing the products. I am using Tech Data supplier. Everything went well. The products are also imported. But the following things are not imported at all. 1) Product images are not there 2) Product price are not there. 3) Manufacturer Logo are not there. Can you please point out where i am making mistake. Thanks,

Hello Christian, Did you got the solution for this? Thanks,

Hello all, This solution works for me. I just added the line SetEnv PHP_VER 5 in my .htaccess file and the site works well. Before adding this line my PHP Version was 4.4.9 but after addition it is showing 5.2.17. My Prestashop version is 1.6.1.1 Thanks,

Hello hsgear, Did you managed to get this working?? Thanks,

Hello, But this doesn't work for me. I am using 1.6.0.11. And Attached is the screenshot of my setting. http://prntscr.com/7dek2z Please help me. Thanks,

Hello, can you share the solution. I am also facing the same problem. Thanks in advance,

Hello Vekia, How can i add state in the Customers->Addresses. Thanks,

Hello, Does anyone have solution for rakuten.de Thanks in advance.

Hello Vekia, I am using the latest Prestashop 1.6.0.8 and i need the same thing to implement in my category page. Thanks,

Hello, After making those changes i can add the description_short in the order confirmation mail sent to the customer. But i need the same to the admin email as well. Not been able to trace cart::getProducts(). Which file is it. Please help me where i am missing to add the variable. Thanks,

Hello Nemo1, That is my problem i cannot see the CMS pages in the right pane in the top horizontal menu module. Attached is the screenshot for the same. Thanks,

Hello, How can i bring the cms page in the top horizontal menu. In the module i can see the CMS written but none of my cms page or the category is appearing there, I am using Prestashop version 1.6 Thanks