Product Options with eCart-Value for Color in cart is ProductOptionID not OptionName

Good Afternoon,

I've just finished setting up Product Options with eCart and was hoping for some help fixing something. I've searched through the threads, but unfortunately what I attempted from them did not work. Thanks in advance for any help you might provide - its is very much appreciated.

1) I'm using the standard database and an almost stock implementation - Size and Color Options
2) I was able to get Price & Color increment working by added a record set for rsColorLookup and adjusting the code a bit.
3) On my product details page both drop downs look and work fine, but when I get to the cart the value for color is the 'ProductOptionID' rather than 'OptionName'
4) I found a thread that I think indicated to do the following -> Open Product Details pages / Double Click eCart Add From Recordset / select Bindings / select color / uncheck 'updatable'.

When I do this and select 'ok' my list/menu item for 'color' disappears. Is there a work around directly in the code? Or am I missing something from that tread on how to do this properly?

Thanks again - I've attached my product detail page.

Greg

in design view, select the color select list.

in the property inspector, click the Dynamic button.

set both the Label and the Value setting to use the Option name column, you currently have the value set to use the Option ID column.

Good Evening Jason,

Thanks for the quick reply. I did that and it did fix the name... I thought to do that, but I was trying to match the set up to the 'size' list/menu. Also when I make this switch I lose my price increment. It displays the name rather than the id but for options that have a price increment its no longer included in the total. Thought maybe I was going crazy so I switched it back and get the price increment, but also the ID rather than the name. When I attempt to adjust the binding to match the 'size' list/menu, but with 'color' to the 'rsColorLookup' I created it kills the menu/list for color on selecting ok. I've included my page with the change you suggested that fixes the name value, but loses the price increment.

Really appreciate the help!

Greg

the trick with product options that effect price is to not have the add to cart button create the select list, don't check the up-dateable option for the color.

if you look at the eCart options tutorial, it is broken down into 2 sections, options that don't effect price and options that do effect price.

in the tutorial, the color section does not effect price, and the size section does.

the size select list is created manually, a lookup recordset is created to lookup the price increment and size name, in the add to cart button behavior, the size and price increment columns are bound to the corresponding columns from the lookup recordset.

if the color will effect the price, it needs to be configured using the lookup recordset.

Good Afternoon Jason,

Thanks for the reply. That's what I had been attempting to do, I think. After successfully setting everything up to work with the tutorial 'as is' I went back and created a recordset for rsColorLookup. Not having a good knowledge base on the coding I changed the record set slightly using rsSizeLookup as the base. Swapping out 'size' with 'color'. When I open the 'eCart Add From Record Set' and select 'color' then attempt to uncheck 'updatable' and bind it in the same way as 'size' is to 'sizePriceInc' it seems to go fine, but when I hit 'ok' to get back to dreamweaver my list/menu for color disappears completely. Maybe I'm just going in a faulty order or something, but trying to follow the directions for 'size' exactly to create this one.

Appreciate the continued support.

Here is what the recordsets looks like:

Name: rsColor

SQL: SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName = 'color' AND productoptions.ProductID = paramItem

Variables:
Name: paramItem
Type: Numeric
Default value: -1
Run-time Value: $row_WADAproducts['ProductID']


Name: rsColorLookup

SQL: SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.OptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName = 'color' AND productoptions.ProductOptionID = paramOption AND productoptions.ProductID = paramItem

Variables:
Name: paramOption
Type: Numeric
Default value: -1
Run-time Value: $_POST['maddenBMX_eCart1_1_color_Add']

Name: paramItem
Type: Numeric
Default value: -1
Run-time Value: $_POST['maddenBMX_eCart1_1_ID_Add']

"but when I hit 'ok' to get back to dreamweaver my list/menu for color disappears completely."

yes, it will do that. Like i said, you nee to create the list manually, not have the add to cart button create it for you.

if you think back on following the tutorial, you had to create the list for the size manually. you need to create the list for the color manually as well since it will effect price.