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?

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 ...

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/showthread.php?t=22180&highlight=ezpopulate

TinaS:

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/showthread.php?t=22180&highlight=ezpopulate

Yeah, but if you don't know what your doing, I may screw it up even more. So it narrows down to EZPopulate mod, or redoing my whole thing by hand.

Well, thanks gorgeous. Anything else you can assist with as far as how to do it Linda's way, i'd like to see what's involved and try it.

I am NOT a coder - sorry - I bet you one of the coders here would be able to give you a script or something to do this - but that being said what the proper steps would be is to enter your manufacturers in your admin area under Catalog/Manufacturers.

This would cause the manufacturers field on your site to be populated with the list you have entered - then you would be able to assign your products to a manufacturer.

One thing I just thought of is if you use EzPopulate to change model numbers you will end up with duplicate products because that is what Ezpopulate compares in order to determine new vs. updated products.

Also - EZPopulate has the manufacturers column so you could actually use that column - leave your model numbers the way they are and then let EZPopulate update your items with just the manufacturers info added.

Hope that helps.

Is it okay to delete existing manufacturers from your site in order to build the list from the products?

Tina's right ... with Easy Populate you could basically just copy or rename the products_model column to manufacturers_name ... or something like that ... and reload the file.

Or ... with DrByte and I banging a few hammers around ...

BACKUP YOUR DATABASE

And run the follow:
Admin ... Tool ... Install SQL Patch ...

truncate table manufacturers;
truncate table manufacturers_info;
insert into manufacturers (manufacturers_name, date_added) select distinct products_model as manufacturers_name, now() from products;
insert into manufacturers_info (manufacturers_id, languages_id) select manufacturers_id, 1 from manufacturers;
update products p, manufacturers m set p.manufacturers_id = m.manufacturers_id where p.products_model = m.manufacturers_name;

Be sure to BACKUP ...

Did you BACKUP first?!

Thanks Devs for suplying that code - I am gonna hang onto it just in case I have need in the future as well :)

I knew that my solutions weren't the perfect way of doing it ;)

Ain't that the sweetest little peice of code ... :smartass:

Heck ... it might even work ... :eek:

I tell ya, you guys & gals are great!

Its kinda late to try this today (gotta get up at 4am!), but I will be certain to try it tomorrow.

Thank you ever so much!

Ok, i'm embarassed.

I never backed up my database before (shame, shame, I know). Its about time I do, and now is the time before I install this nice peice of code.

So - can someone walk me through on how to back up the database.

I've logged into my control panel through my hosting company, and went to PHP My Admin. Now what?

I also see the database ZenCart. I clicked on it, and this is where I left off.

Anyone?

You can do this with the Export link in phpMyAdmin when you click on your database name ...

Or, you can download the Backup MySQL from the Downloads and install that on your site ... you will find the new Backup choice in your Admin ... Tools ...