I have a fairly large wordpress/woocommerce site (many thousands of products), but the database has never been optimized and is showing some errors in the logs with some of the plugins = some of which will need updating. But main task is database optimization first..
You can't just open phpmyadmin to do this, you will need to backup the db.
download the db.
then upload, and apply new database.
This is the first task milestone. The db is currently 4.5gb in size.
The second task is to update wordpress, woocommerce and ALL the current plugins that are activated. This is the second task, to update all outdated plugins, but ALL existing site functionality must still work on the site. ESPECIALLY the plugins to push items to ebay, this CANNOT break.
The third milestone is to remove these plugins which are not activated without breaking anything, but by removing them completely -
adminer inactive none 1.3.0
ari-adminer inactive available 1.1.5
color-and-image-swatches-for-variable-product-attributes inactive available 1.2.7
Color-and-image-swatches-pro-for-woocoomerce inactive none 2.1
file-manager inactive available 5.0.2
sg-cachepress inactive available 5.0.13
storefy-demo inactive none 1.0.2
tshirtecommerce inactive none 4.2.1
wordpress-importer inactive available 0.6.3
wp-file-manager inactive available 2.4
wpide inactive none 2.4.0
but you must make sure that the image/colour selection changing on product pages works correctly still, example working here -
[login to view URL]
you can click the thumbnails to view different colours, but you can also choose size, then colour from the dropdowns and the picture changes as well.
The last task is to check the phperror logs and fix any issues that may be occuring that are slowing down the site from logging in, uploading new products or just browsing the site.
the logs have entires like these -
[04-Apr-2019 18:54:13 UTC] PHP Warning: reset() expects parameter 1 to be array, string given in /home/ramgfx05/public_html/wp-content/plugins/gdpr/public/partials/[login to view URL] on line 32
[04-Apr-2019 18:54:13 UTC] PHP Warning: key() expects parameter 1 to be array, string given in /home/ramgfx05/public_html/wp-content/plugins/gdpr/public/partials/[login to view URL] on line 33
[04-Apr-2019 18:54:13 UTC] PHP Warning: Invalid argument supplied for foreach() in /home/ramgfx05/public_html/wp-content/plugins/gdpr/public/partials/[login to view URL] on line 36
There are also errors when you go into woocommerce and click to duplicate a product, this is the last milestone to stop errors when copying or duplicating products in woocommerce that is causing the site to hang -
04-Apr-2019 18:30:32 UTC] WordPress database error Lost connection to MySQL server during query for query DELETE FROM cst_options WHERE option_name LIKE '\\_transient\\_%1554402629' ORDER BY option_id LIMIT 1000; made by require_once('wp-admin/[login to view URL]'), do_action('admin_action_duplicate_product'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, WC_Admin_Duplicate_Product->duplicate_product_action, WC_Admin_Duplicate_Product->product_duplicate, WC_Product->save, WC_Data_Store->create, WC_Product_Variation_Data_Store_CPT->create, WC_Product_Data_Store_CPT->clear_caches, wc_delete_product_transients, wc_delete_product_transients, WC_Cache_Helper::get_transient_version, WC_Cache_Helper::delete_version_transients
to recap, milestones are -
1. optimize database
2. update wordpress, woocommerce and all current plugings - no loss in functionality.
3. remove inactive/unused plugings
4. check php error logs for errors and resolve them to speed up admin login, woocommerce product duplication and copy functions which are causing the site to crash.
34 freelance font une offre moyenne de £511 pour ce travail
Hello, I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. Our team can help you with woocommerce site and database, update wordpress, woocommerce and Plus
Hi there, I have gone through your project detail and I have the Exact Match skills as per the current project you are looking now. Also take pride of our 5.0/5.0 Rating-Profile with 600+ Nice-Reviews with 99% Co Plus
Dear Client, Nice to meet you in freelancer,Hope you feeling awesome on the blessing of God.I read your job description the requirement is inline of my skills.I am assisting to deliver the 100% quality of work withi Plus
Greetings! My name is Neha. We would love to have the opportunity to discuss your project with you. We are in the top 4% of freelancers based on our earnings and reviews. We specialize in: Plugin MySQL Woo-Comm Plus
Hello There. I will do all mentioned milestones for your website, and optimize the website for better performance. Specific to WooCommerce, I have maintained websites with 30,000 - 70,000 products which has minut Plus
Hi Peter, This is pardusIT from Turkey. I have worked for you several times regarding to server projects. I do would like to work on this project to optimize and speed up your server. As mentioned in lancer messaging Plus
Hey, I am Salman and I will be quite delighted to assist you with your website project. I am sure before you talk any further, you would like to see my work first. [login to view URL] [login to view URL] htt Plus
Hello, I am interested in working for you. I gone through your requirements and provide you professional quality work. Thanks Raj
Hello, I've read your project description and I want to tell you that I can create wordpress woo commerce database optimization for you as per your requirements with complete mobile responsive design. Lets have a qu Plus
I can help you to setup or modify e-commerce site for your products, and also make customizations as per your needs And i will add several payment methods for your customer if you have specific in mind than lmk i wil Plus
Hi there, I've gone through the post description carefully and ready to start work on this project. Requirements are very clear but please come over the chat so that i can get more requirements if remaining. I am Plus
HI, first of all, I would say you have described the project very clearly and all of them are understandable. only question which i have is about only " image/colour selection" part. can you please recap it for me ? Plus
We are wordpress, woocommerce expert team...... We are ready for the following tasks,...... 1. optimize database 2. update wordpress, woocommerce and all current plugings - no loss in functionality. 3. remove Plus
Hi, I am specoalizing on big sites. Lets discuss your project. My programming experience is 9 years. I did projects both in the development team and alone. I am pleased to perform work of any complexity and type. Be Plus
PHP/C# .NET/JS/CSS/HTML Expert. Freelance developer from Argentina, more than 10 years of experience on web development. Wordpress, Magento, Drupal, Joomla, Prestashop, Woocommerce, CMS Sitefinity, ZNode storefront, e Plus
Hello, I am a well experienced wordpress and woocommerce developer.I am extremely carefully read through your job description. I know well how to update all of these things using your db. I already solve this type o Plus
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Plus
Hello! I have read your proposal and understood what you want. I'm a professional in word press/Woo-commerce. I'm a specialist in Woo-commerce/Word press. I have more than 8 years experience in word press. I'm waiting Plus