mass price change for all products in a specific category

mc12345678:

Something "like" but different. In that case would AND the two criteria.

UPDATE products SET products_price = products_price * 1.01 WHERE master_categories_id = 79 AND products_price > 300.00;

> 
> If you wanted to modify additional fields (not just to update products_price), the field along with assignment would be separated by a comma.

Thanks so much for the help! I ran the script, and said that it ran successfully - but no change in price in the effected category or appropriate product...Even after refreshing or running the price update tool...Any ideas?

AquaticAddiction:

Thanks so much for the help! I ran the script, and said that it ran successfully - but no change in price in the effected category or appropriate product...Even after refreshing or running the price update tool...Any ideas?
Well, you said that you wanted to specify a specific category in which to make the change(s). The use of master_categories_id does not target all product "shown" in a category, but instead those that have a base assignment to that category. This means that product linked to the category are not affected.

If you are in phpMyAdmin or a similar database accessing tool you could run a select query to confirm which product meet the criteria or even part of the criteria (e.g. The master_categories_id)

SELECT * FROM products WHERE master_categories_id = 79;

This will display all of the information in the products table for each product that is assigned to master_categories_id of 79. I suspect that the product in question is not present in the list.