Find Jobs
Hire Freelancers

Resolve WooCommerce performance / plugin conflicts / MySQL query issues

$30-250 USD

In Progress
Posted about 5 years ago

$30-250 USD

Paid on delivery
Hi guys! I need a VERY skilled provider who can sufficiently diagnose, repair, and improve the performance of a new (soon to be launched) WooCommerce website. The successful provider must be able to diagnose issues and resolve problems with SQL queries (remove duplicate queries, reduce requests, etc), locate/fix plugin conflicts, and (ideally) be able to adjust MySQL server config settings. Some PHP/JavaScript customization could be needed if plugin conflicts exist. The main issue we're experiencing is when customers add products to the cart. If they are not logged in (shopping as guest), the performance is "okay" (not great, but "okay"). However, when a visitor logs in, the cart gets VERY slow. For example, adding a single product may take anywhere from 15 to 25 seconds, and the more products that are added to the cart, the longer it takes to add/edit/view/checkout (I've witnessed add to cart times as high as 45 to 50 seconds. Yikes!). My client uses a variety of plugins from major vendors (Woo, YITH, etc.) -- mostly related to shopping cart rules (retail/wholesale, tier pricing, bulk discounts, etc.), and they offer FedEx, UPS, DHL and USPS as shipping methods. I believe the shipping calculations are something to look at too because the performance somewhat improves when the shipping plugins are disabled (especially FedEx). This certainly doesn't solve the problem, but it does reduce the add to cart time to around 8 to 12 seconds. We've tried many different plugins that integrate with those major shipping providers -- and performance issues exist with all of them, so my best guess is there are duplicate queries and perhaps plugin conflicts somewhere else in the platform. Your job will be to inspect the website code, analyze queries, isolate the functions (and plugins) which are causing the issues, repair (or rewrite) these functions as needed, and resolve most (or all) of the major MySQL query bottlenecks. Being able to properly optimize MySQL server is a big plus. - This website is hosted on a dedicated server. - This project needs to be completed in a timely manner. - Low reviews / negative reviews / etc. will not be considered. - I can provide more information as needed. Just ask! Thanks!
Project ID: 18729997

About the project

20 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hire me. WordPress is resource intensive. I know how to handle it. I'll make your website load blazing fast & under 2 seconds. Besides, I'll optimize the MySQL server for faster query & low latency. And, the less plugin you use, the faster WordPress will perform. I'm a WordPress & WooCommerce Expert, Server & Linux System Admin, AWS & Microsoft Azure Cloud Expert, Email Server & DNS Expert, Web Security Analyst & Website Performance Optimizer, Web Designer.
$100 USD in 1 day
4.8 (57 reviews)
4.8
4.8
20 freelancers are bidding on average $246 USD for this job
User Avatar
Hi, I can examine your site and find and fix the bottleneck. Please check my ratings and feedbacks to see the proof of my experience and expertise in Wordpress. There are more than 150 of excellent reviews rated 5 out of 5 with 99% completion rate, that is rare case when all employers were fully satisfied! That means I always seek for perfection, please compare to other freelancers with their average rating of 4.8/4.9 and ~80% completion rate. I have successfully completed hundreds of different WP projects starting from minor theme or content updates to huge and complex WP plugin development and dozens of external API integration tasks. I have 11 years experience in Web Development, 6 years with Wordpress. Comparing to other freelancers who are often spamming with their bids I am actually reading your project description and bid with precision only on projects I like. I am located in Latvia, North Europe and I work mostly with employers located in Europe and North America.
$333 USD in 5 days
5.0 (164 reviews)
7.4
7.4
User Avatar
*** Already helped a woocommerce store with similar issues *** among top 5% freelancers on this site - I will ask a of questions if and when you get in touch - Codinglogics
$155 USD in 3 days
4.9 (511 reviews)
7.6
7.6
User Avatar
Hi there How are you I am a woocommerce expert and I am sure I can solve issue pease contact me and discus more about project . thanks
$155 USD in 3 days
4.9 (233 reviews)
7.2
7.2
User Avatar
Hey I am interested in this project. and Would like to take a look at your site and wanted to do some debugging before taking this project. I will only ask for awarding project once I will be sure that I am able to resolve the issues. Do consider my bid for this project. Thank you Waiting for your response.
$500 USD in 4 days
5.0 (60 reviews)
6.3
6.3
User Avatar
Hi I am understand you have a woocommerce website ona dedicated server and it was running very slow specially when add products to the cart for a logged in user yes i can optimize wordpress, woocommerce, remove plugin conflicts and make it run fast and without any issue, also i can optimize MYSQL queries and deliver you a perfect online store. Lets discuss more in chat.
$467 USD in 3 days
4.9 (141 reviews)
6.3
6.3
User Avatar
Hello.! I have more than 10 years experience in HTML, CSS, JS, jQuery, PHP, Laravel, MySQL. I'm 100% sure you are satisfied with my work. I'm a professional in freelancer. We can discuss in details over chat. thak you Saif
$250 USD in 3 days
4.9 (79 reviews)
6.0
6.0
User Avatar
Hello, As per the requirement you are looking for the following: - Speedup the site cart (Resolve JS) - Optimize the site I not only offer effective bug resolving services, but also better solutions to permanently get rid of this problem. End-to-end bug resolving services offered by me ensure a smooth functioning of an e-commerce store. I am competent and have effective solutions for any kind of technical impediments in an online store. Bug resolving services offered include: -Bug fixing in modules, extensions and plugins -WordPress site speed issue -Correcting the source codes and PHP scripts -Correction of technical issues in both front-end and back-end -WordPress themes and templates rectification -Bug fixing is WordPress shopping cart applications -Protection of WordPress site from SQL injections -WordPress admin login problem solving A bug-free online store offers customers a seamless shopping experience and I make it possible for the clients to offer its customers the experience which is highly effective bug fixing services. As a PHP developer, I have deep knowledge of: PHP (CMS: WordPress, Joomla etc and Frameworks), CSS3, HTML5, jquery, BootStrap, JavaScript, Ajax, MySQL, AJAX, Responsive Page Design, Custom module development, Theme design, 3rd party integrations: Calendars, Gateways etc. Please initiate chat soon so that we can discuss the project in more details. Looking forward to a positive response. Regards, Ishika G.
$250 USD in 8 days
4.8 (17 reviews)
5.3
5.3
User Avatar
Hi There, Hope this finds you in great health and spirits. Can you please share the URL of your Woo-commerce store. That way we can play around with ourselves and see what issues are in there. I think the site needs to be optimized in terms of its loading speed, as that will take care of the bulk of the issues. Please initiate the PM so we can discuss further in details. Thanks, Kumar
$222 USD in 3 days
5.0 (7 reviews)
5.0
5.0
User Avatar
Hi sir hope your e well i have read about your project i can fix the issues your facing instantly,i am new to the platform and seeking for good reviews choose me and i can assure you that you'll be satisfied. Regards: Xtratech Solutions
$100 USD in 1 day
4.9 (6 reviews)
3.1
3.1

About the client

Flag of UNITED STATES
Stillwater, United States
5.0
44
Payment method verified
Member since Jan 17, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.