How to extend Product Model Field length in the ADMIN?

[Asdesign]

Hi,

I'd like to know how to change the maxlength="32" applied on the product model textfield when adding a product in the admin. I need to change this so I can workaround a design problem I have when some products need a long name to appear correct in my mirror site that is linked to a price comparison website. The workaround is basically to use the model textfield to hold the full name of the product needed to make it appear correctly in the price comparison website, while I can put whatever name I want in the product name so my design won't collapse. Later on, I'll change my mirror script to pull out the product name value from the MODEL textfield instead. Hope you understand so far. Last question I have, is basically, why is the model textfield limited to 32 chars? Any specific reason? Also, if I change this parameter or totally delete it do I also have to change something in the SQL? type of var? something like that?...thanks for any help.

[stevesh]

Not sure I understand completely, but if you want to increase the length allowed in the product name fields, that's done with phpMyAdmin in your hosting control panel:

http://www.zen-cart.com/forum/showthread.php?t=48154

[Asdesign]

Awesome...it's done like I thought it'd be. Thanks!

[new2u]

Did you ever get this to work. The link shows how to change the product name, which works, but i can't get the model field to work.

[Asdesign]

You can change the model field just like you do with the product name...you just have to increase the maximum chars value and it should work.

[new2u]

I have tried to increase the length of the product model field but am unable to.
I have changed the table under zen_orders_products to the following:

products_model varchar(64) utf8_unicode_ci Yes NULL

The default is 32. However even after changing it to 64, it is still stuck at 32. What am I doing wrong?

[Ajeh]

Be sure you change the model in two tables:
products
orders_products

NOTE: only new orders will have the new 64 character products_model ...

[new2u]

Is there any way to modify it to work on existing products?

[Ajeh]

I would test a new order to ensure it is working ...

The reason they do not magically fix in the orders_products is that you have "allowed" the new length to be added but the data was already added when the order was created ...

You would have to update the products_model in the orders_products table from the products table to get the full length for products that match ...