[SOLVED] shop products where on_sale=1 but where is no reduction price

[deech123]

Hi,

I found out that when you change a product to a reduction product without entering a reduction price it is not shown at the price_drop page.

I import a hugh xml catalogue where reduction are set by the reduction_from / reduction_to date and the on_sale parameter to 1.

is there any possibility to show all those special product without a need of a reduction price?

thx

[rocky]

Try editing classes/Product.php and changing line 1224 (in PrestaShop v1.3.1) from:

AND (`reduction_price` > 0 OR `reduction_percent` > 0)

to:

AND `on_sale` = 1

and line 1246 from:

WHERE (`reduction_price` > 0 OR `reduction_percent` > 0)

to:

WHERE `on_sale` = 1

[deech123]

works

thx Rocky

[YoannB]

Hi Rocky,

I have modified classes/Product.php but I always wrong


10 erreurs

1. ADDER - AVIP208-EURO (ID 5) ne peux être enregistré
2. Product -> reduction_from = 0000-00-00 00:00:00
...

[rocky]

The "reduction from" must be a real date, not 0000-00-00 00:00:00.

[YoannB]

OK but i don't use this field in my CSV ! however i have this error :

# ADDER - AVIP208-EURO (ID 5) ne peux être enregistré
# Product -> reduction_from = 0000-00-00 00:00:00

[rocky]

This bug has been reported and fixed in PrestaShop v1.3.2. Perhaps you should add that field to your CSV and put in dates until v1.3.2 is released.

[YoannB]

OK thanks a lot.

[YoannB]

OK !

I add two fields in my csv :
- reduction from
- reduction to
with the same date