Can I raise price by manufacturer (by %)

[Guest]

Hi all!

 

I want to know if there is a way to select a manufacturer and raise the prices by a given percent.

 

Thanks!

Matt

[Rob123]

You can run the following MySQL statement with phpMyAdmin.

 

In my example, all products with a manufacturer's id of "17" will increase in price by 5%

update products set products_price = products_price * 1.05 where manufacturers_id = '17';

The code above should work unless I have a typo.

HTH,

Robert

[Guest]

You can run the following MySQL statement with phpMyAdmin.

 

In my example, all products with a manufacturer's id of "17" will increase in price by 5%

update products set products_price = products_price * 1.05 where manufacturers_id = '17';

The code above should work unless I have a typo.

HTH,

Robert

<{POST_SNAPBACK}>

Thank you! I will give it a try :D

[Guest]

Please Help! This is not working.. :(

 

Just says "0 columns updated"

[♥kymation]

To make this a bit easier, you can use the Price Updater contribution. Just follow the link in my sig.

 

Regards

Jim

[Rob123]

Please Help! This is not working..  :(

 

Just says "0 columns updated"

<{POST_SNAPBACK}>

 

As long as you're not getting an error message, my guess is that you are using a manufacturer_id that does not exist.

 

To make this a bit easier, you can use the Price Updater contribution. Just follow the link in my sig.

 

Regards

Jim

<{POST_SNAPBACK}>

Jim,

It seems your contribution would help people who are not comfortable using MySQL scripts.

 

Matt,

Either way, let us know if you resolved your problem.

Robert

[♥kymation]

True. I assumed that Matt was not that familiar with using SQL, which may not be a true assumption.

 

Regards

Jim