Completion of WP plugin development (PHP, SQL, CRM)
192 USD Platform:
Website on WordPress.
Installed plugins:
* Booking service appointments (Bookly)
* CRM system (Groundhogg)
Goal:
Listen to PHP POST requests from the Bookly plugin (which have the prefix "bookly_"). Extract data from the request for the unique identification of completed bookings (a single unique ID is not detected, a combination of fields must be used, for example, email + booking timestamp). Using this data, make a query to the database to obtain the most detailed information about the booking. Send the obtained information via HTTP POST request and read it in the CRM through a webhook.
The plugin has complex booking functionality with numerous booking variations. All possible options must be taken into account.
This goal is 70% implemented in the attached plugin.
Project tasks:
1. Implement the goal described above by refactoring and completing the remaining code.
2. Make the functionality as simple as possible and less likely to break during plugin updates.
3. Create documentation describing potentially vulnerable areas where issues may arise during plugin updates.
4. Create optimal debug logging to facilitate the identification of reasons why the plugin stopped functioning.
It is necessary to detect events such as:
- completed booking
- cancellation of booking
- editing of booking
Receive data in CRM in a format convenient for further work of the CRM system with this data (in consultation with our CRM specialist)
Необхідно виявляти такі івенти як:
- завершене бронювання
- скасування бронювання
- редагування бронювання
Принемать данные в CRM в формате, удобном для дальнейшей работы CRM системы с этими данными (в консультации с нашим специалистом CRM)
After discussing with colleagues, I want to change the wording of the task:
1. Listen to 4 types of events (any event method, but not via cron):
* Booking creation
* Booking cancellation
* Booking editing
* Change of personal data by the client in the personal account
2. Determine the unique identifier of this event (for example, a combination of database fields) so that it can be found with a query to the database.
3. Send this unique ID via HTTP POST request to the CRM system webhook.
4. Using this unique ID, be able to make any custom SQL query to the database by the CRM (as an option through Custom REST API Endpoint, see the attached file with the screenshot from the chat gpt)
5. Use the response received from the database to save any CRM entity (for the clarity of the mechanism's functionality)
5. Documentation (as described in the initial task)
Після обговорення з колегами хочу змінити формулювання завдання:
1. Слухати 4 типи івентів (будь-яким івент способом, але не через cron):
* Створення бронювання
* скасування бронювання
* редагування бронювання
* зміна особистих даних клієнтом в особистому кабінеті
2. Визначати унікальний ідентифікатор цього івента (наприклад, поєднання полів БД) щоб його можна було знайти запитом до БД.
3. Надсилати цей унікальний ID через HTTP POST запит на вебхук CRM системи.
4. Використовуючи цей унікальний ID мати можливість робити будь-який кастомний SQL запит до БД силами CRM (як варіант через Custom REST API Endpoint, дивіться прикладений файл зі скріншотом від чату gpt)
5. Використовувати отриману відповідь від БД для збереження будь-якої сутності CRM (для наочності працездатності механізму)
5. Документація (як описано у початковому завданні)
Applications 1
Current freelance projects in the category Databases & SQL
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 17 hours 2 minutes back ∙ 13 proposals |
Vibe coding through Claude Code
350 USD
Develop a closed web platform for corporate events with personal invitations via unique links and QR codes. After scanning the QR code, the user is directed to a personal invitation page with a welcome message, a greeting by name, a photo and a message from the CEO, a countdown… AI Art, Databases & SQL ∙ 20 hours 11 minutes back ∙ 41 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 1 day back ∙ 35 proposals |
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 5 days back ∙ 6 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 5 days 3 hours back ∙ 19 proposals |
Zaandam