Zen Cart Logo

Option Value Length

Locked

Views: 1,640

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
26 Apr 2010, 6:28 PM
#1
greatlakesherbalife avatar

greatlakesherbalife

New Zenner

Join Date:
Apr 2010
Location:
MI
Posts:
14
Plugin Contributions:
0

Option Value Length

Ver 1.8.X

How do I modify the length of the Option Value in the Option Names in Option Values Manager In the CP?
The current length appears to be about 64 characters.
I want to include HTML for example....
<A HREF="/images/3106vanilla.pdf" target="blank">French Vanilla</A>
I would also like to stretch the box, so I can see what I typed. Is this possible???? I have read thru the Zen Cart Book, Searched forums, and WIKI, and still no results! :frusty::wacko:

I sort of had it working, until I exceded 64 characters. You can see it here....

http://greatlakesherbalife.com/index.php?main_page=product_info&cPath=5&products_id=2

Under French Vanilla.

Thanks!
Kevin Holley
Great Lakes Herbalife

26 Apr 2010, 6:41 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Option Value Length

You can customize the products_options_values table and change the the field:
products_options_values_name

You can try changing that to the type of TEXT and see if that works better for you ...

26 Apr 2010, 9:19 PM
#3
greatlakesherbalife avatar

greatlakesherbalife

New Zenner

Join Date:
Apr 2010
Location:
MI
Posts:
14
Plugin Contributions:
0

Re: Option Value Length

That won't work. I have Flavors and sizes and each flavor has a different label. I need to show that label, and so far, adding HTML to my Option Name is the closest I have come.

26 Apr 2010, 11:07 PM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Option Value Length

If you make the field type in the database table TEXT rather than varchar 64 ... then the field can contain a lot more than 64 characters ...

27 Apr 2010, 12:21 AM
#5
greatlakesherbalife avatar

greatlakesherbalife

New Zenner

Join Date:
Apr 2010
Location:
MI
Posts:
14
Plugin Contributions:
0

Re: Option Value Length

Are you talking about making this change in the database??? Rather than in the CP???

27 Apr 2010, 12:26 AM
#6
ajeh avatar

ajeh

Oba-san

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

Re: Option Value Length

Yes I am ... if you want to enter as an Option Value something longer than 64 characters ... that data is stored in the database in the products_options_values table and you need to change the field:
products_options_values_name

so that instead of being varchar 64 it is something bigger such as text ...