Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Product Options

Product Options

Thread began 6/24/2009 9:18 am by Nigel | Last modified 6/27/2009 9:35 pm by Nigel | 5442 views | 12 replies

6/24/2009 11:01 amRay BorduinWebAssist

If you have only one set of options per product... like size or color, and not two or more... then you can store that information with the options in a single options table.

Have an options table that has the productID as well as the optionName, optionSKU, and optionPrice.

If products have more than one option per then you need an intermediate table. If you are doing inventory control, then you need a separate product for each unique option combination.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.