not if you ant to be able to display product groups with various options (i.e. size, colour, etc)...
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mark Fuqua wrote: > Not an expert and this might be really stupid, but what is the advantage of > making products with options...why not make each product option a different > product? Seems it would simplify what you need to do. > > Mark > > -----Original Message----- > From: Mike Little [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31, 2008 8:46 PM > To: CF-Talk > Subject: product query - need an expert > > > help! i am stuck... > > ok, for my product catalogue i have included a basic inventory system. > > product > ------------- > product_id > track_stock BIT > stock_level INT > reorder_level INT > > product_to_product_options > -------------------------- > product_id > product_options_id > stock_level INT > reorder_level INT > > product_options > --------------------- > product_options_id > product_option_title > > basically, if a product has options (eg. small, medium, large) then the > stock is tracked at the option level. if not then it is tracked at the > product level. > > my big problem is, how do i determine if a product is available for purchase > eg. it has a stock level of zero - either at the product level or for a > particular option? > > i need to develop a system for displaying products on a summary page. > > any help would truly be appreciated. > > mike > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302397 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
