Budget: 1800 UAH Deadline: 1 day
Good day, I have been developing and maintaining websites on OpenCart for more than 8 years. I have encountered, fixed, nothing new, I will perform quickly and qualitatively. Write to me, we will discuss.
Budget: 3000 UAH Deadline: 3 days
Hello! I have extensive experience in optimizing OpenCart. I understand the nature of error 524 (Timeout) — the server fails to respond in time, most often due to database hangs.
Judging by the description (multilingualism + blog), the problem is likely in heavy SQL queries (JOINs of translation tables) and the absence of indexes.
My approach to finding the causes:
I analyze the MySQL slow query log — this will show specific queries that "consume" CPU.
I analyze the Access log — to see which specific pages (filters, categories, blog) create load during bot visits.
Action plan:
Database: Adding missing indexes and optimizing queries (this will sharply reduce CPU usage).
Modules: Profiling installed blog and language modules, disabling unnecessary hooks.
Caching: Setting up server-side caching (or optimizing existing one) to serve static content to bots without querying the database.
Cloudflare: Setting up Page Rules for caching static content on the CDN side, so requests do not reach the hosting.
Budget: 8000 UAH Deadline: 7 days
Hello! I have thoroughly analyzed your logs and load graphs for jeansok.com.ua. The issue of exceeding CPU limits and encountering error 524 is quite solvable without losing functionality.
What I saw during the initial audit of your logs:
Aggressive scanning by AI bots. The logs record mass visits from Claude-SearchBot and Applebot. They access heavy pages with parameters (filters, tags, pagination), which causes a cascading load on the database.
Problematic requests Journal 3: I see a large number of POST requests to route=journal3/price. This is a common issue with this template; the dynamic recalculation of prices with each product view loads PHP processes and often becomes the cause of Cloudflare error 524.
Heavy multilingualism: The increase in load after adding the English version confirms that the indexes for the description and URL alias tables are not optimized in the database.
Budget: 1200 UAH Deadline: 2 days
Hello, I can complete this project quickly and efficiently, as I have experience in similar projects! We can discuss the details and do this in 2 days.
Budget: 2000 UAH Deadline: 3 days
Hello! I have reviewed the project and am ready to start working. I am sure you will be satisfied with the result.
Budget: 1000 UAH Deadline: 1 day
Let's move to another hosting. It will be possible to solve the problem for the price of a regular tariff. Write in private messages, I will tell you more details.
Budget: 2000 UAH Deadline: 1 day
The specific result will be on its own server. 5-6 euros per month. Stable and quality. Ukraine has long been out of the ranks of good hosts. I can implement everything from A to Z.
Budget: 2000 UAH Deadline: 1 day
Hello. The only reason for the load is the large number of requests to the site. The only way to combat this is database optimization + caching. Please reach out.
Budget: 3500 UAH Deadline: 2 days
Hello. I have extensive experience in speeding up websites. I am ready to collaborate.
Budget: 3000 UAH Deadline: 1 day
Hello
I optimize Opencart
Write in private messages
We will discuss the details
Budget: 3000 UAH Deadline: 2 days
I have practical experience in optimizing OpenCart under strict CPU limits of shared hosting and working with Cloudflare. In similar projects, I have brought stores from constant 524 errors and CPU overloads to stable operation within limits without losing SEO. In your case, I will analyze server logs and load graphs, identify specific points of CPU spikes (modules, SQL queries, blog, multilingualism, bots, slow backend responses), optimize OpenCart and the database, configure proper caching and Cloudflare for real traffic, eliminate the causes of Error 524, and bring the site to stable operation with CPU usage up to 100 minutes per day, so you can safely return to regular hosting at a reasonable, justified cost and with clear results.
Proposals concealed
Proposals are currently absent
Current freelance projects in the category Databases & SQL
It is necessary to export orders to the business management system from SalesDrive according to the relevant parameters, namely: organization, payment method,
About the project and tasks We have a small sales department (sales department head + 2 managers) and a database of about 220 active clients. There is an urgent need to implement a simple CRM as an operational level so that managers can record calls, agreements, and statuses in the sales funnel in real-time, while management can see which clients are "stuck" at a certain stage. At the same time, we actively use AI analytics (Claude) for working with exports, reports, anomaly detection, and P&L analysis. Therefore, the CRM is needed as a clean data source from which quality exports can be generated. What needs to be done (Stage 1 — Implementation) Audit and solution selection. Finally determine the platform together with us. We are considering Ukrainian solutions (KeyCRM or SalesDrive) as integration with Ukrainian telephony and Nova Poshta is important. We are also open to considering Pipedrive. System setup. Creating a sales funnel, client cards, and configuring fields according to our specifics. Integrations. Connecting telephony, messengers, and Nova Poshta. Data import. Correct transfer of the existing client base (about 220 contacts) from current files. Training. A brief briefing for the sales department head and two managers on the rules for managing deals to ensure data cleanliness and quality in the CRM. Further tasks (Stage 2 — Support) Technical support and refinement of automations during the work process. Monitoring the correctness of data exports for further AI analytics. Who we are looking for A specialist with experience in implementing KeyCRM, SalesDrive, or Pipedrive (please include examples or cases in your response). A person who understands the principles of building sales analytics and can configure data exports without "garbage". A responsible specialist ready for long-term cooperation and project support. In your response, please indicate Your experience with KeyCRM, SalesDrive, or Pipedrive. Estimated cost and time for basic setup for our team (3 users). Whether you are ready to further administer the system and under what conditions.
About the Company Trading company. We work with a product group of more than 2000 items across different categories.Current Situation Currently, the nomenclature is maintained in Google Sheets — data is consolidated by tabs (categories). Tab Structure: Product name Price groups: cost price, wholesale, retail Characteristics: weight, quantity per package, etc. Important: the number of columns varies for different product categories, as they have different characteristics.Why the Current Solution is Inadequate Google Sheets does not allow setting access rights at the level of individual columns. We need to: Grant users rights to view certain columns (for example, only cost prices) Grant rights to edit certain columns (for example, retail prices) While restricting access to other columns in the same tabWhat Needs to Be DoneMain Requirements Flexible Rights Management System Access at the level of individual columns (read/write) Assignment of rights by roles or users Management of rights without the involvement of programmers Support for Different Data Structures Different product categories have different sets of characteristics Adding new columns/characteristics without programming Independence from Developers Administration by internal staff Adding categories, columns, users — through the interface Integration with ERP Exporting current prices to our ERP system Export or automatic integration via API Data Analysis Using AI (preferably) Ability to analyze the entire nomenclature list Enrichment, verification, recommendations — if you have ideas, please describeExpected Result A working solution in which: The nomenclature is structured by categories with different sets of characteristics Column rights are flexibly configured (view/edit) Data is exported to ERP The team can manage the system independentlyWhat We Need from You When Responding Describe in general terms how you envision the solution: What tool/platform do you propose
A deep technical verification of three PDF files for authenticity and possible signs of editing or forgery is required. Not only a visual assessment of the documents is needed. The performer must have a good understanding of the internal structure of PDF files and be able to analyze: file metadata; PDF structure and individual objects; creation history and possible editing; software used; embedded fonts, images, layers, and other elements; possible signs of re-saving, conversion, modifications, or backdating of the document; any technical discrepancies that may indicate manipulation of the files. Based on the verification results, a clear written conclusion regarding each file must be provided, indicating the identified signs, risks, and limitations of the verification. We are considering specialists who have practical experience in digital forensics, PDF document analysis, metadata, or verifying electronic files for authenticity. In your response, please briefly describe your experience, methods, and tools that you use for such verification.
General information It is necessary to develop a simple minimalist web system, the main purpose of which is to maintain a client database, create appointments for visits, and automate the process of confirming visits via SMS, sending one-time links through the API from the service itself. The project is being developed in stages. In the first stage, it is necessary to implement only the basic functionality (MVP) so that the system can be used in real work. After launch and testing, it will gradually be expanded with new modules.Main functionality of the first stage User authorization; Client database; Creating and editing appointments; List of appointments (or a simple calendar); Switching between points of sale; Integration with the SMS operator via API; Sending SMS with any text or link for visit confirmation; Confirmation or cancellation of the visit by the client via a one-time link; Displaying the confirmation status directly next to the client's appointment. At the initial stage, instead of a full calendar, the use of a simple list of appointments by days is allowed. Each day should contain a chronological list of bookings indicating the time, client's name, service, employee, and confirmation status. Later, this list can be replaced with a full calendar without changing the system structure. The system must have the ability to switch between points of sale. Each point of sale has its own list of appointments (or calendar), but they all use a common client database.