Product Options Issues
I'm using the Product Options tutorial to try to drop size and color options into my store.
When I test my store the dynamic list/menu is not populating. If I change the "Options from recordset" from my rsColor to the products record set, rsProducts, the list will populate with all of my products.
Here is my SQL Code:
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options INNER JOIN productoptions ON options.OptionID = productoptions.ProductOptionID INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName = 'color' AND productoptions.ProductID = paramItem
And the Variables
Name: paramItem
Type: paramItem
Default Value: -1
Runtime Value: $row_rsProducts['ProductID']
When I created my add to cart button I left the color "Default Value" blank under the Bindings tab. Should this have a database call in it? I'm also not doing a price increase so I didn't do anything with the sizeInc. calculations.