Hello Imar,
Web shop is working fine till now and no problem is there. But I wanna show products like Shoes, Garments etc. which have a field Size and as you know that these types of products may contain multiple size and hence Price too (Price varies as size varies). In spite of showing different product for different size I want to show single product with multiple size values and when user go to shoppingcart.aspx page then he may select the size also and hence corresponding price is selected for the product.

So how would you suggest to store multiple size, price values for a single product and then manipulate the Total Price?
Thanks

Hi there,

This is a bit too extensive / complex to discuss in detail over a forum post. But I would probably create an additional database table called Variants that stores information that different for each variant (such as size, price and so on) and that has a reference to a Product. Then each Product gets a Variants collection that holds the different variants for the specific product.

Hope this helps,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Hi Imar,
Again coming back to topic. It seemed a little complex and beyond my approach so I left it that time.
But now I want to complete it. According your solution I would need to create a table say Variants with 4 fields Id, ProductId, Size, Price.
Then I need to enter different values for product that needs such variants. Right?

I will go on and hope you will suggest in time.
Thanks...

Hi Imar,
After a year again coming back to topic. It seemed a little complex and beyond my approach so I left it that time.
But now I want to complete it. According your solution I would need to create a table say Variants with 4 fields Id, ProductId, Size, Price.
Then I need to enter different values for product that needs such variants. Right?

I will go on and hope you will suggest in time.
Thanks...

-----------------------------------------------------

P.S. Please delete one of the two posts that I recently posted.

Yes, that's indeed how I would approach it,....

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Thanks for reply. As soon as I complete it, I will mention it here.