SQL Pricing Patch...

[GsT]

Hi,

I´m having problems when I try to change the prices on some categories (9 to be exact) with a SQL patch. I don´t know how to make a patch that updates all my specific categories at once but I´m trying one category at a time now with this patch:

UPDATE products SET products_price = products_price * 1.05 WHERE master_categories_id = 30;

When I try that it says "successful" but nothing happens, no price changes what so ever.
The master_category is 30 (no products directly under it) but it holds a number of sub-categories which holds the actual products.

Am I doing something wrong here?

[GsT]

Ok, now I got it working, when I actually entered the right ID in this case the ID of the sub-categories.

Is it possible though to in some way include every sub-category and sub-sub-category and so on... in any way?

It´s a little hard to update them one by one when there are in some cases so many sub-, sub-sub- and even sub-sub-sub- categories.?

[GsT]

I´m obviously no sql-expert, but is there anyway you could include more ID:s at once in the sql patch for instance like this:

UPDATE products SET products_price = products_price * 1.05 WHERE master_categories_id = 30,40,50,60,70,80;

That way I could at least get all the sub-sub-sub categories updated at once.

Even better if someone knows how select/include the top-category + all it´s sub- and sub-sub- categories and so on.

Thx!

[RodG]

I´m obviously no sql-expert, but is there anyway you could include more ID:s at once in the sql patch for instance like this:

UPDATE products SET products_price = products_price * 1.05 WHERE master_categories_id = 30,40,50,60,70,80;

That way I could at least get all the sub-sub-sub categories updated at once.

Even better if someone knows how select/include the top-category + all it´s sub- and sub-sub- categories and so on.

Thx!

UPDATE products SET products_price = products_price * 1.05 WHERE master_categories_id = 30 OR master_categories_id = 40  OR master_categories_id = 50 OR master_categories_id = 70 OR master_categories_id = 80;

Not the most elegant, but simple to follow :)

Cheers
Rod

[GsT]

Thank You Rod!

That will probably save me some 4-6 hours!

Simplicity is the key, especially in my case.

[GsT]

Ahh, still too complex there cases where there are sub-sub- categories with 80-90 subcategories. It´s too painful to keep track of the ID:s in that case.

As I said earlier I´m no coder but there must be an easier way to "select" the top-category with all its siblings and products in some other way...