Mass editing products manufacturers?

[schobook]

How would I go about mass editing the manufacturers? All of them will be the same manufacturer.

Thank you,

[lat9]

Are you saying that you have many products created, all by the same manufacturer, but forgot to set the manufacturer associated with those products?
Do you have the manufacturer defined now using your admin's Catalog->Manufacturers?

If you answered "Yes" to those two questions, what is the manufacturers_id of that manufacturer? You can deduce the value by clicking the Info button next to the manufacturer's name and then looking at your browser's address bar which will look like:

http://www.yourstore.com/YOUR_ADMIN/manufacturers.php?page=1&mID=6&action=edit

The value I've highlighted in bold is the manufacturers_id of that Manufacturer.

[schobook]

Yes to both of those questions. So the ID is 29. What do I do with that?

manufacturers.php?page=1&mID=29&action=edit

[lat9]

OK, back up your database, then run the SQL command

UPDATE products SET manufacturers_id=29;

If you run that in your admin's Tools->Install SQL Patches, it will automatically add any database prefix you're using.

[schobook]

Will this work if I have already added the manufacture to some products?

Thanks,

[schoolboy]

Will this work if I have already added the manufacture to some products?

Thanks,

Quite safe to run this if ALL products are to have the same manufacturer - even those you have already assigned. This instruction just tells the database to associate every product with manufacturer whose ID is 29 - so if it already has that ID in the field, it will just over-write the initial 29 with the new 29.