Increase prices per manufacturer

Hi all,

Had a search around but cannot find the answer to this. Is there any way to increase the price on a selected manufacturer by a certain percentage on all their products?

Sorry if this has already been answered but I couldn't find it.

Thanks

This, maybe:

http://www.zen-cart.com/forum/showthread.php?t=75958

I.Q:

Hi all,

Had a search around but cannot find the answer to this. Is there any way to increase the price on a selected manufacturer by a certain percentage on all their products?

Sorry if this has already been answered but I couldn't find it.

Thanks

If you know (or can find out) the Manufuacturers ID, then a SQL command long the lines of:.......................

update products set products_price = products_price + ((products_price /x) *100) WHERE manufacturers_id = 'yyy' ;

.....should do it. Adjust 'x' and 'yyy' to suit.

The syntax given may not be accurate... I've just typed that in as an example.

Cheers
Rod