Closed

Website & IT -- 2

I'm needing a custom web based searchable database with some features explained below.

We need the following fields for the database:

·  Part Number

·  Description

·  Unit of Measure (UoM)

·  Location

·  Plant

·  Picture (optional field)

·  Asset Number (optional)

·  Notes (optional – will be used for search terms)

These need to be able to be uploaded by an excel sheet/csv, however the image, asset #, and Notes can be optional. We have 14,000 parts that need uploaded into this database, all with unique part numbers and descriptions and locations. Important: No part number can exist twice, and no part number can have two locations within the same plant. So we could have part number 4209 twice in the database, as long as they are different plants (MR02 and MR04) However 4209 cannot exist twice within the same plant. If this logic is too confusing, please consider making a separate searchable database for “Plant 2”.

We need 3 separate usergroups for:

·  Admin - can add and remove parts as necessary. Upload photos. Edit descriptions and every field. Able to import parts and update any and all fields. Able to mass upload and mass update all fields. A template to update by csv will be necessary.

·  Team leader - can do everything a User can do plus in the main menu an option to run a "drop ticket" (see description below)

·  User - Search the database and view all details and images and locations

In addition to this searchable database, we need a function for a Drop Ticket for the Team Leader usergroup.

This drop ticket system would basically be a shopping cart that the user can select any parts from the database and add to their "Drop Ticket" cart and submit their order for next days production. No payment option is needed, as the user would submit their order via email CSV. So if they select 10 items from the database on their drop ticket, it would produce a csv/excel sheet in an attached email for those 10 specific parts (not the image) to one specific email. Teamleader needs to be able to type in a quantity to order for each part selected for the drop ticket. No inventory management is needed, as this is deducted from our software manually later . The only fields needed to be displayed on the drop ticket email will be : Part number, location, quantity (that they typed in on confirmation page), and unit of measure. Also will need a “Notes” section the csv/email (different from notes field in database) that will allow us to print out this list, and write in notes manually when we need to write in notes (Example: out of part, or could only give qty 3 instead of 6)

If possible, On the TeamLeader usergroup, we'll want to set certain products as "Department products commonly used" and these items will show up on top for that specific department. The TeamLeader or Admin can select these parts as “common” parts. It will usually be around 50 items that the department gets on a daily basis. These will be items the department usually gets but can still search to add any of the other products to their drop ticket cart. These items will just show up on the top of the table. (This could be another “field”=common part) and if common shows up on top of table for TeamLeader usergroup (Remember: multiple teamleader logins will be required for each department)

We will need the option to add different Team leaders usernames via admin for each department in our plant. (Painting dept, main line, etc) We will have up to 20 departments. User can be one standard login, as well as Admin.

These lists will be printed off, and items “picked” by associates and brought to departments daily upon receipt of getting an email.

Skills: Database Programming, Graphic Design, PHP, Website Design

See more: inventory management system website html, sales inventory management system website, integrate inventory management shipping management website, developing inventory management website, type inventory management adidas offer, amazon inventory management, amazon inventory management php, css template inventory management system, transfer website inventory ebay, website inventory, inventory management api amazon, inventory management amazon, php inventory management system, design interface inventory management system using vbnet, develop inventory management projects

About the Employer:
( 1 review ) North Vernon, United States

Project ID: #12520570

13 freelancers are bidding on average $240 for this job

codinglogics

I would like to ask some important questions concerning your project.I look forward to your response and will reply soon once I hear from you. Regards, Codinglogics

$166 USD in 3 days
(438 Reviews)
7.5
evadevlopers

Hi There, Ready To Start now. I have 4+ years experience in PHP as well as Wordpress, Magento,OpenCart, Prestashop, OsCommerce….and also in responsive CSS3, bootstrap, html5 . etc You can check our work http://www More

$250 USD in 2 days
(206 Reviews)
6.8
snapycode

Hi, You want a web based searchable database with Drop Ticket functionality !! I will build you super simple to use & manage yet look and feels modern and very convenient for your users/visitors. I am a professional More

$200 USD in 7 days
(46 Reviews)
6.4
genpexitsolution

Hello sir, Greetings from GenpEX IT Solutions..!! I have read your post and came to know that you want a web based database. We can provide you with best database in Odoo. It is an open source web based ERP ap More

$526 USD in 10 days
(28 Reviews)
6.3
ARKSolution2015

Dear Hiring Manager, Experience : 4+ years I will do it for you with perfection and I will keep working on it until you are 110% satisfied with results. Feel free to message me. we can discuss price and project More

$250 USD in 15 days
(116 Reviews)
6.1
$155 USD in 3 days
(50 Reviews)
5.2
phonedroidapps

Greetings, WE WILL DO THIS WORK AS PER YOUR REQUIREMENT AND EXPECTATIONS. With the experience of over 1600+ web development projects including ANDROID , iOS , WEBSITES , WEB APPLICATIONS AND SOFTWARES we are the fa More

$144 USD in 3 days
(4 Reviews)
6.2
sudhakar692

Hi, I Just had a look at your project and after thoroughly study the requirement, i understand the whole concept and would love to work on it. Here is my brief introduction, I have an experience in developing web More

$500 USD in 20 days
(6 Reviews)
2.6
Hassan1859

Hello there, I had a chance to go through your complete job description. And we think this is the best project matching with our skills. I would like to have a verbal conversation with you to walk through your web de More

$155 USD in 3 days
(4 Reviews)
2.5
mbtech5050

Hello there, Hoping you to be in the best shape of health, I had a chance to go through your complete job description. And we think this is the best project matching with our skills. I would like to have a verbal conv More

$155 USD in 3 days
(6 Reviews)
2.7
ExperSolutions

We are team of excellent developers and writers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description More

$122 USD in 3 days
(2 Reviews)
0.0
Aballiu19

A proposal has not yet been provided

$222 USD in 5 days
(0 Reviews)
0.0
davidrudd

My browser-based cloud database application service INCLUDES ALL SERVICES in a single plan: DESIGN, DEVELOPMENT, HOSTING, TRAINING, and SUPPORT --one low monthly fee to fully support your application needs. Don't le More

$277 USD in 5 days
(0 Reviews)
0.0