Contact person: Checkout Enhancements & CRM 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 and a custom checkout page. By Tuesday 9/30 I need four concrete updates:

• 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.

• Eight customer-data fields that are already captured in the Orders table must also live in the Sales Leads table. Please handle the MySQL ALTERs and make sure existing rows are back-filled without data loss.

• Both Orders and Sales Leads need a new calculated 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.

• 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.

Deliverables will be:
1. Updated checkout template with working radio buttons.
2. SQL scripts and PHP patch that add the eight fields plus the calculated column in both tables.
3. API integration code (with clear endpoints, headers and field mapping) and a brief read-me.
4. Change log so I can re-apply these modifications on staging.

Please keep the code modular—[login to view URL] or a small custom plugin is preferred—so future theme updates don’t overwrite anything. Let me know your estimated turnaround; the closer to Monday the better." (client-provided description)