> my client wishes to be able to add stock to a particular > product in their webstore, and this stock to be reduced each > time a sale is made. > > how have people done this? > > i figure i have a stock_level field (INT) for each product > and this is decreased by one each time a sale is made. once a > product reaches 0, the item can be made inactive for purchase > (or removed from catalogue until topped up).
That's pretty much all there is to it. > would it be of any benefit to keep a log of each time the > administrator adds stock to a product eg. date / stock added? That is a business question. If it's a requirement or desired feature, or you think it will be in the future, it's a benefit. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302088 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
