sorry to post this again, but something weird happened last night to this mailing list?
just wanted to see how people managed stock levels in ecommerce applications. my thoughts so far are... 1. have stock_level field (INT) for each product 2. stock_level is decreased each time sale is made/confirmed 3. administrator may 'top-up' stock levels would it be beneficial to keep a log of each time the admin tops up stock eg. date/amount?? any thoughts would really 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:302119 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
