Logic coding for items in store

[saidbakr]

Hello,

I can manage coding ( through the database and application ) for items in store and handling them into categories and so on.

My question is about how to handle some extra data about items. What I'm talking about is revealed through the following example,

Suppose there is item let we name it as "Cheese Max" and the store has two quantities of Cheese Max the only difference between them is manufacture date and hence the expire date. How could the application handle them?

I have one view to deal with situation, but I think it is not the most suitable, by regarding each quantity as a separate item. i.e. each one of them will have unique ID, but this will add unreal entity to the system.

Does any one have more ideas?

[laserlight]

The unique id should consist of the name and the manufacture date (or expiry date), since you say that "the only difference between them is manufacture date and hence the expire date". Using the quantity is a bad idea, since it is possible that the quantities could become the same.