Is it possible to create a sale on all products by a manufacturer at 1.51?

[fakeDecoy]

It sounds like that solution would work, but wouldn't it affect the breadcrumbs display for category browsing? When a visitor views that product, unless the cPath parameter is in the url, he would find himself browsing the Sale category instead of the category that makes sense. Technically it would still work, but that seems like a nasty tradeoff.

I want a 1-week sale for all products by one manufacturer, amounting to about 200 products. It seems that the most efficient way to do this without messing up my breadcrumb display is to create an SQL statement adding records to zen_specials.

[Ajeh]

You could try this attachment ...

It allows for the Adding/Removing by Category (master_categories_id) or Manufacturer (manufacturers_id) and see how that works for you ...

Be sure to backup your database before attempting to use this ...