Написать 1 строку запроса к БД (работа с OpenCart ocStore 2.3.0.2.3)

Website optimization for Google Pagespeed on OpenCart. https://mercurial.com.ua/ Previously, optimization was done and plugins were connected. The task is to optimize so that in terms of performance special features it enters the green zone Main Category/subcategory Product

A cost and timeline assessment of the website layout is needed. The client is the Ukrainian Automotive Group, which unites official dealer centers. The website will have 8 pages, a designer is available, and a developer needs to be found for the layout on WordPress. The News block will need to be simply transferred from the previous website, which is on WordPress. The design will be simple, commercial, similar to - https://niko.ua More work will be required on the website functions. A preliminary estimate is needed now, plus please indicate the cost and time to develop: 1) AI consultant. The website proposes to place an AI consultant chatbot based on a language model (LLM), accessible through a floating button, along with a "Contact Us" form (with options: "Message the manager" / "Ask the AI consultant a question"). 2) Calculator on the website. Instant preliminary trade-in calculation: an online calculator by make/model/year/mileage, providing an estimated price range before visiting the showroom. 3) Model comparison - selecting 2–3 models side by side based on characteristics and price. The website structure is in the file.

It is necessary to deploy a website from a full backup on a new hosting The website is created on Drupal Please send your proposals

A web service needs to be developed for automating the operations of coffee shops and small food service establishments. The product should have functionality similar to Poster POS, but with its own design, architecture, and source code. Copying the code or interface of Poster is not anticipated. The plan is to create a full-fledged commercial SaaS product that various coffee shops can use in the future on a subscription basis.In the first stage, an MVP needs to be developed Main functionality: registration and authorization of the establishment owner; creation of one or several establishments; management of employees and roles; catalog of products, categories, and modifiers; adding sizes, flavors, and additional options; cash interface for processing sales; opening and closing cash shifts; various payment methods; returns and order cancellations; inventory accounting and write-offs; basic stock accounting; sales history; reports on revenue, products, shifts, and employees; loyalty program for customers; adaptive operation on tablets, laptops, and smartphones; administrative panel for the service owner; tariff plans and restrictions according to the tariff.Future plans include mobile application; integration with payment terminals; receipt printing; integration with fiscal services; delivery and online ordering; table reservations; advanced analytics; API for third-party integrations; integration with accounting and CRM systems.Important requirements the system must be designed to operate multiple independent establishments; data of each client must be isolated; scalability of the product must be anticipated; secure handling of financial and personal data is required; the code must be structured and suitable for further development; technical documentation is needed; rights to the source code are transferred to the client after payment. At this moment, the design is absent, so a separate assessment of UI/UX design is needed or a ready-made solution for the MVP should be proposed.Please include in your proposal experience in creating SaaS, POS, CRM, ERP, or accounting systems; examples of similar work; proposed technology stack; team composition; estimated cost of the MVP; development timeline; what exactly is included in the proposed cost; cost of further support; whether you are ready to work in stages with payment for each completed stage. Preference will be given to performers or teams that have already developed cash, inventory, restaurant, or multi-user SaaS systems.

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