How to bulk change prices in prestashop 1.7?

Question

Prestashop

It can be suggested that there are null modules or buy on a budget to edit goods in bulk, the chef wants to make a discount on a certain group of goods, and there are about 13 thousand positions, manually it is unrealistic.
Presta version 1.7

Answer 1

prices can be changed stupidly with one query to the database:
prices of goods in the ps_product_shop table price field price
of combinations in the ps_product_attribute table price field
in principle, this knowledge is enough to do any manipulations with prices