OScommerce expert to fix DB errors, HTML/Javascript, Automated email to Admin+Customer (POP3 issue) & other issues
$30-250 USD
Paid on delivery
BUDGET US$ 50
Prefer coder to have production server
Basically, want to upgrade code to PHP 7.XX.
PRIORITY is to get DB working first before doing other points
1/ FIX: DB error
Site does not load
See: error-message
--------------------------------------------------------
Warning: mysqli_connect(): (HY000/1044): Access denied for user 'XYZ'@'localhost' to database 'ABC' in /ABC/admin/includes/functions/[login to view URL] on line 25
Warning: mysqli_set_charset() expects parameter 1 to be mysqli, boolean given in /ABC/admin/includes/functions/[login to view URL] on line 32
Unable to connect to database server!
--------------------------------------------------------
2/ FIX: CUSTOMER & ADMIN to get auto-email
Already coded but suddenly stopped working few years ago.
Should require little work
Currently using POP3. Use SMTP instead?
Prefer POP3 solution unless good reason
3/ IMPLEMENT additional fields at top of report (auto-email to ADMIN, /print-order page.
NOT apply to auto-email to Customer
See: automated-email-to-admin
automated-email-to-customer
Date:
Time:
User IP address:
Browser Agent:
Order No:
Subject: [see 4 below for details]
ACTUAL BODY TEXT CONTENT OF EMAIL UNCHANGED, ALREADY CODED
BACKGROUND:
(Already coded, stopped working)
A/ Admin gets 1 email at 2 stages:
- 1st: when customer successfully onClick SUBMIT form (/[login to view URL])
- 2nd: after successful payment (Paypal is processor)
B/ /[login to view URL] only shows report ONCE (after payment successful) .
No report generated after onClick SUBMIT
C/ Customer same as B/
4/ IMPLEMENT: auto-email to Admin AND /[login to view URL]) have subject title containing certain customer input
Not already coded
See:
automated-email-to-admin
automated-email-to-customer
Format:
ORDER SCAN / DISPATCHED #echo["order_number"]: echo[Product class1] nbsp&
echo([payslip_dates]) {Product class2] "p60_taxcode" [Product class3] ["p45_dlday"] "-"
echo("employer_name") "/" echo["droptitle"] nbsp& echo["fname"] nbsp& echo("lname")
If Null input, no output shown
(if customer has ordered a product from each of three product classes (Payslips, P60, P45), subject title will show eg):
--------------------------------------------------------------
ORDER SCAN / DISPATCHED #19678: Payslips (1/12/2018,1/1/2019) P60 (2018/19**) P45 (15/10/2019) - ABC Limited / Miss Jane Smith
--------------------------------------------------------------
BACKGROUND:
A/ variables are from /[login to view URL]:
id="order_number"
id="employer_name"
id="payslip_dates"
id="droptitle"
id="fname
id="lname"
id="p60_taxcode"
id="p45_dlday"
Need to determine product class (3 classes):
Product class1 is "Payslips"
Product class2 is "P60"
Product class3 is "P45"
B/ How to map (ID="p60_taxcode") to relevant tax year?
(eg "1185L" should map to "2018/19" etc)
eg p60_taxcode = "1185L" etc is initialized but corresponding tax year (ie "2018/19") is not
So need to map relevant tax year to p60_taxcode
See: map-tax-year-to-taxcode
5/ FIX: HTML/Javascript issue on form (/[login to view URL]). Not working
see: JS-HMTL-not-working
Already coded but stopped Javascript features stopped working few years ago.
Should require little work
6/ REMOVE funny symbol (want £ instead) & garbage from form & homepage
See:
remove-symbol-formpage
remove-garbage
7/ FIX: After payment (Paypal is processor), should re-direct to 'Thank you. Order confirmed' page
Already coded
Currently, after payment, redirects back to 'Payment Options' page so customer unsure if payment successful or not
8/ REMOVE pre-populated text from field in auto-email (submitted details) to: Admin, /print-order, Customer
See: remove-pre-populated-text-in-submitted-details
New code required.
Applies for auto-email to:
- Admin
- Customer
- /[login to view URL]
Currently, pre-populated text is include in field of submitted details when customer made no input.
Submitted details should include only customer input. If no customer input, field is empty
Project ID: #21827083
About the project
11 freelancers are bidding on average $105 for this job
ok we will fix the fb issues first and 50$ is fine for me but u need 55$ than i will get 50$, i am oscommerce expert and all issues will be fixed today as i am ready to start work from now