Attribute options with 2000 choices?

[jasmel]

I have several items that have personalization options.

Example: Music CD with child's name in it.

Shopper would find a Music CD, then add to cart and select the child's name from a option drop down menu. (or set the option to for personalization before adding to cart?)

Can this be done? Do I have to create each option one at a time or can I create all 2,000 names via Mysql script?

I tried to search the forums for this type of question but it seems either it hasn't been asked or I didn't phrase the search properly.

Thanks in advance!

[yellow1912]

Why? You can use the text attribute, which allows users to type in the name.

[jasmel]

Why? You can use the text attribute, which allows users to type in the name.

There are only CD's with these 2,000 names in them. Names like Jennica are not available however names like Jennifer, Jessica and other popular names are available.

I have to limit the customer's names selections to the ones that CD's have been made for.

[gjh42]

If you're comfortable writing a MySQL script, you should be able to automate populating the values for an option name in the database. See the Database Schema in the wiki for a list of tables and their field descriptions.

The fun part may be getting a usable dropdown to pick the name from.

[yellow1912]

Im thinking about Ajax ^^.

[jasmel]

Could I insert a standard html form with the output value going to the TEXT name textfield?

Select child's name: [drop down menu][^]
Output goes into TEXT area.

Then have the customer continue with the purchase.

I am not familiar with AJAX... is AJAX another option to get to my end goal?