I'm sending you two schema's off line. Both are for a cookie business. We track each product individually. A product = shape+color+size. We use groups to associate cookies with similar attributes. You could use groups for your product attributes, setting up a new group type for each attribute. Groups can be dated to create sessions or primary display times or not.
One sheet is from an item's perspective and another is from an order's perspective. Please not that the business is primarily wholesale and therefore we use order/PO terminology instead of shopping basket. Also note that at this time, I don't track partial orders, although this is a simple attribute addition to the tabOrders. Also be warned that I am not a DB specialist, which may be abundantly clear from this design. I have sent the entire schema to a DB Designer for his comments. Regards, Andy -----Original Message----- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 8:48 AM To: CF-Talk Subject: RE: Shopping Cart Attributes I'm just looking for a db schema. When a new product is added it would be able to inherit existing attribute id's or it could create more if need be. Hope that makes sense. ~Jason -----Original Message----- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 9:31 AM To: CF-Talk Subject: RE: Shopping Cart Attributes Are you looking for DB schema and/or screen/display formats? If looking for DB, does the customer assign unique product numbers to each product/weight/color/size combination? Andy -----Original Message----- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 7:16 AM To: CF-Talk Subject: Shopping Cart Attributes Hi all, This is a theory question with regards to shopping carts that allow for inventory maintenance of the items in they display. "Suppose" I have a customer that has items with different weights, colors and sizes and wants to keep inventory of each one of them. They also only want to display the item once on a page but allow the user to select the size and weight in dropdown boxes based on current inventory levels. I've gone through several scenarios of how to do this on my own but I know I'm reinventing the wheel. Can I have some "best of breed" practices on this age old question? Thanks guys! Jason ------------------------------------------------- Jason Dowdell IM-AES Web Developer 321.799.6845 [EMAIL PROTECTED] ------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
