I'm needing a custom web based searchable database with some features explained below.
We need the following fields for the database:
· Part Number
· Unit of Measure (UoM)
· 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.
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