Serial Number Database
Our company sell products that each have a serial number.
We want a program where the customer can verify the Serial number to their item.
Main page of site will have details about our company and about the site and what the point of it is.
There should also be a search box to where the user can enter a serial number to search.
Once they search the serial number, the program should show them results if their serial number is in the database. (if not in the database, the user should be able to suggest we add the item with their details, they can fill out a form with details, and upload an image) this would send to the admin for approval or rejection.
once the user searches and find the item they are searching for the user should see limited information about the item (Name of the item and a photo of the item ONLY (at this time) )
The user should be able to create an account and "Claim" an item (when the user claims an item, program should put their "Claimed item in to a pending verification area for the admin to approve" Once approved it would be visible in their account) (at some point we will want to add in a function to print a report of their items that would list a thumbnail of the image the name the cost ect, This would be handy if they have a problem (theft or damage) so they could show this list to their insurance company)
The admin will compare the user that claimed the item to the details in the database and either deny the request or approve it. If the item is approved That item would show in that users "owned items"
The logged in user with owned items should be able to suggest edits (update information, update photo ect) They can change information and then the admin will see the suggested edits and can approve or deny all or part of the edit)
We currently have an excel DB started with about 1700 items inserted, there will be a over 10,000 items and will grow daily
Our DB currently has 7 fields (serial number, Name of item, Price paid, Invoice Number, Date of Sale, Place of Purchase and Customer name)
We would like to leave this open to be able to add 1-2 more fields in the future if needed
Once a not logged in user searches a Serial They would be able see the item name and photo, Once they claim an item and it's approved they would be able to see more information on that item.
We would like to be able to add items from admin
When adding if a user is registered, we could add an item they purchased to their account so they wouldn't need to claim it (we can talk about this)
Currently this site will not sell anything but will have SSL so any logged in info should be secure (or the whole site could be for that matter)
We MAY want to add in something in the future that would allow users to sell the items they own to other users of the site minus a % of the sale going to the owner of the site, but this would be in the future, NOT NOW!
As this database will have a LOT of information in it over time, we would want to be able to easily back up the database offline, and be able to restore a backup database
I am happy to talk with you to give more details if you need.
If we are happy with your work on this job, we will have a lot more work for you in the future!