Can I change price attributes in all products at one time?

[dat311]

Hello!

I have around 49 products in my shop. Each product has the same price but has 10 different price options depending on several factors.

So basically I have 10 price attributes set up for each product. I would like to change the prices of each of the 10 attributes.

Is it possible to make ONE change that would reflect in all 49 products or do I have to go into EACH of the 49 products one by one and change all 10 price attributes?

Thanks so much for your help!!!

[gjh42]

Is each of these attributes the same price in all products? Or do you want to alter all of them in exactly the same way (%, $ change, ...)?
Try this after backing up your database:

UPDATE products_attributes SET options_values_price = ROUND(options_values_price * 1.5)
WHERE options_values_id = 113;

Cut & paste in Tools > Install SQL Patches, changing the options_values_id as appropriate and the calculation to whatever you need. MySQL has specific syntax for calculations, so you need to be clear on how you want to change the prices.