Re: Option Type Feature by Chandra

This message was sent from: Features
http://forums.oscommerce.com/viewtopic.php?p=221596#221596
----------------------------------------------------------------

[quote="OSCLex"]In the changes that need to be made to the table 'products_options_values', the instructions say to make the value of 'products_options_values_name' TEXT.  What exactly does that mean? Does that mean to set the Type to varchar?[/quote]No.  It means to type TEXT as the name in that row.
[quote][b]IMPORTANT: [/b]You should create *exactly one* TEXT Option Value.  Once you create this value, you should not change it.[/quote]The simplest thing is to use the insert_text_option_value.sql file through something like phpMyAdmin.  This will create the option (with name TEXT) for you.

For every product attribute that uses a text box, the option value should be that same TEXT value.  If you do not have this set correctly, it won't display the attribute you picked in the shopping cart, etc.

Hth,
Matt