Оптимизация таблиц данных и картинок Wordpress

We are looking for support for a project based on Yii , we need to make edits and improvements to the database, there is partially a connection with the previous contractor .....................

A virus has currently infiltrated the website. The site is not functioning properly. In particular, the main page is not working correctly. We need a developer who can fix this error as soon as possible.

A developer is needed with experience specifically in CS-Cart Multivendor for two related modifications on an existing online store. Task 1 - broken product photos. On the pages of some products, they do not display. Some photos show a "broken" image icon. Self-diagnosis revealed two different types of causes: The original photo exists on the server, but a specific non-standard (non-square) size needed for full-screen viewing of the photo is not generated (this function is from the third-party module "AB: Advanced Image Viewers," AlexBranding). Square sizes of the same photos are generated without problems. The original photo is completely absent on the server - a specific example and link will be provided upon response. Task 2 - warming up the cache of new products. The site automatically parses and adds new products every night (a separate cron script). Page caching is already set up and working, the warming of the main page and categories has already been done - but the pages of the new products themselves are still not warmed up immediately after import, so the first real buyer who opens a new product directly experiences slow "cold" loading. It is necessary to add automatic warming (curl/wget for the list of new products) immediately after the completion of the nightly import. All necessary access will be provided to you after selection. Work format: two separate stages with separate or joint payment for each task. First, diagnostics/analysis with written confirmation of the approach for each task, then implementation. Respond if you have relevant experience with CS-Cart Multivendor - details and a test task will be provided in personal correspondence.

Main functionality Laravel 11/12 PHP 8.3+ MySQL Responsive design High performance SEO-friendly Admin panelCatalog categories brands products search filters sorting product pagesTecDoc Integration with the TecDoc module is required: VIN search car search TecDoc catalog analog selection specifications photos cross-references (Experience with TecDoc integration will be a significant advantage.)Personal account registration authorization order history wishlistCart order placement Nova Poshta delivery online payment promo codesSEO SEO-friendly URLs Meta Title Meta Description Schema.org XML Sitemap robots.txt Open GraphAdmin panel product management category management brand management order management user management SEO bannersIntegrations Telegram notifications Nova Poshta API payment system (LiqPay or WayForPay)Requirements clean code Git documented codeFrom the contractor, we need examples of websites on Laravel experience with TecDoc approximate timelines cost technology stack

1) Change the label for the amount for free shipping - from 2000 UAH 2) Increase the website speed (not inflated metrics) 3) Remove duplicates (when searching for a product, all variations and products that should not be displayed are shown) 4) Fix the filters (I will send screenshots) remove the bra size filter where it is not needed. Where it is needed, the sizes are incorrect 5) Create a full integration of WP with SalesDrive (currently only orders are coming, but products are without photos, sizes, and colors) 6) Create an xlsx file export with products from WP for the accounting program