Oleg Sherbina
Offer Oleg work on your next project.
Private message
Offer work
available for hire
Rating
Successful projects
Average rating
Skills and abilities
Programming
-
Bot Development
from 11 USD for hour
-
Data Parsing
from 11 USD for hour
-
Databases & SQL
from 9 USD for hour
-
Python
from 10 USD for hour
Services
Administration
-
System & Network Administration
from 11 USD for hour
-
Windows
from 11 USD for hour
Portfolio
-
451 USD Integration with TorgSoft -> Shopify
Python
Integration between the accounting system Torgsoft and the Shopify platform to combine two systems: offline warehouse with online store. Motivation — to adapt products from Torgsoft (with their data structure) to the requirements of Shopify, creating product variants, groups, and custom fields. This allows for automatic export of the catalog without manual adjustments, saving time on processing stock, prices, and photos. Similar adaptations can be made for other accounting systems (for example, 1C) and platforms (WooCommerce).
What was implemented and for what purpose
FTP for export from Torgsoft: Set up a server for automatic receipt of CSV and images — ensures secure access and data transfer without manual copying.
…
Product and variant adaptation: The parser creates product groups, unique IDs, variants (colors, sizes), and custom solutions according to Shopify requirements (Handle, Title, Variants) + client requests (transliteration, tags) — makes the data compatible, minimizing import errors.
Web server for photos: Deployed under IIS with WSGI on Windows Server for generating image URLs — photos are immediately ready for Shopify, without external services.
Notifications in Telegram: The script sends reports with files and statistics (number of SKUs, processing time) — helps the team quickly understand the status of the export.
Archiving and logs: Everything is archived to track conflicts (name errors, duplicates); detailed reports record exports, creation of variants and fields — simplifies auditing.
Technologies: Python 3, Pandas, Flask (WSGI), FTP, Telegram API, Hashlib.
The solution is flexible: easy to add fields or integrate with other systems.
-
180 USD Integration Shopify -> KeyCRM
Python
Orders from Shopify are converted into KeyCRM format and a detailed message in the team's Telegram chat.
How it helps and what it solves
… Orders instantly appear in KeyCRM without manual import — saving hours for operators.
Telegram notification with products, delivery, and payment speeds up employee response and reduces errors.
Flexible post-processing of JSON (additional fields, default values) easily adapts to any business processes.
Archiving of source files creates a clear history for analytics.
Designed for scalability: the same algorithm connects to any other CRM or ERP via API configuration.
Stack
Python 3 / Flask / Requests / JSON / KeyCRM API / Telegram Bot API.
Why it stands out in the market
Standard SaaS connectors (Zapier, ApiX) charge a subscription fee and do not allow flexible changes to the order structure; the script is 100% customizable and has no fees.
Delivers ready, clean JSON directly to KeyCRM, keeping the source for audit — a rarity among ready-made integrations.
Easily extensible: you can add a cumulative bonus, promotional mailing, or warehouse integration — just change the field mapping.
-
451 USD Telegram bot for the loyalty system in a clothing store
Python
This bot introduces a simple and understandable loyalty system to your store where it previously did not exist. It works in Telegram — right on the phone for you and your clients — providing direct communication, duplication of purchase history, and the possibility of expansion (advertising, integration with the website, notifications about new products). The bot synchronizes data with your database (for example, TorgSoft), making loyalty accessible and transparent for everyone.
How the bot will help you (store owner/admin)
Introducing loyalty without complications: Automatically calculates cashback, discounts, and points based on purchases — just add a client, and the system works. No need for separate applications or CRM; everything is in Telegram, where you already communicate.
…
Direct communication and marketing: Duplicate orders from the website, send notifications about new products, promotions, or personal discounts — clients see everything in the chat, which increases engagement and repeat purchases by 20–30%.
Control and analytics: View clients' purchase history (duplicated from the database), generate reports on sales and suspicious activities — helps analyze behavior and prevent losses.
Time and resource savings: Automate adding clients, calculations, and notifications — less routine, more focus on sales. Scalable: integrate with the website, email, or other systems for full automation.
Scaling: Everyone sees the purchase history (you and clients), which simplifies personalization — clients are more loyal, and you get data for targeted advertising in Telegram.
How the bot will help your clients
Simple loyalty in their pocket: Earn points, cashback, and discounts automatically — all in Telegram, without apps. View purchase history, balance, and personal offers in one click.
Convenience and communication: Duplication of orders from the website, notifications about new products and promotions — clients are always informed, can quickly contact the store, and receive recommendations (for example, "Based on your purchases — discount on the new collection").
Motivation to purchase: A transparent system (you see points and history) motivates clients to return — they feel the value, which increases loyalty and visit frequency.
The bot brings your clothing closer to clients: direct communication speeds up sales, and loyalty retains the audience. Ready for integration with any systems for your business.
Technical details (briefly)
Core: Python 3.x + Telebot; handlers for menus, callbacks, and notifications.
Database: SQLite (locally) + PyODBC for TorgSoft (SQL Server, synchronization of orders/history).
Functions: Data validation, PDF reports (ReportLab), mailings, extensibility (integration with website/advertising).
Result: Simple installation, processing thousands of clients; scalable for your store.
-
902 USD Bot for the salon
Python
***Admin***
[Client Records]
1. Display all records:
- Full name, phone, date;
… - Open chat with the user;
1.2 Confirm the appointment/cancel;
- 1.2.1 "Confirmation" records that the service was provided and notifies the user of successful completion. Adds this service to the user's visit history.
- 1.2.2 "Cancellation" cancels the appointment, notifying the client that the appointment was canceled by the administrator (with the administrator's details and contact information).
2. For the week:
- Dynamic inline menu with a calendar and functionality for viewing appointments, confirmation/cancellation.
- Full name, phone, date, open chat, button to call the client.
[Appointment Time]
1. View current time
1.1 Edit service time
- 1.1.1 When editing, consider if there are users with active appointments at that time, display full information about the users and prohibit changes to the time. If there are no active appointments at that time, the service time can be changed.
1.2 Deletions:
- 1.2.1 When deleting, consider if there are users with active appointments at that time, display full information about the users. Upon confirming the deletion, users will receive a notification about the cancellation of their appointments for each day at the current time. If there are no active appointments, deleting the time will not notify anyone.
1.3 Notification of new time to users.
[My Schedule]
1. Add a day off
1.1 View calendar with visualization of working/off days, select a date in the calendar and confirm it as a day off.
- 1.1.1 If there are users on the day marked by the administrator, a message about the clients will be displayed with the option to cancel their appointments (similar to item 1.2.1). The ability to create a day off is only available if there are no clients on the current day.
1.2 Functionality to send notifications to all clients about the administrator's day off.
2. Display current days off.
2.1 Ability to notify about the current day off.
2.2 Deletion of a day off.
***User***
Initially, when the bot is first opened, the user goes through registration, one button press sends the user's phone number and name. Based on this, a user is created, and administrators gain the ability to contact the client via Telegram or phone call.
[Appointment]
1. Display dynamic inline calendar with visualization of days off.
1.1 After selecting a date, an inline menu is displayed with the choice of time set by the administrator.
1.2 Cancel the selected day.
#After selecting the day and time, the administrator receives a notification about the new client with detailed information. The client receives confirmation that they have booked the current date and time.
[My Appointments]
1. Display inline menu with the user's current appointments.
1.1 Change appointment time: Provides the user with the functionality to choose free time, after confirming the time change, the administrator receives a message that the user has changed the service time.
1.2 Deletion notifies the administrator of the cancellation of the service. The user receives confirmation that they have canceled the appointment for the current service.
[Appointment History]
1. Display a list of dates and times when the service was provided.
[Master Profile]
1. Information about the master, links to social networks, works, description.
-
2000 USD Alcohol testing
Python
Automation of the passage of alcohol testing, through the identification of persons on the base, the accounting of income/input from work, the calculation of work time, graphics, the notification of the violators with video fixation and the immediate notification of the authorized persons.Equipment is:
by SpeedFace
by AlchoForS40
The Dahua
…
Used by:
• Web-server Flask (jinja)
by BD Postgre
• API Dahua (POST\GET)
API of AlchoForS40 (USB, Hex)
• Microtic NAT
The Telegram Bot
Windows Server 2016
The Ubuntu 18.04
The functional:
Access rights are implemented by groups.Configurated settings
The Graphics
Access to statistics in the bot
Access to statistics on the website
The result:
Automated Alcohol Testing by Identifying Persons
Real-time display of testing
The Visitability Account
Calculation of working time
Notification of the indicators of alcohol violators by means of:
Video of Fragment
The extraction of all information about the user
Col-in breached
Due to this decision:
The "contractors" with nurses were excluded.
Excluded risk of admission without testing to work
Fast reaction
Exclusion of accidents due to alcohol
Activity
| Latest proposals 6 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Creation of a Telegram bot
451 USD
|
|||||
|
Refinement of the AI bot
226 USD
|
|||||
|
Title: Freelancer needed to create a Telegram bot with CRM system integration and delivery service
226 USD
|
|||||
|
A Telegram bot development is needed for processing messages from groups (Python)
226 USD
|
|||||
|
Server configuration for Python code execution
113 USD
|
|||||
|
Set up synchronization of the Торгсофт program with the online store
338 USD
|
