We have two different databases
1. MYSQL invoice database
2. web based MYSQL Shop database.
Whenever a customer orders online, his data will first be stored in the web based data base (WBDB) and then be downloaded to our invoicing program.
The program we need has to do the following:
Upon entering the invoice no., the program retrieves data from the local invoice database (LIDB). It checks whether or not the invoice was based on a online sale (shop # yes/no). Then, the cursor jumps from the Invoice # field to the package # field, where the TT # of the parcel has to be entered. If the customer has provided an email address, an email will be send to the customer, notifying him that his parcel has been sent. Then, the parcel # will be stored in the LIDB. If it was a online order, the parcel # has also to be stored in the WBDB.
So, the program is meant to be a simple track and trace information tool for customer service.
Dear Sir/Madam,
We would like to inform you that we understand your requirement and very much interested to work with you in this project as well as in future projects. As per the requirements you have mentioned, from our experience and technogical expertise we are confident that we can develop the best quality solution for your best business needs at your utmost satisfaction.
From our experience & knowledge, we understood this project needs a timeline approximately 30 business days including full-proof testing and the project estimation would be approximately USD 1000-1200.00. We are looking for the opportunity to work with you together to build and sustain a long term business relationship with you as well as to prove ourselves with our best technical ability and knowledge base. If you think we could be your choice as your IT service provider, pls let us know, we will be always happy to serve you with our best quality, knowledge based and world standard services and solutions. Looking forward to hear from you.
Thank you and waiting for your mail.
Regards,
Team Apices