Write a Web Utility for Inventory Process

Selesai Dipasang 5 tahun yang lalu Dibayar saat pengiriman
Selesai 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

JavaScript MySQL PHP Perancangan Perangkat Lunak Visual Basic

ID Proyek: #17176048

Tentang proyek

10 proposal Proyek online Aktif 5 tahun yang lalu

Diberikan kepada:

pictuscode

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

$222 USD dalam 3 hari
(0 Ulasan)
0.0

10 freelancer rata-rata menawar $267 untuk pekerjaan ini

schoudhary1553

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

$250 USD dalam 3 hari
(168 Ulasan)
7.3
urgentprogrammer

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.

$155 USD dalam 3 hari
(74 Ulasan)
5.7
b2ecoder

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

$200 USD dalam 10 hari
(4 Ulasan)
3.1