Change price by category contrib ???

Wondering if anyone has come up with a contribution that will allow a shop owner to change prices of a whole category with only a few clicks. Say add $5.00 or 5% to the price of all products in a category (or even the whole shop)???

If they haven't came up with a contrib like this, maybe some of you contribution wizards could do it??

wsmith48:

Wondering if anyone has come up with a contribution that will allow a shop owner to change prices of a whole category with only a few clicks. Say add $5.00 or 5% to the price of all products in a category (or even the whole shop)???

If they haven't came up with a contrib like this, maybe some of you contribution wizards could do it??
Not like the salemaker addon - something more permanent for price upgrading of 100's of products at the 1st of the year or whenever there is a price change needed.

You could do this with an UPDATE command via the Insert SQL Patch if you know the master_categories_id ...

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

NOTE: be sure to backup your database before attempting this ...

When done, you would want to run the Tools ... Store Manager ... for updating the products_price_sorter ...

Also be aware of the implication on Specials ...

So yes, I would agree the better method is to write a script for this to keep all your ducks in a row ... :cool:

wondering if the salemaker addon could be modified...... hmmmmm??