How to bulk change prices in presta 1.7?

Question

Prestashop

For a certain category of goods, I want to increase the price of goods by 40%, and then assign a 15% discount.
If the solutions are in the form of sql queries, then I ask you to describe them in as much detail as possible, since I don’t know how to write sql queries.

Answer 1

Discount can be set for certain categories. See in the admin panel Catalog - Products - Special prices.
It is dangerous to use SQL queries (even correctly written ones) without understanding, you need to contact a specialist.

Answer 2