I can tell she needs a database for those jars.
I'd start with sitting down with her, looking her in the eyes and asking which colums should be indexed first.
Of course the model should allow for search using different indicators, like a date, a code or a shelf. But it needs an offline fallback in case the database gets fucked.
So the jars would need a human readable text too. Color coded stickers can also be used.
Inventory tracking based only on I/O is flawed and needs periodic corrections, that's why rfid marking of batches would be a good idea.
Gas sensors, including a methane sensor, should read the values in at least 4 locations, to detect any spoiled jars which didn't seal properly.
Not all jars should go through a FiFO queue, especially if they are of different sizes, so a logistics optimizer would need to fetch predictions from a food model for one week ahead
Sometimes a special OOB jar fetch may occur, caused by cravings, which also has to be included as an exception in the code and be handled properly, including batch breaking and requeuing for the FiFO mode.
Don't forget about empty jars tracking!
I'd start with sitting down with her, looking her in the eyes and asking which colums should be indexed first.
Of course the model should allow for search using different indicators, like a date, a code or a shelf. But it needs an offline fallback in case the database gets fucked.
So the jars would need a human readable text too. Color coded stickers can also be used.
Inventory tracking based only on I/O is flawed and needs periodic corrections, that's why rfid marking of batches would be a good idea.
Gas sensors, including a methane sensor, should read the values in at least 4 locations, to detect any spoiled jars which didn't seal properly.
Not all jars should go through a FiFO queue, especially if they are of different sizes, so a logistics optimizer would need to fetch predictions from a food model for one week ahead
Sometimes a special OOB jar fetch may occur, caused by cravings, which also has to be included as an exception in the code and be handled properly, including batch breaking and requeuing for the FiFO mode.
Don't forget about empty jars tracking!