Longer Product Names?

[waneran]

I'm using Zen Cart v1.3.9h. I currently have it installed on my local machine testing Zen Cart before I put it to our production environment.

I have just started creating products. We are a retail computer store. Some of our product names are very long. I have run into an issue where the Product Name field in the Create Product page does not allow enough characters for what we are wanting to use.

example product name:

Intel Core i5-650 BX80616I5650 Clarkdale 3.2GHz LGA 1156 73W Dual-Core Desktop Processor - Retail


Is there any way for us to expand the product name field?

Thanks in advance.

[kobra]

I would shorten the name and include details in the description

Changing the record lenght has to be done in the database using something like phpmyadmin

[schoolboy]

You can expand the FIELD SIZE in the database. It currently is set to hold 64 characters (VARCHAR=64). You can expand it - I would recommend no larger than 255.

There are a couple of affected TABLES in the database where this field is referenced, and you need to set the VARCHAR value in each instance.

TABLE orders_products
TABLE products_description
TABLE customers_wishlist

Database changes are done via your host account cPanel, using phpMyAdmin.

If you are not familiar with phpMyAdmin, best not to tinker around with a live store. Either test your handiwork on a test install of ZC, or ask someone who does know phpMyAdmin to assist you.

[fajmp]

I've changed my products_description...products_name to varchar 125(and products_order..products_name to varchar 125 in my cpanel...but it doesn't change anything in my admin product information length of the product name.
Is there something that I'm missing?