OScommerce expert to fix DB errors, HTML/Javascript, Automated email to Admin+Customer (POP3 issue) & other issues

Closed Posted 4 years ago Paid on delivery
Closed 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

PHP MySQL OSCommerce JavaScript HTML

Project ID: #21827083

About the project

11 proposals Remote project Active 4 years ago

11 freelancers are bidding on average $105 for this job

rexzetsolutions

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

$55 USD in 1 day
(352 Reviews)
7.5
vikasp007

I've 7+ years of experience in Web Development/Web design, Mobile App Development(IOS/Android), Graphic design, Logo Design Business Cards & Stationery, Flyers & Brochures, Packaging Design, Web & Mobile Design, Social More

$140 USD in 7 days
(2 Reviews)
2.4
gzvirid

Hi there, My name is George. I have advanced experience with Google cloud solutions, like BigQuery, DataFlow, Storage. Apache Spark, Apache Kafka, various NLP techniques, pandas, NLTK, numpy, developing and using ML m More

$140 USD in 7 days
(0 Reviews)
0.0