Greg, It really depends on the size of the store IMO. Peter Bell has written some excellent articles on ecommerce that I would encourage you to checkout. I also have a couple articles about shopping cart design, but Peter has an article that directly answers your question.
http://www.pbell.com/index.cfm/Ecommerce http://www.danvega.org/blog/ Dan Vega On 7/3/07, Greg Edmonds <[EMAIL PROTECTED]> wrote: > > This could be off topic, but I know many of you build shopping carts, so > maybe not. I have built several custom shopping carts (using Cold Fusion) > and I always struggle with the database design when it comes to products > with different options. Like a shirt that might come in small, medium, > large, etc. And could be red, blue or green. I guess I am wanting some > input on how others handle part numbers. Do you have a part number for > each > item? For example: > > ShirtLR - would be a large red shirt. > ShirtMB - would be a medium blue shirt. > etc. > > Or do you just have one part number, "Shirt" and build the part number > with > the options they choose? I have ended up with several different designs > over the years and was just hoping to get some insight for future projects > that would make this process a bit easier. Any kind of generalized advice > would be greatly appreciated. > > Thanks, > Greg > > ####################### > Greg Edmonds > Sitecon > http://www.sitecon.com/ > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282792 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
