Оптимизация запросов к БД Wordpress

Changes need to be made to 3 (three) different forms, calculators, and data entry pages on the website according to the technical specifications. The implementation of the calculators and pages is required in two languages. It is possible to refine the existing forms and calculators or create new ones if that is easier for execution. The technical specifications will be provided. During the execution of the task, minor additions or clarifications regarding changes to the calculators or forms (templates) may be made.

When placing an order, when the buyer selects the country "Ukraine," the system substitutes the delivery method from the "Rest of the World" zone (Self-pickup (M)) instead of the "Ukraine" zone (Self-pickup (U)). The shipping plugin support has already tested this hypothesis: they deactivated the UA Shipping plugin, turned off all its delivery methods, and left only the standard WooCommerce methods — The problem remained even after this, meaning the cause is not in the shipping plugin, but somewhere in the site settings.

Need to: Create a website – online store in Ukrainian (subsequently multilingual). The engine is not critical, the most important thing is that the admin panel is user-friendly.Consists of: - Main page- Catalog with categories, subcategories, and product cards (with the ability to add both categories and subcategories): - Blog- Text (purely informational) pages:“Who we are” or “ABOUT US”Payment and delivery, Exchange and returns, Privacy policy, Public offer, Warranty.Contacts+ Admin panel 2. Register hosting 3. Purchase and link a domain4. Install a favicon5. Register Google Analytics and add the website 6. Create and connect a Telegram chatbot for order notification. 7. SEO. It is necessary to provide fields for each category and product: HTML title, meta keywords, meta description, h1, SEO text. The design can be template-based.

We are looking for an experienced WordPress developer or a small team for a comprehensive modernization of the existing website of the construction company TERZI — terzi.biz. It is necessary to transform the existing website into a modern interactive sales platform: develop a premium responsive UX/UI design; improve the frontend and backend of WordPress; create managed sections for services, materials, equipment, projects, and case studies; implement a cost calculator, quiz, forms with photo uploads, and B2C/B2B scenarios; integrate KeyCRM, Telegram, GA4, GTM, Meta Pixel, Google Ads, and Ringostat; implement Ukrainian and Russian versions; maintain existing SEO positions, set up redirects, Schema.org, and Core Web Vitals; conduct migration, testing, and launch of the website. The website does not necessarily need to be created completely from scratch: usable code and modules from the existing WordPress should be reused. There is a detailed technical specification of 50 pages with page structure, functionality, design system, and acceptance requirements. In your response, please indicate: Examples of similar WordPress projects. Who will be responsible for design, frontend, and backend. Preliminary timeline and cost. Proposed development stages and warranty conditions.

A plugin needs to be developed. The goal is a convenient table for quick selection and purchasing of goods by wholesale buyers. Functionality Front: Columns - Product selection (check), Name, Category, Warehouse, Delivery, Price, Quantity selection, Add to cart, Clear filters search products in a list filter by categories filter by warehouses filter by delivery product quantity selection adding to cart Back: bulk price increase and decrease by % per warehouse