MySQL Inventory Location Database Creation
Budget: $30 – $250 USD
I am looking for a skilled developer who can design a simple, yet efficient MySQL database for inventory management.
Key responsibilities will include:
- Creating a database that can carry out basic operations such as inserting new records, updating existing ones and retrieving inventory details using unique alphanumeric identifiers.
- Each record should contain specific details including a unique alphanumeric number, inventory name, location, date and time placed, and quantity.
The database should perform as follows:
- User interface screen allowing user to record a product has been place in a bin location by inserting the products unique alphanumeric number (called a style number), products name (called a style name), quantity by size (so for shoes could be 3 units in size 6, 4 units size 7 etc), and the bin location (example C2-4)
- User interface screen allowing user to record a product has been extracted from a bin location by inserting the same information as above. It must allow a partial extraction
- User interface allowing a user to perform a stock location enquiry by searching for a product by quantity by size / sizes and the interface returns the location / locations of each size. It should allow you to enter in multiple products on one enquiry. The report should be printable on A4
The successful freelancer should have extensive experience in MySQL and a solid understanding of inventory management systems. Attention to detail, adherence to deadlines, and high levels of accuracy are essential for this project.
Key responsibilities will include:
- Creating a database that can carry out basic operations such as inserting new records, updating existing ones and retrieving inventory details using unique alphanumeric identifiers.
- Each record should contain specific details including a unique alphanumeric number, inventory name, location, date and time placed, and quantity.
The database should perform as follows:
- User interface screen allowing user to record a product has been place in a bin location by inserting the products unique alphanumeric number (called a style number), products name (called a style name), quantity by size (so for shoes could be 3 units in size 6, 4 units size 7 etc), and the bin location (example C2-4)
- User interface screen allowing user to record a product has been extracted from a bin location by inserting the same information as above. It must allow a partial extraction
- User interface allowing a user to perform a stock location enquiry by searching for a product by quantity by size / sizes and the interface returns the location / locations of each size. It should allow you to enter in multiple products on one enquiry. The report should be printable on A4
The successful freelancer should have extensive experience in MySQL and a solid understanding of inventory management systems. Attention to detail, adherence to deadlines, and high levels of accuracy are essential for this project.