Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

inventory with product expiration dates

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
marcodiana
Asked:
marcodiana
1 Solution
 
Daniel WilsonCommented:
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
 
marcodianaAuthor Commented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now