Originally Posted by
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)
Code:
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.
Bookmarks