Making a macro for Excel

Good day! We have a project on Next.js, React, Node.js, and Strapi. Currently, the main page is designed, and two secondary pages need further development. It is also necessary to design another 4–5 pages with adaptation and complex animations for different devices and connect them to the Strapi admin panel. Due to the change in the workload of the previous developer, we are looking for a new specialist to complete the project. We are looking for a responsible developer with practical experience working with this stack. In your response, please include examples of similar projects. The budget will, of course, be discussed.

It is necessary to automate the update of the existing Custom Audience in Meta Ads, which is used to exclude buyers from advertising campaigns. Required logic: once a day, retrieve the last 400 orders from the CRM (for example); take the customer's phone number and, if available, email; remove duplicates and format the data to the format accepted by Meta; completely replace the customer list in the existing audience, keeping its current ID; ensure protection: do not clear the audience if the CRM returns an empty or incorrect list; set up automation through Make and/or Meta Marketing API; check that the audience continues to be used correctly in the exclusions of advertising campaigns. The audience is already created, but is currently updated manually. The executor is required to: Propose the optimal implementation method. Specify what accesses and permissions will be needed. Estimate the cost and time for completion. Indicate experience working with Meta API and Make. After setup, provide a brief description of the logic of operation and the accesses used. Additionally, please clarify: is a complete daily replacement of the audience possible through the API and what limitations or risks may exist from Meta's side.

A bot needs to be developed (preferably in Python) that will automatically check the website for new job vacancies. Requirements: Monitoring the official website details will be added Checking every 1–2 minutes. Tracking only specific locations and cities If a new vacancy appears, the bot must immediately send a message to Telegram The message must contain: the job title; the location; a link to the vacancy; the time of detection. The bot must not send repeated messages about the same vacancy. An instruction manual for setting up and running the bot after completion is required. Preferred: The ability to easily add or remove locations. The ability to track only specific types of vacancies Stable operation 24/7. Budget: from 3000 to 6000 hryvnias Please indicate the completion time, final cost, and examples of similar projects (if any).

Development of a modern online store Protone.com.ua (turnkey)About the project It is necessary to completely update the website Protone.com.ua and create a modern full-fledged online store by transitioning from Prom.ua to an independent platform (CMS). We are looking for an experienced performer or team that can implement the project “turnkey” — from developing the structure and design to launching the finished online store.Main tasks1. Development of a new website It is necessary to create a modern, fast, and responsive online store with a professional design and user-friendly interface. The website must be: modern and attractive; responsive for all devices; fast; user-friendly; SEO-optimized; easy to administer.2. Complete transfer of products It is necessary to transfer all product items from the current website and Prom.ua to the new site. Including: categories; products; characteristics; photos; manufacturers; prices; attributes; SEO data (if possible). It is also necessary to set up correct redirects to maintain positions in Google.3. Complete filling of the website with content We expect a complete filling of the new website. It is necessary to: create or refine category descriptions; create or edit product descriptions; write quality SEO content; optimize H1 headings; set up Title and Meta Description; perform internal linking; create a proper page structure. The content must be unique, professional, and SEO-optimized.4. Full-fledged online store It is necessary to implement all required functionality: product catalog; quick search; filtering; sorting; modern product card; cart; order processing; personal account; wishlist; product comparison; product recommendations.5. Modern design An individual design is needed without using standard templates. The main page should contain: banners; popular categories; popular products; new arrivals; promotional offers; brands; informational blocks; company advantages; customer reviews.6. SEO optimization The website must be fully ready for promotion in Google. Mandatory: correct URL structure; speed optimization; Core Web Vitals; Schema.org; Sitemap.xml; Robots.txt; Open Graph; SEO for all pages; correct redirects from the old site.7. Integrations It is necessary to set up: Nova Poshta; payment systems; Google Analytics 4; Google Tag Manager; Google Search Console; Google Merchant Center; Facebook Pixel; the possibility of further integrations with CRM.8. Optimization We expect a maximally fast website with high Google PageSpeed scores and quality technical optimization.Expectations from the performer In response to the project, please be sure to indicate: which CMS you propose (WordPress/WooCommerce, OpenCart, or another) and why; estimated budget; completion time; what is included in the cost of work; whether technical support after launch is included.Also, it is MANDATORY to provide: links to online stores you have implemented; examples of projects that are as similar as possible in functionality; a brief description of what specific work you performed (design, programming, SEO, integrations, etc.). Preference will be given to performers who have confirmed experience in creating modern online stores with high speed, quality design, and SEO optimization.Important We are looking for not just a developer, but a partner who will complete the project fully “turnkey”. It is necessary to take on the entire range of work: creating the website structure; developing modern design; developing the online store; complete transfer of all product items; complete filling of the website with content; creating quality SEO-optimized content; setting up all integrations; basic technical SEO optimization; testing; launching the finished project. The result of the work should be a modern, fast, functional, and SEO-optimized online store, fully ready for operation and further promotion in Google. When selecting a performer, we will evaluate not only the cost of work but primarily the quality of implemented projects. Therefore, we ask you to send the best examples of your work with links to finished websites so that we can assess the level of execution, design, functionality, and overall quality of implementation.

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.