We require a system to process our lost in the post orders.
We currently have to submit a monthly CSV file to Royal Mail with all the customers details, date of dispatch and product details manually.
We would like a system which is similar to the one we already have designed:
[url removed, login to view]
The system currently emails us a notification when the form is submitted, and allows the customer to print the form at the end. Once we receive the form we manually enter the details into our CSV file which is then emailed to Royal Mail at the end of the month.
We would like the system to be modified (or a whole new system) so that it adds the result of the users data into a database, which we can then export to CSV format.
Please note this is not a standard export, it must be in the format of the CSV file attached. The data requirements for the CSV file are outlined in the CSV [url removed, login to view] also attached.
We would also like the email function improved to email the customer a copy of the pdf lost in the post form and also email us all the details of the claim.
We have a spare MYSql database for use with the project.
In summary the functions required:
1)Allow customer to enter their address details, order number, product type and quantity and dispatch date. This must include form validation and a postcode lookup (automatic preferred, but link to Royal Mail will suffice).
2)Generate an html and/or pdf form with the required form for the customer to sign and date and post back to us.
3)Email us with the order/customer details so we can note the form will be arriving shortly.
4)Email the customer with a confirmation email and also the pdf/hml form incase they cant print the form immediately.
5)Add all the details to a database
6)Output the details to a csv file in the required format on request.
If you can help please let us know, if you require any more details please contact us.