Search the Community

Hi, Can anybody help me to hide the out of stock products in categories and featured products in prestashop 1.5.4.1 ? I have searched so much but I do not get better solution of it. Here is below link of my site where I want .... http://purmoservice....egory&id_lang=1 Thanks, Mux

Hi! I need to know if there is a module that hides products, categories, and manufacturers depending on the country the visitor is in. I began working on a new module that does that but I have encountered a lot of problems. I also need help to know how to use the geolocation feature or if I need my own way of getting the visitor's origin. I'm also trying to override other modules such as blockviewed, blocknewproducts, blockmanufacturer, etc so the product I choose doesn't show. Is this possible? Or do I need to create my own version of these modules? What would happen if those modules eventually are updated? Thank you very much

Hi, Here is what I am trying to achieve: I am creating a product category for special deals and the products in this category should ONLY be visible when you have the category URL, the products should not show as new product, on the home page or anywhere else but on the specific category page (like a totally hidden category with products). I have tried hiding the category or the products and any combination I could figure out but I cannot accomplish this, can you possible help? Thanks a million in advance, Henrik

Hi All, I just wants to hide all products of my store which haven't images automatically. you may suggest hook module or custom method for it. Thanks in advance. David

How can I achieve the following, with as little modifications as possible? Hide out of stock products from the "front office" area so that the customers can't find the product on the page in such places as menu and search BUT I still want the products to be visible when using direct link from bookmarks or google. (since I want it to be hidden until restock but still want in-links to work) Using prestashop 1.5.6

Hi everyone, I'm trying to get Prestashop to hide out of stock products EXCEPT those that can be ordered when out of stock and those that currently have stock. I have searched and tried all the MYSQL triggers I can find but all have errors. I would prefer to use a trigger as this seems a much cleaner approach. Does anyone else have any MYSQL based solutions? It would be great to finally resolve this issue. If anyone needs more information please message me... Thanks. My settings: Prestashop version: 1.6.0.8 Products | Products Stock | Allow ordering of out-of-stock products: NO I have a few products configured Quantities | When out of stock: Allow Orders (the vast majority are set to Default) I am using “Advanced Stock Management” and “specify available quantities manually” I am using vekia’s “How to automatically disable out of stock products in PrestaShop” trigger (excellent trigger). This is working 100%. I have tried using pascal’s trigger (as below) but am receiving a syntax error. Create a trigger in the ps_stock_available: Trigger name: change_active_allow_oos Table: ps_stock_available Time: after Event: Update Definition: BEGIN DECLARE SHOPWIDEOOS TINYINT(1) DEFAULT 0; SET SHOPWIDEOOS = (SELECT CAST(`value` AS SIGNED) AS num FROM `ps_configuration` WHERE `name` = 'PS_ORDER_OUT_OF_STOCK' limit 1); UPDATE ps_product_shop SET active=1 WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity>0); UPDATE ps_product_shop SET active=0 WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity<=0 AND (out_of_stock =0 OR (out_of_stock = 2 AND SHOPWIDEOOS = 0))); END There is a syntax error with TINYINT – and I know nothing about MYSQL I have tried using ambitos’s trigger (as below) but am receiving a syntax error. CREATE /*[DEFINER = { user | CURRENT_USER }]*/ TRIGGER `change_active_after_update` AFTER UPDATE ON `ps_stock_available` FOR EACH ROW BEGIN UPDATE ps_product_shop SET active = IF(NEW.quantity <= 0,0,1) WHERE id_product = OLD.id_product; There is a syntax error on the UPDATE line – again I know nothing about MYSQL

Hi all How can we hide all the products from a particular category or categories in products page or in the product display module in the products page. I have a custom module which shows custom products in a cms page and i need to hide these products in the prestashop's default products page. How can i do this... Thanks!

Hi all, I want that customer with ID 1212 can't see and buy products with "Example" in the productname. How can i fix this? Thanks