inventory management

To create an inventory system which will entail: *Different user types to access the software differently *Inventory *Sales *Customers ## Deliverables To create an mysql php inventory system which will entail keeping track of: *Different user types to access the software differently *Inventory *Sales *Customers ? YOU MUST HAVE PRIOR EXPERIENCE WITH PHP AND MYSQL PROGRAMMING.? PREVIOUS INVENTORY SOFTWARE EXPERIENCE IS REQUIRED.? When you bid on this project, msg me previous work examples.? The attached zip file with pictures is a program we are using right now.? It does not have all of the features we need.? It only lets 1 user request a pickup and lets us add inventory to each pickup, but not much else. Service objective We pickup used computers, monitors, parts, network equipment, pieces, and other computer equipment from companies every day.? Every day we get different items and most? will not fall under the same inventory item as multiple qty.? We need a way to record information about each pickup for our records and our clients records.? We need to create an inventory list for each pickup request .? Basicly a company schedules a pickup request with us, our workers go to their office and pickup any and all of their used and or junk computer equipment.? We bring it to our warehouse and test it, format the hard drives, and remove any reference to the company from which it came.? Then we sell the equipment. ? This program will let us enter the inventory and help us on the backend in selling it.? As we enter the inventory we designate the shelf or pallet location of that inventory. ? ? I would like to print out inventory lists from each pickup or export to excel.? I would like to keep track of what we sold items for in each pickup and which salesman sold it.? I also need it to keep track of any cost of goods, my pickup costs, testing costs, and other overhead involved on a per pickup basis.? ? Then at the end of the month I can calculate profit after each pickup inventory is complete and all of the items are sold. I do not want to put inventory labels or stickers on each piece of equipment.? I want to record most things by serial #.? I do want to make a label to put on the pallet on which the equipment from a particular pickup will go.? For example, we bring in 10 pallets of computer equipment, we test them, and make it down to 6 pallets, I want the inventory system to tell me what the name of the destination pallets are so we can wrap them up and put them away in the warehouse. Sometimes there is a monetary transaction between me and the company we pickup the equipment at.? Sometimes it is a flat price, some times it is per piece, or sometimes we charge them. ? All equipment that is not reselleable we recycle it.? I will create invoices with equipment that is sold for recycling.? Then on the inventory sheet I would like it to say that particular item was recycled. ? A pickup is a specific lot of equipment we pick up at a company at a specific day.? So if we go to the same company on different days, that is two pickups.? ? If we go to two companies on one day that is also two pickups. I want to be able to search by serial # as well so I can tell everything about the item.? I have laptops we use in the warehouse with barcode scanners.? ? ? It would be best if the software was formatted to look good in a screen resolution of 800x600. ? ? ? Login as technician **Front page** - brings up page with list of pickups that are currently not completed Buttons next to each pickup will include ??" edit this pickup, add to this pickup, search this pickup Button on bottom of page ??" search all pickups, change # of lines viewed at one time At the bottom of the new record entry page it will have “I am finished button?? which will email me, but not call the pickup completed yet.? I will need to double check it before ME, superuser, calls it completed.? **Search function** to search for items in a pickup so we can edit or view those line items so we may have had to add more info or fix a typo.? Able to search either within a particular pickup or all previous pickups **Edit pickup** will bring up all previous items entered into that pickup for editing incase we made a typo somewhere and need to correct it or add something **Add to pickup** will bring up page with blank fields based on whatever superuser says is needed for that particular pickup.? ? A field with todays date and the technicians username is automaticly filled in for him.? ? There should be no error message if some of the fields are left blank when the page is submitted to the database.? If there are blank fields it should tell the user there are blank fields and give them a chance to fill them in while retaining any typed data in the text boxes to prevent loss of typed text.? Also one of the fields, which pallet or shelf location, will have a field you can fill in once and it will fill in all of the fields on the page to match.? For example, we are processing 100 computers and 50 monitors.? At the top of the page I say that this particular set of 10 should be going to pallet # A551.? It then auto fills in that field for the rest of the records on the same page and copies that value to the next page, but does not auto fill it in unless I hit the auto fill in button. **Change # of lines page ??"** default should be 10, but this will be how many line items the user will have when editing or adding to pickups ? ? ? ? ? ? Login as superuser **Front page** ??" shows list of pickups, both completed and not completed Button next? each pickup will be ??" add to pickup, edit pickup details, view inventory items, search Button on bottom of page ??" create sales invoice, view invoices, view/edit inventory, edit setup information, ? create new pickup,? edit user information, search all pickups **Setup information page** - Able to change which email all of the notifications get sent to **Create new pickup button** will create a pickup # and ask for a company name, a contact #, a contact name, a date it was picked up on, a date it was requested, # of pallets, weight, and date it was finished processing.? Able to define which fields will be entered in on by the technicians for a new pickup - date processed, technician performing work, asset #, asset company, asset #2, asset company2, serial #, brand, model, description, type of item (pull down menu), tested, cpu, memory, hd, optical drive, coa, destination box/pallet #, cost, Sale price, other, invoice #. **Add to pickup ??"** same as above for technician user **Edit pickup details** Able to edit any details or inventory about a pickup as well as mark it as completed, when superuser marks it as complete, it sends an email to whoever requested the pickup. Able to change who had requested that pickup, ie if I put the pickup in and want to transfer it to another owner so they are notified when it is done. **Edit user information** will let me add new delete technicians and add delete pickup requester users as well as their email addresses, **View/edit inventory ??"** bring up list inventory and list of pallet #s, can create invoice and pull line items or whole pallets out of inventory and put it into the invoice with only the important fields, not all of the fields need to be on the invoice.? When an item is sold, mark it as sold and who sold it and it will no longer be in inventory.? Also need to be able to put a cost of inventory for each item.? Sometimes it is a fixed $ sometimes it is a % of the sale price.? ? I should be able to go back to the inventory list and edit the list to include the prices of the items.? Also when we create an invoice I want to be able to change the price. **View invoices ??"** view all invoices created **create sales invoice ??"** create or edit a sales invoice for a customer.? I Want to add items from inventory to each invoice.? Sometimes an invoice can have 1 item or 40 items or 800 items.? I want to be able to add whole pallets or whole pickups or individual items.? When they are on an invoice the inventory list will have a colum which reflects which invoice # that particular inventory is on. ? ? Login as pickup requester **Main page -** List of all pickups requested by that particular user **request a pickup button** which will ask them for the current date, desired pickup date, company name, contact info, address, # of pallets, ? misc info They can click on each pickup and see the current status of it, complete, not complete, half way done It will email superuser with this new pickup request and information ?