WordPress & WooCommerce Developer Website Optmztion+Updates+Fixes, PHP 8.3 Upgrd & Cstm Ordr Mngmnt

Expert - Est. Budget: $1,000 We are looking for WordPress/WooCommerce developer to work on an established WooCommerce website with approximately 3,000 products. Video Explaining what we need here: https://vimeo.com/1224756014/80bf9be1ee?share=copy&fl=sv&fe=ci [copy and paste video in your browser to watch] and summary below: We need someone experienced with WooCommerce internals, HPOS, PHP, JavaScript/AJAX, database optimization, plugin conflicts, FunnelKit, checkout customization and performance optimization. You will get access to cloudway's server account, sftp info, and backend admin info of staging site. I don't want you to outsource this to someone else or to the plugin's developer. You figure it out on your own. All development will be completed and tested on our staging website first[certain things there are an exception, those changes we will do at the end]. Changes should not be made directly to production without testing. Main Scope of Work 1. Database Cleanup & Optimization Audit the WordPress/WooCommerce database and identify: Old plugin tables Orphaned data Unnecessary database records Database bloat Unused plugin data Remove unnecessary data safely without affecting active plugins or functionality and optimize the database afterward. 2. Fix WooCommerce Barcode Scanner Our barcode scanner plugin currently does not work correctly. Determine whether the issue is caused by: Plugin conflicts Theme conflicts JavaScript WooCommerce HPOS Other compatibility problems Fix the underlying issue and confirm the scanner works reliably. 3. Move WooCommerce Emails from Kadence to FunnelKit Our WooCommerce transactional emails currently use Kadence Email Customizer. We want the existing designs recreated in FunnelKit and Kadence removed afterward.

Requirements include: Processing emails Completed emails Other transactional emails Preserve shipping/tracking information Remove unnecessary FunnelKit promotional sections Enable Post SMTP logging Test email delivery 4. Upgrade PHP 7.4 to PHP 8.3 The website currently fails when PHP is upgraded. You will need to: Upgrade staging to PHP 8.3 Identify incompatible plugins/theme/custom code Fix compatibility problems Confirm the entire WooCommerce site works properly under PHP 8.3 5. Tracking Script Optimization Review Google Analytics, Microsoft Clarity and Meta/Facebook Pixel implementation. Investigate whether Cloudflare can handle/deliver some of this functionality more efficiently and reduce frontend performance impact. 6. Custom WooCommerce Order Management System We currently have separate systems/plugins for: Payment Status Repair Status Dropship Status We want these consolidated into one maintainable HPOS-compatible system/plugin. The WooCommerce Orders screen should display status groups and the number of orders assigned to each status. Example: Card Captured (6) Statuses with the largest number of orders should automatically appear first. The interface also needs to remain clean when there are 20–30+ statuses. New statuses created in the future should automatically appear without requiring additional programming. 7. FunnelKit Automation Integration Our custom statuses must integrate with FunnelKit Automations. Example: Payment Status → Card Captured → Trigger FunnelKit Automation → Send Customer Email New statuses created through our system should automatically be available for automation rather than requiring custom development for every new status. 8. "Who's Responsible" System Create another customizable order field/status system called: Who's Responsible We need to be able to: Create unlimited options Assign them to orders Rearrange/manage them Display them within WooCommerce Use changes as FunnelKit automation triggers 9. Independent Analytics Audit Review the Independent Analytics plugin for: Database usage Stored records Scheduled tasks Query load Database growth Performance impact We want to determine whether keeping analytics inside WordPress is negatively affecting site performance. 10. Track Your Order Page Make CSS/UI improvements to our Track Your Order page. Detailed design requirements will be provided. 11. ShortPixel / AVIF / WebP ShortPixel has generated optimized images, but they do not appear to be served correctly. Audit and fix: AVIF delivery WebP delivery Browser fallback ShortPixel configuration Image performance AVIF is preferred where appropriate. 12. WP-Content / Storage Cleanup The site currently consumes approximately 32 GB. Investigate: Backups Duplicate images WordPress thumbnails ShortPixel-generated images Plugin files Logs Cache Temporary files Other unnecessary storage Nothing should be bulk deleted without first determining what created it and whether it is safe to remove. 13. Website & Checkout Performance Performance is a major priority. The checkout sometimes visually loads but remains blocked/grey while background requests continue running. Investigate: Network requests AJAX JavaScript Database queries WooCommerce requests FunnelKit Tracking scripts Plugin conflicts Delayed/deferred scripts Background requests We care more about real-world responsiveness than simply achieving a high PageSpeed score. 14. FunnelKit Upsell/Funnel Conflict A FunnelKit upsell/funnel is not working correctly on staging. There may be a conflict with our wishlist plugin. Find the actual cause and make sure FunnelKit and the wishlist can operate together. 15. Wishlist Improvements Adjust the location and design of the wishlist functionality on product/category pages. It must work properly on desktop and mobile. 16. Product Reviews & Q&A Improve the product page so it displays: 54 ★★★★★ The review count should appear before the stars and be black/bold. We also want: Q&A section Ask a Question button Q&A → Reviews → Related Products layout Anchor links that scroll directly to Q&A or reviews 17. Google Address Autocomplete Fix and optimize our Google Maps/address autocomplete integration. Current issues include: Slow loading UI problems Keyboard navigation problems 18. Shopify-Style Checkout Flow Improve our WooCommerce/FunnelKit checkout so the flow is closer to Shopify: Email first Clean shipping-address section Logical country/address positioning Better field organization Mobile-friendly layout We are looking for the usability/flow of Shopify, not necessarily an exact visual clone. 19. Checkout Keyboard Navigation Users must be able to navigate checkout naturally using the keyboard: Email → Tab → Name → Tab → Address → Tab → Next Field Google autocomplete currently interferes with Tab navigation and can trap focus or select incorrect values. This needs to be fixed. ================= Workflow: Staging → Develop → Test → Verify → Document → Production For each major change, we need either a short video or written documentation showing what was changed and how it can be transferred to production. I am comfortable with injecting files, SFTP, and ssh, copy and pasting directorys and unzipping/zipping files. I am aware on how servers/websites/woocommerce/wordpress works. We are comfortable using SFTP, SSH and editing/uploading PHP files ourselves, so clear deployment instructions are acceptable. Testing should be performed with the plugins that will actually be active on production. Developer

