Zen Cart Logo
Forums / Setting Up Categories, Products, Attributes / how to add a description to an attribute title?

how to add a description to an attribute title?

Locked

Views: 3,224

Results 1 to 12 of 12
This thread is locked. New replies are disabled.
3 Jan 2008, 3:40 AM
#1
lodestar avatar

lodestar

New Zenner

Join Date:
Jan 2008
Posts:
19
Plugin Contributions:
0

how to add a description to an attribute title?

i've added an attribute to some of my products, whereby we give our customers a choice between two types of packaging. so above the drop down box, it simply says "packaging".. i'd like to add a bit of text beside it just to give people additional information as to what their choosing between.

does anyone know how to do this?

3 Jan 2008, 4:10 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: how to add a description to an attribute title?

You could edit the Option Name ... there is a comment there to add text ...

3 Jan 2008, 4:58 AM
#3
lodestar avatar

lodestar

New Zenner

Join Date:
Jan 2008
Posts:
19
Plugin Contributions:
0

Re: how to add a description to an attribute title?

ahh yes, i didn't see that, thank-you!
the new problem is, it cuts off the text, despite me changing the rows to 5, display size to 12 and maximum length to 500. this should work, shouldn't it?

20 Feb 2008, 7:03 PM
#4
anubis avatar

anubis

New Zenner

Join Date:
Apr 2005
Posts:
40
Plugin Contributions:
0

Re: how to add a description to an attribute title?

lodestar:

ahh yes, i didn't see that, thank-you!
the new problem is, it cuts off the text, despite me changing the rows to 5, display size to 12 and maximum length to 500. this should work, shouldn't it?

Hi,

I have a similar problem in that when I have multple attributes, the comments aren't showing up. The first comment appears but attributes that follow are missing the comments field. Any ideas?

Matt

3 Jul 2008, 6:45 PM
#5
elkay avatar

elkay

New Zenner

Join Date:
Jul 2008
Posts:
4
Plugin Contributions:
0

Re: how to add a description to an attribute title?

you have to change the field-type of the the coloumn holding the option-comment in the mysql-database.

with your favourite mysqladmintool go to "products_options" table an change the type of the "products_options_comment" from varchar(64) to tinytext.

no comments should be saved in full length !

lukas

3 Dec 2008, 9:59 PM
#6
tharina avatar

tharina

New Zenner

Join Date:
Oct 2008
Posts:
49
Plugin Contributions:
0

Re: how to add a description to an attribute title?

The comments field for the description of an attribute holds only 60 characters.... so If I want to give a a longer description it cuts off my sentence...
Is there any way to set that comments block to hold more?
I am doing a application form with the attributes function and need to ask questions I can not fit into only 60 characters...
any ideas how to do a questionaire / application form other than with the attributes?:huh:

4 Dec 2008, 5:45 AM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: how to add a description to an attribute title?

Enlarge the field length in the database table(s) is the best idea when field(s) are not the right size for your needs ...

Peek in the products_options table for the products_options_comment field and enlarge that to better suit your needs ... :smile:

11 Dec 2008, 12:40 AM
#8
tharina avatar

tharina

New Zenner

Join Date:
Oct 2008
Posts:
49
Plugin Contributions:
0

Re: how to add a description to an attribute title?

I feel a bit embarassed but I have no idea how to change anything in the database tables. Because I know nothing about it I do not even know what to ask/search for.
Is there a idiots guide on editing databases?:blush:
I did a search on products_options table and products_options_comment field in the developers Tool kit and got the files options_values_manager.php and attributes.php
is this where I must enlarge the field length or is this the example? I can not see a field length anywhere

I will have to learn because I want to also add a extra options to the login that will require me to add an extra table to the database. (clients occupation & how many children they have and how old the children are)

I have made a backup of my database from my hosting cpanel and have a evergreendb.sql file and a backup-11[1].17.2008_21-36-51_evergree.tar file
is there a package like excell (that's the closest I can visualise a databse) that can open and edit the database and will it be all you have to do to edit it or must it be referenced somewhere.

Also I have an excell spreadsheet of 900 clients that they collected manually via emailed word applications over the years and there must be a way to import this into the database so they do not have to add it manually again.

any ideas or 'go look there's' would be appreciated
T

11 Dec 2008, 1:02 AM
#9
tharina avatar

tharina

New Zenner

Join Date:
Oct 2008
Posts:
49
Plugin Contributions:
0

Re: how to add a description to an attribute title?

Ok I found this....

You can use phpmyadmin to do this. In your web host cotrol panel, click on phpmyadmin. Then select your zen cart database.
Find the table products_description on the left pane. Click on it. On the right side pane, find the field products_name. Click on the edit button, it looks like a pencil. In the length/values set to 255.
wow! made myself look really stupid there (that I am in this!)

I will search the forum before I ask
I will search the forum before I ask
I will search the forum before I ask.....

11 Dec 2008, 4:21 PM
#10
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: how to add a description to an attribute title?

Thanks for the update that you were able to do this ... and for the update that searching around the forum does go a long ways ... :cool:

20 Jan 2009, 9:48 PM
#11
e81ny avatar

e81ny

New Zenner

Join Date:
Feb 2007
Location:
New York
Posts:
88
Plugin Contributions:
0

Re: how to add a description to an attribute title?

Hi Ajeh,

Is it possible to include an hyper link that will direct viewers to a certain page of the site in attribute comments??

Thanks in advance!

20 Jan 2009, 9:57 PM
#12
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: how to add a description to an attribute title?

If you fool with the comment ... you can get it in there, but if you edit the comment, I believe you will break the link as the cleaner functions do too good of a job ... :blink:

You can always edit it and add it back in should this happen ...