Text Attribute

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.

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

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,

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:

Code:

---

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:

Code:

---

products_options_values_id        language_id        products_options_values_name        products_options_values_sort_order
0        1        TEXT        0

---

Linda,

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

Thanks again,

What was it that you found worked for you? :smile:

Quote:

---

Originally Posted by Ajeh

What was it that you found worked for you? :smile:

---

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.

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

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

In the phpMyAdmin, click on SQL and run:

Quote:

---

SELECT * FROM products_options_values WHERE products_options_values_id =0;

---

Do you get a record for:
products_options_values_name

set to TEXT ... :unsure:

Next, in phpMyAdmin, browse the table:
products_options_types

Do you see:

Code:

---

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

---

Quote:

---

Originally Posted by Ajeh

In the phpMyAdmin, click on SQL and run:


Do you get a record for:
products_options_values_name

set to TEXT ... :unsure:

---

I did and yes I got the "Set to Text".... now what?

Thanks,
Jorsara

I am sorry, disregard the last reply. I did not the "set to text" this is what I see after running the SQL

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0003 sec )

SELECT *
FROM products_options_values
WHERE products_options_values_id =0;

LIMIT 0 , 30


Please advise.

Thanks,
Jorsara

In phpMyAdmin, run the SQL:

Quote:

---

INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT');

---

What happens now, if your try to add a TEXT Attribute to a Product?

Forgot ... do you see ALL of the Option Name types from post #11 in your database?

Yes, I do!

And what happens if you add the SQL statement I posted in post #14? :unsure:

Okay, I ran the process and now I have the Text/File upload. I will test it and let you know.

Thank you for all your assistance.

Jorsara.