Contact person: WordPress Site Customization & API Integration

Phone:Show

Email:Show

Location: San Anselmo, United States

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"I have a WordPress site running on PHP 8, MySQL ... a custom quote box, and checkout page. I need eight concrete updates done by October 1st and following that, a 9th task API Integration performed by October 3rd. Accomplish in this order:

Task 1
Add a SMS Quote Form Message into an online Quote Box. Just text. No coding.



Task 2

On the Quote Box Form, expand the number of multiple product options from the current five (5) to instead include ten (10).



Task 3

Eight customer-data fields that are already captured in database Table A must also live in Table B. Please handle the MySQL ALTERs and make sure existing rows are back-filled without data loss.



Task 4

Both Table A and Table B need a new calculation field column where c = a – b (the two source columns already exist). I want the subtraction handled directly in PHP on save as well as through an SQL trigger so the value stays in sync.



Task 5

Expand/change an existing field that holds six alpha-numeric digits to include nearly twenty alpha-numeric digits. Basically changing the field from last six digits of a VIN to instead include the Full VIN.



Task 6

If the visitor answers YES to any of four questions already established on an order form, add a simple number field to each. The new number fields need to be created in the order form and saved in database Table A.



Task 7

Add a fifth bullet option (numeric) to the checkout page. Four bullets already exist.



Task 8

On the checkout form, add two simple radio buttons labelled “Method A” and “Method B”. They only record the customer’s preference—no payment gateway handling or validation required. A JavaScript toggle is fine as long as the chosen value is stored in the database.



Task 9

Finally, co-ordinate an API push from our main company database to our CRM. You will map the new and existing fields, build or adjust the REST request in PHP/JSON, and confirm that entries created or updated in WordPress appear correctly in the CRM." (client-provided description)