[SOLVED] How to remove item from Special Module?

[Phuah]

I had list a product with special offer and discount before but when I disable an item, the item still show it at special module but the item didn't show at special link at footer. Once we had disable a product, the product won't show at site at all right? Any one know how to remove the product from a special module?

[rocky]

What version of PrestaShop are you using? Disabled products aren't displayed in the special block for me. Make sure that the query in the getRandomSpecial function in classes/Product.php has the following line:

AND p.`active` = 1

[Phuah]

Hi Rocky, I'm using version 1.3.2. Yup. the query in the getRandomSpecial function in classes/Product.php is show that what you mention. But the disable product still show at special module. I really don know why.

[Phuah]

I already get a solution for this problem. Once we disable an item without remove the mark at "on sale" at back office, the item will still remain as on sales item at special module. Thanks Rocky. I had slove it.