you will need 4 tables:
products - product information
optiongroups - a listing of option groups such as color or size or voltage
options - the names of the options such as red or 100,000v
productoptions - linking table to link the options to the products
products:
productID - Primary Key
productName
productDescription
productPrice - this will be a base price since some of your option will effect price.
etc....
optiongroups:
optiongroupID - Primary Key
optiongroupName
options:
optionID - Primary Key
optionOptiongroupID - Foreign Key Relation to optiongroups.optiongroupID
optionName
productoptions:
productoptionID - Primary Key
productoptionProductID - Foreign Key Relation to products.productID
productoptionOptiongroupID - Foreign Key Relation to optiongroups.optiongroupID
productoptionOptionID - Foreign Key Relation to options.optionID
productoptionPriceIncrement - Optional column. This will be used to add to the price. for example, your stun guns the base price will be stun $20.00 in the products table. the 200,000v option will be set to 16 (20 + 16 = $36.00)
