Increase price on all products universally?

[Troll]

Ajeh, Thanks for teaching this simple price-change strings! Very helpful!

I have now learned how to make an all over price change:

UPDATE products SET products_price = products_price * 1.35;

How to make changes by master category id:

UPDATE products SET products_price = products_price * 1.35 WHERE master_categories_id = XX;

And how to change the price of attribute priced items:

UPDATE products_attributes SET options_values_price = options_values_price * 1.35;

The last one affect all attribute priced items.
Is there a nice way to make this happen to only a attribute group?
Say by group name?

Thanks for all your nice and patient answers in this community!
/Jan

[Ajeh]

Can you define what you mean by an attribute group?

[Troll]

Sorry.
I think the term is "option group" in the English admin.
I give all attributes a name, and that name is then sorted into "option groups".
(Overview found under the fourth button in admin-products-dropdown.)

I'm thinking, if I an attribute name is specific to what item they lay under. Then It would be possible to update the price for only that "attribute group"?...

Looks like the ID nr. they are given in "option group" sorting is NOT unique, but their name is!..

Or said in another way.
How do I change a single item price, when that is a bunch of attribute priced items without doing this one by one?

I have read something about copying, but I don't understand that one...

Hope this make any sense...

[Ajeh]

As a more real life example ...

Are you trying to change the Price on all
Option Name: Color

Or, Are you trying to change the Price on all
Option Name: Color
Option Value Red

[Troll]

In your example that would be
Option Name: Color

That is in my admin-translation called "Variantgroup"...

Actually, what I am aiming at, is to change all variables for a single products ID.

Here is the actual example in my shop.

[Ajeh]

So what you really want to do is change all the Attribute Prices for:
products_id 186
options_id 22

and you want to increase all of the:
options_values_price

by an amount or a percentage?

[Troll]

Correct!

I guess the only option would be percentage, as the price is different for different attributes!?

Or am I wrong here?
Thinking of it, I might have read somewhere of an addon?...
-To be able to correct price to amounts without decimals, and even to an amount of ex. 199 instead of 200 would be awesome!

[Ajeh]

Change all options_id 22 Option Values to $3.50 for products_id 186 ...

UPDATE products_attributes SET options_values_price = 3.50 WHERE products_id = 186 and options_id = 22;

Change all options_id 22 Option Values to current price plus $1.00 for products_id 186 ...

UPDATE products_attributes SET options_values_price = options_values_price + 1.00 WHERE products_id = 186 and options_id = 22;

Change all options_id 22 Options Values to current price plus 10% for products_id 186 ...

UPDATE products_attributes SET options_values_price = options_values_price * 1.10 WHERE products_id = 186 and options_id = 22;

NOTE: be sure to backup your database before attempting any of these ...

[Troll]

Fantastic Ajeh - Oba-San

I'll try this out!
Sorry you had to drag it out of me...

[Ajeh]

Not a problem ... let us know how this ends up working for you ...