Warehouse Management Web App
Budget: €30 – €250 EUR
I'm looking for a talented web developer to create an application that manages the inventory of food items in a single-warehouse setting. Your responsibility will be to design, develop and implement a tool that organizes our stored food products, keeps track of quantities, and alerts warehouse personnel when supplies are low or near expiration.
Required expertise:
- Strong experience in web development, preferably involving inventory management systems.
- Knowledgeable in database design to effectively categorize and manage food items.
- Experience with alert systems would be advantageous.
- Proven ability to deliver a system that facilitates easy access and updates.
- Ideally has past work with warehouse management systems, particularly those for a single-location setup.
a web app to manage a goods warehouse.
this archive to manage different databases:
company archive
id_az(progressive), user, pass, azienda, database, password
these internal database archives:
access these tables through the company archive
personal archive
id_pc(progressive), id_az, persona(50), telefono, password
category archive
id_ct(progressive), categoria
product archive
id_pr(progressive),id_ct,categoria,descrizione,qta_min,qta_media
warehouse archive
id_mz,id_pz,id_cz,id_pr,categoria,descrizione,qta_min,qta_media,attuale
1) login screen to access the table database
2) menu screen to choose 1) personal, 2) category, 3) products
3) personal archive insertion, modification and deletion screen
4) category archive insertion, modification and deletion screen
5) product archive insertion, modification and deletion screen
- when you create a product it must also be saved in the warehouse archive with
id_pc=0 and attuale=0,
- when modifying a product all the data in the warehouse archive must be updated (with the exception of "id_pz" and "attuale")
6) screen to assign the id_pz to each record in the warehouse archive
7) screen to view the warehouse archive
(with the possibility of viewing everything, only those with attuale<=min_qta and attuale<average_qta)
according to this scheme in alphabetical order by categoria and descrizione
DESCRIZIONE PRODOTTO ATTUALE
descrizione attuale
ALTERNING WHITE LINE WITH GRAY LINE FOR BETTER READING
8) login screen for staff user=telefono and pass=password
9) screen where staff can only modify the "attuale" value
and will only be able to see the marked items in the warehouse table
from your pc_id
Required expertise:
- Strong experience in web development, preferably involving inventory management systems.
- Knowledgeable in database design to effectively categorize and manage food items.
- Experience with alert systems would be advantageous.
- Proven ability to deliver a system that facilitates easy access and updates.
- Ideally has past work with warehouse management systems, particularly those for a single-location setup.
a web app to manage a goods warehouse.
this archive to manage different databases:
company archive
id_az(progressive), user, pass, azienda, database, password
these internal database archives:
access these tables through the company archive
personal archive
id_pc(progressive), id_az, persona(50), telefono, password
category archive
id_ct(progressive), categoria
product archive
id_pr(progressive),id_ct,categoria,descrizione,qta_min,qta_media
warehouse archive
id_mz,id_pz,id_cz,id_pr,categoria,descrizione,qta_min,qta_media,attuale
1) login screen to access the table database
2) menu screen to choose 1) personal, 2) category, 3) products
3) personal archive insertion, modification and deletion screen
4) category archive insertion, modification and deletion screen
5) product archive insertion, modification and deletion screen
- when you create a product it must also be saved in the warehouse archive with
id_pc=0 and attuale=0,
- when modifying a product all the data in the warehouse archive must be updated (with the exception of "id_pz" and "attuale")
6) screen to assign the id_pz to each record in the warehouse archive
7) screen to view the warehouse archive
(with the possibility of viewing everything, only those with attuale<=min_qta and attuale<average_qta)
according to this scheme in alphabetical order by categoria and descrizione
DESCRIZIONE PRODOTTO ATTUALE
descrizione attuale
ALTERNING WHITE LINE WITH GRAY LINE FOR BETTER READING
8) login screen for staff user=telefono and pass=password
9) screen where staff can only modify the "attuale" value
and will only be able to see the marked items in the warehouse table
from your pc_id