ARGH! No checkbox ability???

[ceramickeepsake]

I'm four days into my online store, after finally getting the store area to look similar to the rest of my website, and while adding attributes to my products, I realized that I can only use dropdown menus - no checkboxes!! What I wanted to do was to let people add extras - first name, middle name, gift wrapping, etc., and without making tons of categories I can't do this.

(Also, I'm guessing that I couldn't have a field where the person enters text into a field...)

*ARE* there contributions that do this well, and if so, how hard are they to figure out???

Karen
www.ceramickeepsakes.com

[stevel]

Try this contribution (http://www.oscommerce.com/community/contributions,160). I haven't used it so I don't know how easy it is.

[ceramickeepsake]

ok... I downloaded the contribution, and I'm stumbling through the directions in the readme file. I got to step #3, and I'm stumped - how do you run a .sql file? (and if you can't answer that, I'm able to get into my MySQL database, but I don't know how to do what they're saying manually...)

Here's what step #3 says (the table cells are separated with a ~):
STEP 3. Set up your TEXT Option Value.
Add a new record to the table products_options_values.

You can either use the enclosed insert_text_option_value.sql or you can manually update the table.
(Note: The file will create three entries with products_options_values_id=0. One with language_id=1 (English), one with language_id=2 (German), and one with language_id=3 (Spanish). If you use other languages then you must create a new entry for each additional language.)

products_options_values_id ~ language_id ~ products_options_values_name
An id that is unique to the table. Recommend 0 if it is unique or last id + 1. ~ Set to your language id ~ TEXT

IMPORTANT: You should create *exactly one* TEXT Option Value. Once you create this value, you should not change it.

If you use a products_options_values_id that is different than 0, then you also need to update the following line in your catalog/includes/configure.php file.

define('PRODUCTS_OPTIONS_VALUE_TEXT_ID', 0); //Must match id for user defined "Text" value in db table TABLE_PRODUCTS_OPTIONS_VALUES

[stevel]

Go to http://phpmyadmin.powweb.com/ - log on to your SQL server with the SQL username and password. Click on your database name, then the SQL tab. There is where you can enter the SQL commands or browse to a .sql file and execute them with the Go button.

[ceramickeepsake]

thanks once again, steve!

[ceramickeepsake]

Ugh - I got everything installed, and then realized that it wouldn't allow me to do a LIST of checkboxes like I wanted, you have to do each choice separately... (i.e., Gift Wrap? [ ], Gift Card [ ], etc.) Also, I thought that if you did a text box, you could assign a value to it if it were filled in, but that's not working for me. For example: Add a first name? [ ] (+ $5.00) <---- the $5 isn't being added in. So far, the only solution that I see is to add a check box with the $5, then have the text box below it, but I'm concerned about someone adding text but not checking off the field, thereby getting around the added cost. :(

Any suggestions?

[stevel]

I'd suggest finding the "support thread" at forums.oscommerce.com for this contribution and asking there.