Write a Web Utility for Inventory Process
$30-250 USD
Dibayar saat pengiriman
We need a web utility for an inventory process. We will have the user import a 'master' inventory list. They will walk the store and scan items. This utility is checking the scanned items against the 'master' list, displaying results and saving that info to a database, which then can be exported. We included an example file that has been directly exported by our software. We would prefer to not have to do anything to this file.
Here's what we're expecting:
-reads a file exported from our software
-user scans upcs
-tries to find a match in the original file
-if it doesn’t, it returns an error: Scanned Item Not Found. Try Again. user must hit OK to continue
-if it does, it returns the product attributes:
-SKU, product name, UPC, amount in stock, product status
-User will be asked to select a reason
-The product info and reason, along with the date and time of the scan and the user, will be saved in a table (i refer to it as “scan database”) which can be only accessed by Admins. It can be exported to CSV by admins.
Scan Database Contents
Date of Scan
Time of Scan
User
UPC*
SKU*
Product Name*
Amount in Stock*
Reason
Current import file imported date
*this data comes from the imported file
Reason Table. (no reasons can be deleted, just hidden. Reasons can be reordered to display in certain order when prompted)
Reason ID
Reason Name
Visible
Order
Functions
Load a new file. File data should be cleared after 12 hours automatically. User can’t do the scan process without a new file. If the file is > 4 hours, it should warn the user that the file is old.
Start New Scan. If a new file is present, the user can start scanning products. A new file is <4 hours old (from import date). If not, it will warn the user. They CAN still scan with an old file. Scan process is outlined above (and below). each scan line will be added to the table. items will be displayed for the user until the user selects to clear that data.
Clear Data. This will prompt the user “This will clear the current view. Are you sure?” The displayed data will go away, the line items will stay in our scan database, but the imported file will remain.
Complete Scan. This will prompt the user “This will clear the view and clear the inventory file. Are you sure?” The imported file will be removed, the display will be cleared, the user will return to the “home” screen
Admin - Add User
Admin - Remove User
Admin - Add/Edit/Hide “Reasons”
Admin - View/Download Database data (allow filters for range of dates to be downloaded)
Admin - Delete database data (allow filters for range of dates to be deleted)
Requirements for UI
-Needs to be minimal (for ios/ipad display) and responsive
-Web based - user will load file from a desktop, then access the app from mobile.
-Time is EST (we are in NY)
Algorithm:
-Loads File
-Scans UPC
-UPC Found?
-Yes
-Prompt User For Reason
-Reason Table (can change names, can’t delete, can hide)
-Amount in stock 0?
-Yes - Add to scan database, display
-No - Add to scan database, display in Red Background, White Font
-No
-Display Error on screen
WILL NEED MOCKUPS PRIOR TO START PROGRAMMING
ID Proyek: #17176048
Tentang proyek
Diberikan kepada:
Hi, Greetings from PictusCode! We have highly qualified and dedicated team on Mobile Applications Development and have built moderate to complex products and features that directly impact the consumer experience. Lebih banyak
10 freelancer rata-rata menawar $267 untuk pekerjaan ini
Hello, I can help with you in your project Write a Web Utility for Inventory Process. I have more than 5 years of experience in Javascript, MySQL, PHP, Software Architecture, Visual Basic. We have worked on several Lebih banyak
Hello: I can make that for you. Let's talk when you can please. I have some client side scripts that I can adapt with a bar code reader.
I've carefully read your project description. I am ready to develop Web Utility for your inventory System. I am a PHP, Laravel, Codeigniter, Magento,JavaScript,JQuery and HTML expert having 6 years of experience and Lebih banyak