On 2/8/2024 at 12:31 PM, luke.c21hygiene said:Hello all,
Im after some help with options to mass price increase products, we have a supplier that gives us 2 price increases every year and i have been doing this manually! there are over 300 products and this takes some time especially on days when i am super busy.
I have no coding experience especially PHP and i have stumbled upon a script that might do the trick! the issue is it does all of the products on the website, i just want it to do products under certain categories. How can i edit it to do this?
Here is the bit of code i found.
UPDATE ps_product_shop SET price = price*1.20
UPDATE ps_product SET price = price*1.20
Any help would be greatly appreciated!
Regards
Luke
Hi.
Here you write "have a supplier that gives us 2 price increases every year".
So do you have a csv file available? Does the csv file have the same product code as you have in the e-shop? Then it's easy. Programming something like that is a matter of 10-15 minutes.