We have a PHP web site with a SQL database that needs updating. The following 3 issues must be addressed:
1. Paypal transactions have stopped working properly on our system. When someone chooses to pay by Paypal on our site, the payment goes through and we receive an email from Paypal saying someone has paid, but the sale does not record in the author royalty account, or in the User Reports. In addition, the system no longer sends us an email with the Record Number and mailing address. The PayPal transactions do not seem to be recording in our system for any item (i.e. Not for book sales, wholesale orders or registrations). The payment processing system is working fine, but the internal notification afterwards is not. This needs to be fixed.
2. The web site automatically assigns a record number to new authors. We want to be able to log into the website database and manually add a letter to the record number, or edit it within the admin interface. Right now the system will not let us add a letter to the Record Number (i.e. we can manually enter a new record number say 4532 but it won't allow us to add a letter to this such as 4532L) You should enable us to add a letter to a record number through the admin interface.
3. We would like to make the password optional on the Bookstore registration so it is not required for a purchaser of a book to enter a password, though this would remain an option. We believe this just requires that the password field for the Bookstore sales be made optional rather than mandatory. The password will still be mandatory for the author registrations of course.
Quote must include a quote and time frame for fixing these items. Please let us know any questions. The URL and log in info will be given to the awarded coder.
Thank you and Good Luck!
24 freelancers are bidding on average $312 for this job
We provide our services in various countries for web site development,e-commerce web sites, shopping cart developing,web portals, building web sites with PHP, MYSQL web site development.
Hello, I have experience with MySQL/SQL and PHP. I can debug these problems for you, fix them, allow you to modify record numbers, and make passwords optional. Please see my PM.