Create a secondometer in Google Sheets by example

What needs to be done A complete transfer of the OpenCart website from one account to another within the same hosting provider is required. After the transfer, the website must function identically to the current one, without data loss, settings, modules, or functionality.Tasks Transfer all OpenCart website files. Transfer the database. Transfer all OpenCart settings. Correctly connect the website to the database. Check the functionality of all installed modules, templates, and add-ons. Connect the domain name to the new account. Issue and configure the SSL certificate. If necessary, purchase and activate a license (if required for the template or modules). Check the website's functionality after the transfer: homepage; categories; product cards; search; cart; checkout; contact forms; OpenCart admin panel; all installed modules. Check for PHP, MySQL, SSL errors, and redirects. Ensure that the website opens correctly over HTTPS without browser warnings. Perform the transfer with minimal downtime.Requirements Do not disrupt the functionality of the current website. After completion, the website must fully function on the new account. All data, images, products, categories, settings, SEO, modules, and templates must be preserved. If necessary, independently perform all technical settings. Before handing over the project, check for errors and ensure that the website is fully ready for operation.Result The OpenCart website has been fully transferred to the new account, the domain name is connected, SSL is functioning correctly, all modules and functionality work without errors, and the admin panel is fully accessible.

Create a dashboard for monitoring and analyzing the performance of the company's location network (branches) in Google Business Profile (GBP) through the official Google Business Profile API. Process via a script based on Google Apps Script (link to Google Sheets). Record data in Google Sheets (which serves as a database for Looker Studio). Update: Daily (with an indication of the last update date). Create a Google Cloud service account. The script runs once a day (trigger at 03:00 AM) and sends a request to the GBP API. It retrieves metrics for the previous day for each location (locationId). Records data in a flat format (row = unique combination of Date + Branch ID + Metrics). Key Performance Indicator CardsCard NameGBP MetricDynamic FormatProfile ViewsImpressions (Search + Maps)Percentage %, Sparkline (blue)CallsLocal Services Phone CallsPercentage %, Sparkline (green)Website ClicksWebsite ClicksPercentage %, Sparkline (purple)Direction RequestsDirection RequestsPercentage %, Sparkline (orange)Average RatingAverage Review RatingAbsolute change (e.g., +0.1), Sparkline (yellow)New ReviewsNew Reviews CountPercentage %, Sparkline (turquoise)

Hello everyone! I'm looking for a Backend Developer (NestJS) to work on a new project. What needs to be done Develop a REST API using NestJS. Prepare and maintain documentation through Swagger (OpenAPI), so that the frontend developer can automatically generate a client using Orval and always work with the current specification. Design a clean, scalable architecture that will be easy to maintain and develop. Requirements Strong knowledge of NestJS and TypeScript. Experience with PostgreSQL. Experience integrating with Supabase: authentication and authorization; working with the database; using the platform's built-in features. Experience integrating Stripe (through Supabase features). Understanding of API security principles, authorization, data validation, and application protection. Ability to write clean, structured, and extensible code. If you have relevant experience, please send: examples of projects or GitHub; your desired rate (for the screens I provided, so I can understand your rate, hourly is inconvenient as it's unclear what volume of work will be done, everyone has a different pace);

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.