How do I extend MODEL description so that more charaters show?

[Kitty]

Hi,
Just wondering, how do i extend "Products Model" in the
Catalog>Categories>myproduct
so that there are more characters and i can write more in the model section?

If it can be printed on the invoice as well that would be great too

Thanks!

[poolprorich]

Hello,

Always back up your database first

products_model is set for 32 Characters in MySql in varchar mode. varchar can hold up to 225 Characters if set to that ,

Go to your phpmyadmin and edit this field with in the Length/Values put what you would like it to hold and save or if your not good with any of that kind of stuf paste this code in your sql patches tool in the admin section of your site:

ALTER TABLE products MODIFY products_model varchar(32 );

Set the red 32 to what you would like!
MySql should Hold all Your Information As it will Make a backup copy of your colum until it is finished changing the attributes of the cell,

as far as printing the model on invoice that function is included in zencart

Hope this helps