Optimization of the MySQL site on JUMLE

Online store on Shopify, CRM — SalesDrive. The integration of order transfer has been done with code.Problem: orders from Shopify for many products are entering SalesDrive as new unrelated items (with zero stock), they are not linked to existing catalog cards. There is also a problem with price synchronization when ordering 2 or more products (there is an option for a discount on 2 and 3 products). Sometimes the third order does not pull the city and branch into the application in the Nova Poshta block What needs to be done: 1. Ensure that the SKU field for each item is correctly transmitted in the order (matching the SKU of the SalesDrive catalog) — systematically across the entire catalog, not just for one product. 2. Process the quantity options 1/2/3 packaging: so that each option transmits the correct price. Acceptance result: test orders for several products (including options 2/3 packaging) are linked in SalesDrive to cards without a red triangle, with stock deduction and correct pricing. A specialist with experience in Shopify + SalesDrive and custom integrations (API/code) is needed. Detailed technical specifications and access will be provided to the selected contractor.

I want a bot for Telegram. Loading dialogues. With the help of AI, checking for potential lies. A website with advanced features. Registration, API, statistics, etc.

TaskNeed to create:1. Landing page (can use AI) modern, minimalist design mobile adaptation (main traffic is mobile) structure for lead generationRecommended structure: main screen (offer + WhatsApp button) services (moving, loaders, packing, etc.) advantages work process (3–5 steps) reviews (can be template-based at the start) application form contact block 2. WhatsApp bot automatic responses to frequently asked questions collecting applications (name / address / date / type of move) transferring applications to WhatsApp/CRM quick buttons (calculation, consultation, order) 3. Application form simple form on the website integration with notifications (email / WhatsApp / CRM) minimum number of fields to increase conversion 4. Analytics Google Analytics / GA4 events: form submission, clicks on WhatsApp, calls basic conversion setup 5. CRM (simple integration) connecting applications to CRM (any convenient system — to be discussed) lead tracking ability for further processing of applications Conditions budget: 5,000 UAH deadline: 3 days (urgent project) work format: step-by-step, with tests and revisions Requirements for the performer experience in creating landing pages for services / lead generation understanding of UX for mobile traffic experience in integrating WhatsApp bots or similar solutions basic understanding of analytics (GA4) careful work and adherence to deadlines

Currently: Working online store. 2017, PRESTASHOP - 1.6 Template - https://www.sunnytoo.com/product/transformer-prestashop-theme-premium-responsive (Very old version). 10 languages, 200 products, many custom changes in modules. Store in Europe. Hemp seeds store, all legal. If the industry scares you, please pass by. www.seedsmafia.com Changes: Need a person or company who can redesign and update it in the template. Template - We will keep the same. To make it look fresher. Something between minimalist and our style. To start, changes in design + implement this design on the site. Banners and styles are also on you. To make everything cohesive. Total update of Presta, template, and design is currently impossible. You can show your portfolio. (in the proposal)

I need a program that will send messages to our database of clients' phone numbers (or emails). With its own proxy. It can be Viber, or Telegram, or email. The program needs to be installed on my computer. (I am waiting for your offers regarding the price.)