Change model to manufacturer

I have a store with over 600 items. I have a model # for each item, which actually is supposed to be under the manufacturer.

Instead of going through the entire store changing each one, how do I change every model #, for example, BK, to manufacturer BK

Thanks!

When you put your products in are you entering the manufacturers as well ? Are you talking about the display of the products or are you wanting to mass update the actual model numbers ?

I guess your ? is a little hard to understand to me...

Thanks for responding.

When I entered my products, I manually put a Model # for each item. Now, I want all those model #'s to be manufacturer names.

Can I mass update every model # to a manufacture field?

You have 2 options...

If you install the EZPopulate mod you can download a complete file of your products and then change the model numbers - import it again - and let EZPopulate handle the mass update.

OR you can set up your manufacturers and use that field on the product display without using the model number by assigning all the products to their manufacturers ( the advantage to this is that if you use the manufacturers sidebox and do it this way people will be able to "browse" your products via manucturer).

Hope that helps!

Do you have all of these products_model fields in the products table setup as manufacturers_name in the manufacturers table of your database?

Great! Where can I get EZPopulate mod?

Quote:

---

Originally Posted by Ajeh

Do you have all of these products_model fields in the products table setup as manufacturers_name in the manufacturers table of your database?

---

I am not sure what that means. All I did was add each product manually, and manually typed in each model name in the model name field when I SHOULD HAVE added it to the manufactures field instead. So now I have a whole 600+ listing with model #'s instead of manufacture numbers.

So what you really need is a way to build the tables:
manufacturers
manufacturers_info

from the existing products_model values that you have entered in the products table and then update the table:
products

from the manufacturers table with the proper manufacturers_id so that the manufacturers_name will now show properly and be related correctly in your database between all the tables ...

Quote:

---

Originally Posted by Ajeh

So what you really need is a way to build the tables:
manufacturers
manufacturers_info

from the existing products_model values that you have entered in the products table and then update the table:
products

from the manufacturers table with the proper manufacturers_id so that the manufacturers_name will now show properly and be related correctly in your database between all the tables ...

---

I wish I knew how to do that. I don't know a thing about editing tables. That's why I was hoping EZPopulate mod would be an easy fix. Will the EZPopulate mod suit my needs?

EZPopulate is only a simple fix it really is better to do it the way that Linda says because that is how zen is set to work...

If you want to go the ezpopulate way and just change the model numbers the support thread with a link to that download is at :

http://www.zen-cart.com/forum/showth...ght=ezpopulate