1.6 show "On sale" products on "price-drop" page

[RockyS]

Hi, 

how can we add products that are ON SALE to price-drop page without  faking discounts? 

NOT: PS 1.6

[RockyS]

Bump

[mehnihma]

Hi, yes you can take a look here

 

In classes folder find Product.php. On line 2326 find:

 

WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1

 

And replace with:

 

WHERE product_shop.`active` = 1
AND p.quantity > 0
OR p.on_sale = 1
AND product_shop.`show_price` = 1

 

So here we added check for quantity and if product is set to be on sale it will show it on prices drop page.

 

But I get only one page not all pages with products on sale, did not get how to fix that?

[zaurus]

Hi Guys, that problem has another fix in presta 1.6.x:

in /classes/Product.php

 

line: 2292 must become

            '.$sql_groups.'OR p.`on_sale` = 1') ;

 

and line: 2331 is going to

        '.$sql_groups.' OR p.`on_sale` = 1

 

so, you will have  "On sale" products on "price-drop" page

[vicaalvarez]

Hi Guys, that problem has another fix in presta 1.6.x:

in /classes/Product.php

 

line: 2292 must become

            '.$sql_groups.'OR p.`on_sale` = 1') ;

 

and line: 2331 is going to

        '.$sql_groups.' OR p.`on_sale` = 1

 

so, you will have  "On sale" products on "price-drop" page

where exactly? i have something else on those lines

[thrillmetoo]

I had the same problem. I wanted to only show products that are marked 'on sale' and not all products that have a discount (which is most of my products).

I changed in classes/product.php line 2349

 

 

WHERE product_shop. 'active' = 1

AND product_shop. 'show_price' = 1

 

to:

 

WHERE product_shop.'active'= 1

AND p.quantity > 0

AND p-on_sale = 1

AND product_shop.'show_price' = 1

 

after that, do the same on line 2390

 

 

 

[prolink]

where exactly? i have something else on those lines

 

Has anyone found a solution for presta 1.6.x ?

 

I have 1.6.1.3 and struggling with the same issue

[chosie]

For 1.6.0.8, you may refer to line 2290 and 2330 in classes/product.php to modify the script. Hope this helps who is still looking for the solution.

[Truffelstunter]

anybody with a more recent fix for this? i dont have the mentioned lines at that place, for both of the fixes

[Jedrzej z Komijo]

2545 

			'.((!$beginning && !$ending) ? 'AND p.`id_product` IN('.((is_array($tab_id_product) && count($tab_id_product)) ? implode(', ', $tab_id_product) : 0).')' : '').' OR p.on_sale = 1

2583

	'.((!$beginning && !$ending) ? ' AND p.`id_product` IN ('.((is_array($tab_id_product) && count($tab_id_product)) ? implode(', ', $tab_id_product) : 0).')' : '').' OR p.on_sale = 1