Solved

inventory with product expiration dates

Posted on 2008-10-14
2
330 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Removing SCCM 2016 4 53
Using rowversion for incremental load of datawarehouse. 12 35
mssql 7 32
Importing from CSV to SSMS 2 11
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

739 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