I'd like some suggestions on how to handle an online shopping cart system where the inventory being sold will consist of products with expiration dates. I could have 10 cases of product X, but 5 cases expire in 09/2009 and the other 5 expire in 04/2010. I guess this is a variation of FIFO?
We'll need to run reports of expiring items so they could be discounted or whatever to get them off the shelves.
Any table structure (and other) suggestions would be greatly appreciated!