Product Name length

[Shawn Parr]

I tried a search and didn't find what I needed, I apologize if this has been covered before.

On a very small selection of items on our store, the default amount of characters available for the Product Name when creating new products in the Admin is just a few too short.

First off since I know this may be more involved I'm going to go ahead and ask a newbie-ish question: Which file is this located in?

Now I also expect that this could be more complicated. Is there a limitation in the code on this as there is also a limitation on the database field? If so is there a safe way to go about adjusting it without potentially causing chaos and destruction?

Thanks for any help. :)

[DrByte]

It's pretty safe to start by changing the length in the database. Be reasonable in the number you choose. The code will follow what you set...

[Shawn Parr]

Ah, very simple and elegant. I moved it from 64 to 80 and I hope that we will never need more than that. It works perfectly, and I thank you for your very speedy advice.

[Ajeh]

NOTE: Be sure you changed the length of the products_name in all tables ... or you will have some pretty short orders ...

[Shawn Parr]

Thanks for pointing that out Linda!

I dg through the tables just now in PHPMyAdmin, and the only place I saw products_name was in orders_products and products. Does that sound about right?

[Ajeh]

products table does not have a products_description field ...

[Ajeh]

er ... products_name field ...

[Shawn Parr]

You are of course correct. I mistyped the two tables where:

orders_products
products_description

Thanks again! :)

[Ajeh]

Technically, there is one also in the customers_wishlist table also, but that is not in the current code ... and intended for a future release ...

[polarduality]

I found this code in an old archived thread.

ALTER TABLE `products_description` CHANGE `products_name` `products_name` VARCHAR( 128 ) NOT NULL

Can I still use that code under "INSTALL SQL PATCHES" for the latest version of Zen Cart?

I would just replace the table name for each instance right?

orders_products
products_description
customers_wishlist

I would also like to make the category names longer.
Is there a document I can reference to see what tables/fields need to be modified?

I'm a noob and this is the first time trying to modify database tables.

Many thanks in advance for any help.