Here is the configuration that siteDirector uses The below system allows you to re-use option groups on multiple products.
Product Table =================== productID, title, sku ect.. 1 prod xxx, Option Table ==================== optionID, optionName 1 Color 2 Size OptionItemTable =================== itemId, optionID, itemName, itemPrice 1 1 Red 0.00 2 1 Blue 2.00 3 1 Green 3.00 4 2 Small 1.00 5 2 Medium 2.00 ProductOptions (This table combines the options and products) =========================== productID, optionID 1 1 1 2 Hope this helps! Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Chris Alvarado" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 10:24 AM Subject: E-Commerce, and Variations > Hello all, > > Wanted to pick your brains on some DB related stuff. > > Currently working on an E-Commerce site and deal with product variations > (size / color - which relates to price) and was curious to know if > anyone has any suggestions on table structure to best handle this, or > know of any good sites with reference. > > Logically what takes place is a certain size + color combination > constitutes the "configuration" of the product they are purchasing, as > well as determines the price. > > Just trying to get the relationship to make sense. > > Thanks all, > > -chris.alvarado > [ application developer ] > 4 Guys Interactive, Inc. > http://www.4guys.com > > "We create websites that make you a hero." > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.