Change model to manufacturer

Since your prefix is zen_
try this via phpMyAdmin ... after choosing your "bryankol_zc1" or "_zc1" database from the phpMyAdmin pulldown menu ... and then clicking on the "SQL" tab in top center of screen:

Code:

---

truncate table zen_manufacturers;
truncate table zen_manufacturers_info;

insert into zen_manufacturers (manufacturers_name, date_added) select distinct products_model as manufacturers_name, now() from zen_products;

insert into zen_manufacturers_info (manufacturers_id, languages_id) select manufacturers_id, 1 from zen_manufacturers;

update zen_products p, zen_manufacturers m set p.manufacturers_id = m.manufacturers_id where p.products_model = m.manufacturers_name;

---

I think it's just the last one that failed in your last attempt ... but it's safe to do the whole thing again.

Quote:

---

Originally Posted by BryanKollar

P.s. I just donated $50.

You guys are awesome. I really can't believe its a free software, and you can certainly use it. I wish I could do more.

---

Many thanks. Every bit helps the project keep moving forward.

Ok, here's the new error message now!

5 statements processed.
ERROR: Cannot execute because table zen_manufacturers does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_manufacturers_info does not exist. CHECK PREFIXES!
ERROR: Cannot execute because table zen_products does not exist. CHECK PREFIXES!
Note: 3 statements ignored. See "upgrade_exceptions" table for additional details.

What can I do now please?

AND - the $50 is well spent. You guys helped me with several problems before, so its definately worth the money.

Bryan,
Can you run that most recent bit of SQL I gave you with phpMyAdmin instead?

Yeah, the one you just posted? I did that... That's the error message.

You know, instead of going back and forth in a message, we can do a live one on one chat through my customer support "Live Online Help" from my website! May be easier!

phpMyAdmin is "not" the same as Admin->Tools->SQL Patches ...

Beautiful! The new code worked in Myphp admin!!! All the names for the "model" is now under "Manufacturer".

Saves literally hours and hours of work.

THANK YOU!

SHOOT!

Ya know what?

After all that, what I wanted to do won't work, unless there is another way of doing it.

The reason I originally put "model #" as TF, for example, is because I wanted to list ALL products with the model "TF". BUT - when searching in the searchbox "TF", if I had a product that had "TFALL", it would pick that up and display it because the product name is "TFall" with T & F in front.

Then I noticed I could search "Manufacturer". So I thought "Great, I could just use this drop down list and choose manufacturer "TF" and have it display ALL the TF products. BUT - it seems I have to enter something in that search box. Some kind of letters.

So my last question is - can I search and display EVERY product with the manufacturer TF? Without entering in any letters in the search criteria box?

Do you have the manufacturers side box on ?

It does exactly that. Look here : http://beautyinglass.com and click on a manufacturer. In this case they are glass blowers / artists but the concept is the same :yes:

I do now!

Thanks Gorgeous, that did it. Now its 100%!