Text Attribute

[jorsara]

I am working on a website where they sell Personalized Gifts. We need to add a text attribute where the customer can enter their initials or monogram. After setting up the attributes (thinkin it is correct) the function is not working.

Example: A pendant where customer can add a 3 letter initial: ex. BLA. How can we set this up where customer can enter these initials?

Any help would be greatly appreciated.

Jorsara.

[Ajeh]

You would need to create the Option Name for this as:

Option Name: Your Initials
Option Type: TEXT

There are not Option Values setup on Option Names that are Option Type TEXT

Next, go to the Attributes Controller and find your Product ...

Select Option Name: Your Initials
Select Option Value: TEXT/UPLOAD FILE

NOTE: be sure that both are highlighted in the boxes ...

If there is a price for this add it ...

If this is Required, mark the Attribute as:
Attribute Required
for Text: YES

Click INSERT ...

[jorsara]

Hello and thank you for the reply.

Where I am confused is after selecting the Option Name as "Text".

Where do I find the "Option Value: TEXT/UPLOAD FILE"?

Thanks,

[Ajeh]

On the Attributes Controller, this should appear in the right hand box for the Option Value ... after you have clicked on the Option Name for:
Your Initials

If it doesn't, then it sounds like you have missing values in your database table(s) ...

First, check that the table:
products_options_types

has 6 records to it with:

products_options_types_id 	products_options_types_name
0 	Dropdown
1 	Text
2 	Radio
3 	Checkbox
4 	File
5 	Read Only

Next, check the table:
products_options_values

make sure that you have a record for:

products_options_values_id 	language_id 	products_options_values_name 	products_options_values_sort_order
0 	1 	TEXT 	0

[jorsara]

Linda,

Thank you. I think I figured it out. It requires a few steps but I think it is working now.

Thanks again,

[Ajeh]

What was it that you found worked for you?

[jorsara]

What was it that you found worked for you?

Hello Linda,

Sorry for the delay response. I have found a round-about-way, but I don't think it is really the right way of doing it. I sent the option name as drop down then I add 2 or 3 value to it then I assign it to a product and then I go back and change it to "text". However, when I need the same attribute for a different product I have to repeat the same procedure even for the same option name and value. So, I don't think this is the right way of doing it.

If you could tell me the best way to do this, it would be great. I am sure I am missing a step in your explanation.

Thanks,
Jorsara.

[Ajeh]

You need to go to phpMyAdmin via your Control Panel, such as cPanel for your site and check the two database tables that I posted in #4 and see what records you have in them to see if you have at least the ones that I listed ...

Then from there, we can look at other possible causes ...

[jorsara]

I do have the products_options_types and the products_options_values in my php my admin. So, what else could be the cause?

Let's start over. What if want to offer customers the option to
customize a shirt for instance where they enter their name, i.e.
Michelle... or their initial. As I have mentioned before I have found a way to do it, but it takes a bit of manipulation to get it working right.

Thanks.
Jorsara

[Ajeh]

In the phpMyAdmin, click on SQL and run:

SELECT * FROM products_options_values WHERE products_options_values_id =0;

Do you get a record for:
products_options_values_name

set to TEXT ...