We run a restaurant chain and get customers to fill up feedback forms which capture a variety of things like whether they liked our food, whether they would come back, etc. along with their name, address, phone number, email address, date of birth, date of anniversary, etc. We want to create a web based system which will enable us to enter all the customer data into a database so that we can track our customers more easily and search the data as well and generate reports using either jasper reports or some other tool. We would like to have the option of entering data into an Excel sheet and then importing into the CRM database on a daily basis or for entering new customer data directly into the web based CRM. There will be two types of dine in customers ??" one will be a new customer who is not registered in our CRM. A blank feedback form will be printed out and will be given to the customer who will fill in the details using a pen and this feedback form will be sent to our head office where the customer information will need to be manually entered into the database by someone at our office and the bill number of that transaction will have to be linked with the new customer information to maintain a record of that and future transactions of the customer. The second customer will be a registered customer who has dined with us before and exists in our system. The feedback and bill number information will get added to the existing customer record in this case and this will enable us to avoid duplicates in the system and also allow us to track frequency of customer visits. Would like to be able to do the following things with the information: Generate reports of various types ??" feedback scores, customer profiles, etc. - the more dynamic this can be the better Send customers emails/sms msgs either in group or even customised individual messages based on their preferences. We will provide the SMS gateway API
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
* * *This broadcast message was sent to all bidders on Monday Oct 25, 2010 12:33:04 AM:
More information has been added on the project - please submit your final bids - thanks
Would like to use MySQL database running on a linux server.