Advice on adding a product variable with incremental pricing

We have a product table:

ProductID
Product Name
Price

A variables table (colour):

ColourID
Colour
Additional Price

And a link table:
rowID
ProductID
ColourID

The link table assigns which colour variables are available for each product.

On our product detail page, I'd like to offer a radio button select option for the colour because we'd like it set so that you can only order one colour variant at a time.

Problems with this...

If we offer a discount of 10% for 10+ purchases of an item, and someone has ordered 5 blue and 5 red, then will eCart pick up on that and still apply the discount?

How do we get the additional price value from the variables table to be applied to the final price before proceeding to our view basket page?

Appreciate the guidance, thank you.
NJ

"If we offer a discount of 10% for 10+ purchases of an item, and someone has ordered 5 blue and 5 red, then will eCart pick up on that and still apply the discount?"

depends how you set up the discount.

if it is set on a product ID, or category ID, it will apply regardless of the options added



see these tutorial for details on product options:

http://www.webassist.com/tutorials/Add-dynamic-product-options-I-eCommerce-Series


http://www.webassist.com/tutorials/Add-dynamic-product-options-II-eCommerce-Series

Relating to the tutorial about incremental pricing:
http://www.webassist.com/tutorials/Add-dynamic-product-options-II-eCommerce-Series

Some of our products (light bulbs) are dimmable and, if they are, we would like customers to be able to select that as an option and have an incremental price added. However, we don't want customers to have to select "non-dimmable", we want that to be the default.

In such circumstances is it best to include "dimmable" as an option in the OptionGroups table or is this better achieved another way?

Thank you
NJ

both options should be in the table.

create the recordset so that it it orders the result in descending order, this way non-dimmable will be the first in the list making it the default selected option.