Does anyone know how to put an entire category on sale without editing each individual item?

[M4Real]

I want to put all my watches 20% off. Do I have to edit each individual watch item, or is there some way to edit the entire category at once? Thanks in advance.

[rocky]

PrestaShop doesn't have that option. You could write an SQL query to do it:

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

This query will give a 20% reduction to all products whose default category has ID 2. Note that if the "Default category" of the products is "Home" or another category, it won't work.

[hawaii350]

Is there any update on this technique for 1.4? I've tried looking through the mysql tables to see where discounts are stored now but cant find them.

[rocky]

In PrestaShop v1.4, the price reductions are stored in the ps_specific_price table. The column id_product is the product, reduction_type column is 'percentage' or 'amount' and the reduction column is the reduction value. The from_quantity column should be 1 for a regular discount or 2 or more for a quantity discount.

[phantomeye]

Hi Rocky,

If i understand M4Real's question right, one solution will be to goto vouchers and offer a discount on the category "watches". But you would need to communicate the voucher information to all customers.

 

Hope all is good with you Rocky!

Cheers