Globally Changing prices of products.

[Ajeh]

You can check the products table in phpMyAdmin to see what the master_categories_id is or ... in the Zen Cart Admin go to the Categories/Products ... if all the Category is not marked with a yellow icon, that means there are not any Linked Products ... if the Category is marked with a yellow icon that means there are Linked Products ...

If you use Linked Products, check to see if those Products are all using the same master_categories_id ... you can see this by editing the Product ...

If all Products use the same master_categories_id, then you can use that to control which Category gets the prices updated ...

For example, if categories_id 10 is the master_categories_id you can update the products_price to $5.00 more with:

UPDATE products SET products_price = products_price + 5.00 WHERE master_categories_id = 10;

and that can be run in the Tools ... Install SQL Patches ...

The, go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...

NOTE: the Update Products Price Sorter uses the master_categories_id when building the default price for the Product ... so if using Linked Products, it is important that master_categories_id be set correctly ...

[actionjackson57]

You can check the products table in phpMyAdmin to see what the master_categories_id is or ... in the Zen Cart Admin go to the Categories/Products ... if all the Category is not marked with a yellow icon, that means there are not any Linked Products ... if the Category is marked with a yellow icon that means there are Linked Products ...

If you use Linked Products, check to see if those Products are all using the same master_categories_id ... you can see this by editing the Product ...

If all Products use the same master_categories_id, then you can use that to control which Category gets the prices updated ...

For example, if categories_id 10 is the master_categories_id you can update the products_price to $5.00 more with:

UPDATE products SET products_price = products_price + 5.00 WHERE master_categories_id = 10;

and that can be run in the Tools ... Install SQL Patches ...

The, go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...

NOTE: the Update Products Price Sorter uses the master_categories_id when building the default price for the Product ... so if using Linked Products, it is important that master_categories_id be set correctly ...

Thank you Linda. I will see if I can figure out what to do from what you've described. You were very helpful.

[voluntaryist.only]

You can check the products table in phpMyAdmin to see what the master_categories_id is or ... in the Zen Cart Admin go to the Categories/Products ... if all the Category is not marked with a yellow icon, that means there are not any Linked Products ... if the Category is marked with a yellow icon that means there are Linked Products ...

If you use Linked Products, check to see if those Products are all using the same master_categories_id ... you can see this by editing the Product ...

If all Products use the same master_categories_id, then you can use that to control which Category gets the prices updated ...

For example, if categories_id 10 is the master_categories_id you can update the products_price to $5.00 more with:

UPDATE products SET products_price = products_price + 5.00 WHERE master_categories_id = 10;

and that can be run in the Tools ... Install SQL Patches ...

The, go to the Tools ... Store Manager ... and run the Update Products Price Sorter ...

NOTE: the Update Products Price Sorter uses the master_categories_id when building the default price for the Product ... so if using Linked Products, it is important that master_categories_id be set correctly ...

Hi Linda,

I too have the same need, but i want to update all prices globally, by a percentage not just a set amount, could you please advise? thanks in advance,

regards,

ed

[Ajeh]

Change the setting for:
products_price = products_price + 5.00

to what you want to use ...

If you want to do ALL Products, then remove the WHERE condition:
WHERE master_categories_id = 10