Requirements WooCommerce WooCommerce HPOS PHP 8.x Custom WordPress plugin development WordPress database optimization MySQL/MariaDB JavaScript/AJAX FunnelKit / FunnelKit Automations WooCommerce checkout customization Plugin conflict debugging Performance optimization Cloudflare AVIF/WebP/ShortPixel Responsive frontend development ========================================== ## Video Walkthrough — Please Watch Before Applying I recorded a complete walkthrough of the staging website showing the current problems and the changes required. ++++++++++++++++++++++++ ======================== **Full Video:** https://vimeo.com/1224756014/80bf9be1ee ### Clickable Video Timestamps ## Video Walkthrough — Please Watch Before Applying I recorded a complete walkthrough demonstrating the current website issues and the changes required. **Full Video:** https://vimeo.com/1224756014/80bf9be1ee ### Video Timestamps **▶ 00:00 – Project Overview & Staging Workflow** https://vimeo.com/1224756014/80bf9be1ee#t=0m00s Overview of the project and staging environment. **▶ 00:59 – Database Cleanup & Optimization** https://vimeo.com/1224756014/80bf9be1ee#t=0m59s Remove old plugin tables, orphaned data and unnecessary database bloat safely. **▶ 01:50 – Barcode Scanner Plugin Issue** https://vimeo.com/1224756014/80bf9be1ee#t=1m50s Diagnose and fix the barcode scanner, including possible plugin/theme conflicts. **▶ 03:20 – Move Kadence Emails → FunnelKit** https://vimeo.com/1224756014/80bf9be1ee#t=3m20s Recreate WooCommerce transactional emails in FunnelKit, preserve tracking information and test delivery. **▶ 05:10 – PHP 7.4 → PHP 8.3 Upgrade** https://vimeo.com/1224756014/80bf9be1ee#t=5m10s Upgrade staging to PHP 8.3 and fix the compatibility issue currently preventing the website from loading. **▶ 05:32 – Analytics / Clarity / Meta Pixel & Cloudflare** https://vimeo.com/1224756014/80bf9be1ee#t=5m32s Review tracking scripts and investigate reducing their frontend performance impact through Cloudflare. **▶ 05:58 – Custom WooCommerce Order Status System** https://vimeo.com/1224756014/80bf9be1ee#t=5m58s Consolidate Payment Status, Repair Status and Dropship Status into one HPOS-compatible system. **▶ 06:39 – Custom Status Counts & WooCommerce Orders UI** https://vimeo.com/1224756014/80bf9be1ee#t=6m39s Add live order counts, automatic sorting and a clean UI capable of handling 20–30+ statuses. **▶ 08:48 – FunnelKit Automation Integration** https://vimeo.com/1224756014/80bf9be1ee#t=8m48s Allow custom statuses and newly created statuses to trigger FunnelKit Automations. **▶ 09:29 – "Who's Responsible" System** https://vimeo.com/1224756014/80bf9be1ee#t=9m29s Create a customizable order field with unlimited options and FunnelKit automation integration. **▶ 10:27 – Independent Analytics Performance Audit** https://vimeo.com/1224756014/80bf9be1ee#t=10m27s Review database usage, scheduled tasks, queries, database growth and performance impact. **▶ 11:28 – Track Your Order Page** https://vimeo.com/1224756014/80bf9be1ee#t=11m28s CSS/UI and text improvements to the order-tracking page. **▶ 11:52 – ShortPixel / AVIF / WebP Optimization** https://vimeo.com/1224756014/80bf9be1ee#t=11m52s Fix next-generation image delivery and ensure optimized formats are actually being served. **▶ 12:50 – Investigate ~32 GB WP-Content Size** https://vimeo.com/1224756014/80bf9be1ee#t=12m50s Investigate backups, duplicate/generated images, thumbnails, plugin files, logs and other unnecessary storage. **▶ 14:24 – Overall Website & Checkout Performance** https://vimeo.com/1224756014/80bf9be1ee#t=14m24s Investigate background requests and improve real-world site, cart and checkout responsiveness. **▶ 15:22 – Cart/Wishlist Performance Demonstration** https://vimeo.com/1224756014/80bf9be1ee#t=15m22s Demonstration of slow loading, grey/loading states and delayed frontend behavior. **▶ 16:20 – FunnelKit Upsell / Plugin Conflict** https://vimeo.com/1224756014/80bf9be1ee#t=16m20s Diagnose missing/slow FunnelKit upsells and determine whether another plugin is causing the problem. **▶ 17:43 – Live Site Performance Comparison** https://vimeo.com/1224756014/80bf9be1ee#t=17m43s Comparison against the live website and demonstration of checkout/upsell behavior. **▶ 18:15 – Possible Wishlist ↔ FunnelKit Conflict** https://vimeo.com/1224756014/80bf9be1ee#t=18m15s Demonstration of the suspected wishlist/FunnelKit conflict and delayed checkout elements. **▶ 19:39 – Wishlist Redesign** https://vimeo.com/1224756014/80bf9be1ee#t=19m39s Move and redesign wishlist functionality and ensure it works properly on desktop and mobile. **▶ 20:50 – Product Reviews & Q&A Redesign** https://vimeo.com/1224756014/80bf9be1ee#t=20m50s Add review counts, Q&A/Ask a Question functionality and anchor navigation. **▶ 22:29 – Google Address Autocomplete Problems** https://vimeo.com/1224756014/80bf9be1ee#t=22m29s Fix Google address autocomplete loading, UI and keyboard-navigation problems. **▶ 23:27 – Shopify-Style Checkout Layout** https://vimeo.com/1224756014/80bf9be1ee#t=23m27s Reorganize the WooCommerce/FunnelKit checkout into a cleaner Shopify-style flow. **▶ 24:41 – Checkout Tab / Keyboard Navigation** https://vimeo.com/1224756014/80bf9be1ee#t=24m41s Allow natural Tab navigation through checkout without Google autocomplete trapping focus. **▶ 25:28 – Plugins Required During Testing** https://vimeo.com/1224756014/80bf9be1ee#t=25m28s Testing should be performed with the plugins that will actually be running on production. **▶ 26:09 – Required Plugins Identified** https://vimeo.com/1224756014/80bf9be1ee#t=26m09s Ultimate Raffle, UpdraftPlus and Tawk.to should be active during testing. ## Important