Solved

inventory with product expiration dates

Posted on 2008-10-14
2
326 Views
Last Modified: 2012-06-27
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!
0
Comment
Question by:marcodiana
2 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 500 total points
ID: 22714521
Product
* ProductID -- PK
* Description
* Any other things about the product itself

ProductLot
* ProductLotID -- PK
* ProductID  -- FK to Product
* OriginalQtyInLot -- You might omit this ... but it could be useful information
* CurrentQtyInLot -- this must be decremented as you sell stuff off
* ExpirationDate
0
 

Author Closing Comment

by:marcodiana
ID: 31506005
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.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
T-SQL: Episode III - Revenge of The Dude 24 53
Help creating a spatial object in SQL Server 4 21
convert null in sql server 12 33
SQL Error - Query 6 25
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question