Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › database setup where price depends on size and color,style are options.

View all replies to this thread

database setup where price depends on size and color,style are options.

Thread began 4/14/2010 9:12 pm by sologray | Last modified 12/11/2013 10:16 pm by sologray | 8196 views | 12 replies

7/30/2010 11:50 amJason ByrnesWebAssist

each row in the ProductOptions table assigns 1 option to the product.

you need to add rows to the product option table to assign all of the available sizes, colors and styles for each product.

I was merely giving a sample of how One of the available options gets assigned to the product.

If your product stock is option dependent, then you will need to create a separate table to account for the stock for each available product combination.

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.