Increase prices per manufacturer

[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

[stevesh]

This, maybe:

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

[RodG]

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