whole category % discount, how?

[SonnyBoyII]

Hi

How can I make a whole category (for example "/necklaces") 10% off??
I don't want to do that one by one.

thanks!
SonnyBoy

[rocky]

There is no option to do that in PrestaShop. You can run an SQL query like this:

UPDATE `ps_product` SET `reduction_percent` = 10 WHERE `id_category_default` = 2

Change ps_ to your database prefix and 2 to the ID of the category you want to change. This query relies on the default category of the products being the category you want to discount.

[SonnyBoyII]

Thanks rocky! I think it colud be quite easy to write a simple module to run this query.

[olea]

On the addons, I propose the OleaRebate module.

Per group or per customer you will be able to set different discount for the shop, per category, per product, per product of a given supplier, per product of a given manufacturer.

Rebates are cumulative, exclusive, managed with priority...