Forums / Basic Configuration / Longer Product Names?

Longer Product Names?

Views: 1,020

Results 1 to 4 of 4
27 May 2011, 10:20 PM
#1
waneran avatar

waneran

New Zenner

Join Date:
May 2011
Posts:
3
Plugin Contributions:
0

Longer Product Names?

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. :cool:

27 May 2011, 10:28 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Longer Product Names?

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

Zen-Venom Get Bitten

28 May 2011, 9:03 AM
#3
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Longer Product Names?

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.

20 years a Zencart User

2 Jun 2011, 12:51 PM
#4
fajmp avatar

fajmp

Zen Follower

Join Date:
Jun 2008
Location:
Canada
Posts:
132
Plugin Contributions:
0

Re: Longer Product Names?

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?

Francine Harvey
http://talkingwalls.ca
Love is the beginning of knowledge.