PS 1.7 Modify "price-drop" page to show only "on sale" products

[PassionX]

Hi

There is no information to find how to modify the prices drop page (specials) to show only the "on sale" products.

This Solution does not work:

Can someone advise?

 

The code for the getdropprice function is on Line 2912:

WHERE product_shop.'active'= 1

AND p.quantity > 0

AND p-on_sale = 1

AND product_shop.'show_price' = 1

But this is not working in PS 1.7

Thank You

Simon

Edited April 3, 2020 by PassionX (see edit history)

[Tomascap]

Hi, 

for 1.7 to show "On sale" products in specials you need to add OR p.on_sale = 1  in the end of two lines in classes/Product.php. So you will get:

Line 2846

'.((!$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

Line 2808

'.((!$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

 

[JoZu]

On 5/25/2020 at 10:02 AM, Tomascap said:

Hi, 

for 1.7 to show "On sale" products in specials you need to add OR p.on_sale = 1  in the end of two lines in classes/Product.php. So you will get:

Line 2846

'.((!$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

Line 2808

'.((!$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

 

Dont work for me:

I need to show only products marked "on sale" no specific price products in price drops page