An algorithm for accounting for the expiration date of different batches of goods in supermarkets?

Question

Online shopping

Good time of the day.
As you understood from the title, the task is to control the product for which the expiration date is suitable. Let's start with the input data and how everything works now:
1. The product arrives at the store and it is manually verified with paper invoices and the receipt is registered
2. Then the product goes to the warehouse or immediately to the hall on the store shelves
3. There it lies until the moment until it is bought or the seller notices that the product has expired.
What problems arise:
in order to understand if there is a problematic product
2. The human factor or just laziness
3. The speed of control of such goods
4. The expiration date for each product is different, sometimes there is a date until which date to use the product, and sometimes, on the contrary, there is a production date and how much the product can be used, as a result, this is a difficult verification process for employees without VO.
The solution we see is:
1. Electronic receipt of goods, in which each batch of goods is assigned a quantity, production time and shelf life
2. Daily notification of the appropriate dates for specific products and thereby stimulating the necessary checks
3. Warehouse accounting, taking into account the expiration dates of the batches
Questions:
1 What can be improved?
2. How do you see such a system?
3. Any advice, I will be grateful.
Thanks and have a nice day.

Answer 1

I don't think you're looking for an answer there. Programmers sit here more, they encounter inventory accounting less often than storekeepers or some purchasing managers, and when they do, they usually implement existing customer requirements (your "solution that we see"). And a warehouse is not only a program for accounting, it is also a room arranged in a certain way (so that you don’t put the same perishable milk where the path to it in a day will be blocked by wafers with a shelf life of a year) and business processes (in including those specific to you) and a bunch of everything else. There are a lot of nuances and you need to at least consult with network managers similar in size to yours, and not with coders, or look

Answer 2

I'll jump into the discussion.
You can't track anything without your barcodes. Classically, a barcode simply has a PN number for the product. !!!without date !!!. those. selling (= writing off from the stock), you do not know from which lot the goods left.
to relabel the goods - get angry. It is necessary to open each package, print the label and stick it on. Imagine labeling a box of curd cheeses ....
IMHO, it's non-automated here. rather, it is inappropriate.