<div>
THANK YOU! &nbsp;I knew I was over-thinking this and needed to have outside eyes point me in the right direction. &nbsp;Based on this structure, I can accomplish all of the other pieces I'd need, and accomplish them rather easily. &nbsp;I couldn't see the forest for the trees. &nbsp;:-) &nbsp;Thanks again.
</div>


THANK YOU!  I knew I was over-thinking this and needed to have outside eyes point me in the right direction.  Based on this structure, I can accomplish all of the other pieces I'd need, and accomplish them rather easily.  I couldn't see the forest for the trees.  :-)  Thanks again.

<div>
<div class="content wysiwyg-content">
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. &nbsp;I could have 10 cases of product X, but 5 cases expire in 09/2009 and the other 5 expire in 04/2010. &nbsp;I guess this is a variation of FIFO?<br />
<br />
We'll need to run reports of expiring items so they could be discounted or whatever to get them off the shelves.<br />
<br />
Any table structure (and other) suggestions would be greatly appreciated!
</div>
</div>


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!

inventory with product expiration dates

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.