Error correction
89 USD 1. Fix the visibility of the payment and delivery categories
2. The PrestaShop profiler shows 1,454 database queries just on the homepage. The tvcmsblogdisplayposts module generates 314 queries and takes 120 ms — this is one module from the sidebar. tvcmsproductpopup takes another 19.8 ms. Google Crawl Budget is spent on slow pages — the bot leaves without waiting for the render.
→ Optimize tvcmsblogdisplayposts in the column. Enable PrestaShop SQL cache. Add Redis/Memcached.
3. Server TTFB is 367 ms — only PHP. Browser LCP (considering JS, images, fonts) will be 3–6 s. Google ranks pages with Core Web Vitals: LCP <2.5 s — good, >4 s — bad. The v1_electron_1 theme connects 48 modules with each request.
→ Enable Smarty Cache + minification of JS/CSS in PS settings. Connect a free CDN (CloudFlare).
4.
The server is running on MySQL 5.7.44. This version is EOL (end of life). PrestaShop 9 is optimized for MySQL 8.0 / MariaDB 10.6+. New query optimizer features — window functions, improved JSON — provide a 20–40% boost on complex queries.
→ Migrate to MySQL 8.0 or MariaDB 10.11.
5.
The site has Ukrainian (/) and Russian (/ru/) versions with identical content. Without correct hreflang, Google perceives them as duplicates and lowers both versions. No hreflang tags were found in the HTML.
→ Add hreflang="uk" and hreflang="ru" (or close /ru/ via noindex if the audience is only Ukrainian).
6.
Set up cache7.
All links to blog articles in the page code use http://abud.com.ua/blog/... instead of https://. If the server redirects — this is an extra request and loss of PageRank. If it does not — mixed content and browser warning. Google prefers HTTPS.
→ Fix the base URL of the blog in the tvcmsblog module settings. All internal links should be https://.
8.
Search site:abud.com.ua shows less than 10–15 results. With a catalog of 130+ categories and hundreds of products, this is catastrophically low. Reasons: slow speed (the bot does not keep up) + possible issues with robots.txt/sitemap.
→ Check Google Search Console: Coverage → Excluded. Ensure that sitemap.xml is submitted and contains all URLs.
9.
No Product, BreadcrumbList, Organization markup was found on product and category pages. Schema.org markup provides rich snippets in Google (rating, price, availability) — increases CTR by 15–30%.
→ Add JSON-LD manually.
-
1 day67 USD
1 day67 USD
Hello! I am ready to take on your project and will complete it urgently. I have extensive experience with similar tasks, so there will be no difficulties. If I have piqued your interest, feel free to write; I am happy to collaborate!
-
10 days401 USD
10 days401 USD
I quickly reviewed the public part of abud.com.ua: sitemap.xml currently returns a 404, and the response shows no-store/no-cache and MISS/NO-CACHE, so I would start with indexing, caching PrestaShop, and the modules that force the site to regenerate heavy pages for users and Googlebot.
Is it not the case that due to the v1_electron_1 theme and the tvcmsblogdisplayposts module, PrestaShop executes hundreds of unnecessary SQL queries each time, causing Googlebot to crawl the catalog poorly, while customers experience slow store performance?
The budget and timeline will be discussed in personal correspondence after reviewing the PrestaShop admin panel, profiler, hosting, MySQL version, tvcmsblog/tvcmsproductpopup modules, cache, sitemap, hreflang, internal http links, and Google Search Console.
Similar completed project: В модулі OpenCart виправити 5 проблем повязаних з Facebook API
-
5 days78 USD
5 days78 USD
Hello! 👋
I have reviewed your description and see clear bottlenecks: a large number of SQL queries on the homepage (tvcmsblogdisplayposts), lack of SQL caching and Redis/Memcached, disabled Smarty caching and minification, HTTPS issues in blog links, missing hreflang and JSON-LD, as well as an outdated version of MySQL. This affects TTFB, LCP, and Google indexing.
I have relevant experience in optimizing PrestaShop (analyzing profilers, optimizing modules, configuring SQL caching, Redis/Memcached, Smarty, minification, connecting CloudFlare), technical SEO (hreflang, sitemap, mixed content), and database migrations to MySQL 8 / MariaDB. I can quickly conduct an audit, prioritize fixing bottlenecks, and restore stable fast rendering and better indexing.
Feel free to reach out.
🌐 Portfolio with recent cases:
… https://mrnko.com
💼 Freelancehunt profile:
Freelancehunt
🤝 I would be happy to discuss project details, answer your questions, and offer the best solution to achieve the desired result.
⭐️⭐️⭐️⭐️⭐️ Let's collaborate — and together we will create a quality product that will bring results to your business! 🚀✨ I am ready to start working very soon.
-
1 day67 USD
477 1 day67 USD
Good day!
I am ready to take on the task related to PrestaShop. From the list, I see not just minor adjustments, but a comprehensive optimization of speed, SEO, and the technical condition of the site.
I can perform:
• corrections to the visibility of the "Payment" and "Delivery" categories;
• analysis and optimization of problematic modules tvcmsblogdisplayposts / tvcmsproductpopup;
• configuration of PrestaShop cache, Smarty, CSS/JS minify;
• connection of Redis/Memcached if access to the server is available;
… • correction of blog http links to https;
• checking robots.txt, sitemap.xml, and indexing;
• adding hreflang for UA/RU versions;
• adding JSON-LD Schema.org for products, categories, breadcrumbs, and organization;
• recommendations or support for migrating MySQL 5.7 to MySQL 8 / MariaDB.
I would start with an audit of the current state, a backup, and phased corrections to avoid breaking the store's operation. After gaining access to the admin panel, FTP/SSH, and hosting, I will be able to assess the exact scope, timeline, and cost.
I am ready to discuss the details and get started.
-
7 days334 USD
95572 1271 1 10 7 days334 USD
Hello. I have extensive experience in website optimization. I am ready to collaborate. Please contact me.
-
2 days45 USD
212 2 days45 USD
Good day, Oleg! I am interested in the project and ready to take it on. I have experience with similar tasks, I work efficiently and on time.
-
3 days45 USD
452 3 days45 USD
Good day, Oleg!
The scope is large; in fact, it involves several separate areas of work. For the specified budget (2000 UAH), I suggest starting with the points that provide quick and noticeable results:
— P.1: fix the visibility of the payment/delivery categories
— P.5: add hreflang="uk"/"ru" for correct indexing of the two versions of the site
— P.6: configure Smarty Cache
— P.7: fix http to https links in the blog (mixed content)
These are specific, controllable edits with no risk to production - we will do it quickly and without unnecessary complications.
Deadline: 2-3 days, cost: 2000 UAH.
The remaining points (MySQL migration, Redis/Memcached, Schema.org markup, CDN) are more extensive tasks that should be done as a separate phase after you see the results of the first block.
… I have experience with PHP/MySQL backend, server optimization, and SEO technical edits; the approach to each point will be careful, with minimal risk to the store's operation.
Current freelance projects in the category HTML & CSS
Development of a Minecraft Java Seed Map / Seed Viewer for the websiteDevelopment of Minecraft Java Seed Map / Seed Viewer for the websiteProject Description A browser-based tool Minecraft Java Seed Map / Seed Viewer needs to be developed, which will work on our website and allow the user to enter a seed from Minecraft Java Edition and view an… C & C++, HTML & CSS ∙ 44 minutes back ∙ 6 proposals |
WordPress site optimization: mobile version performance + video quality correctionAbout the project: Website on WordPress — anzeymedia.com. We need a specialist in optimization (WordPress performance / front-end) who will achieve measurable results, not just "install plugins". Task 1 — Mobile version performance Currently, the Google PageSpeed Insights score… HTML & CSS, Website Maintenance ∙ 3 hours 59 minutes back ∙ 23 proposals |
Transfer of a small business card website with 58 pages from Joomla 1.5 to Joomla 6There is a small business card website made on Joomla 1.5 with 58 pages (if counted in two languages), which contains small texts with photos. One page has a table. Two pages have PDF files that take up the entire page in a frame. The site is made in two languages with a… Content Management Systems, HTML & CSS ∙ 8 hours 20 minutes back ∙ 29 proposals |
Redesign and relaunch of the Brovchak Family Dental Care clinic websiteRedesign and Relaunch of the Brovchak Family Dental Care Website http://brovchak-clinic.com.ua/ terms of reference from SEO expert https://docs.google.com/spreadsheets/d/17_WyPf3XVpzbuBjpJ7MNFs12QUL-aHv7iIbKudY-IEw/edit?gid=0#gid=0 https://miro.com/app/board/uXjVHXxFvIE=/About… HTML & CSS, Search Engine Optimization (SEO) ∙ 2 days back ∙ 62 proposals |
I want to learn how to create websites for CS:GO/CS2I need a mentor who will teach me how to create a CS2/CS:GO server. I want to go through step by step via Discord/Zoom: hosting/VPS, server.cfg, maps, plugins, admin panel, ban system, Discord, website, and statistics. Language: Ukrainian or Russian. HTML & CSS, Web Programming ∙ 2 days 2 hours back ∙ 16 proposals |
Kyiv