Oleksii Zorkin
Offer Oleksii work on your next project.
Private message 
Offer work 
available for hire
Rating
Successful projects
Average rating
Language proficiency level
Українська: fluent
Русский: advanced
English: intermediate
Skills and abilities
Programming
-
Bot Development
from 56 USD for project
-
Data Parsing
from 34 USD for project
- Databases & SQL
-
Python
from 23 USD for project
Services
-
Data Processing
from 23 USD for project
-
Information Gathering
from 23 USD for project
-
Online Stores & E-commerce
from 226 USD for project
-
Website Development
from 113 USD for project
-
Website Maintenance
from 45 USD for project
Portfolio
-
Creation of a landing page
Website Development
# Transfer of domain name from paid platform
# Design update
# Hosting placement
-
Telegram Bot in Python
Bot Development
# Telegram Bot for Document Flow Automation (Invoices and Acts)
## Project Overview
… This Telegram bot is designed for **quick generation of invoices (Invoices) and acts of completed work (Acts) in XLSX and PDF formats** based on data entered by the user through a dialogue.
The project demonstrates skills in developing functional **Telegram bots** using the asynchronous framework `aiogram` and practical work with **MS Excel** files for generating official financial documents.
---
## Key Features
* **Dialogue Interaction (FSM):** Step-by-step data collection (company name, invoice number/date, list of services, quantity, price) using **FSM (Finite State Machine)** in `aiogram` for a structured user experience.
* **Document Generation:** Using the `openpyxl` library to fill template XLSX files with invoices and acts.
* **PDF Conversion:** Automatic conversion of created XLSX files to PDF using an external tool (`libreoffice` via `subprocess`).
* **Flexibility:** Support for adding multiple service items in one document.
* **Financial Functions:** Automatic calculation of the total amount and output of the amount in words in Ukrainian (`num2words`).
---
## Technologies Used
| Category | Technology | Description |
| :--- | :--- | :--- |
| **Main Language** | Python | |
| **Bot Framework** | `aiogram` (v3+) | Asynchronous framework for Telegram bots. |
| **State** | FSMContext / MemoryStorage | Managing user sessions. |
| **Excel Handling** | `openpyxl` | Reading and writing data to template XLSX files. |
| **Configuration** | `python-dotenv` | Hiding confidential data (API token). |
| **System Calls** | `subprocess` + `libreoffice` | Document conversion. |
-
Turnkey online store website on Horoshop
Website Development
# Comprehensive launch of an online store on the Horoshop platform for selling climate technology. The project is completed "turnkey" with full functionality setup and preparation for sales and promotion.
# I provide a complete cycle of store launch, ensuring its quick start and readiness to receive traffic and sales:
Setting up the Horoshop platform:
…
Choosing and adapting a design template according to the corporate style.
Setting up necessary modules and functions (filters, sorting, cart, order checkout pages).
Creating and setting up necessary additional pages (About Us, Delivery, Payment, Warranty, Services).
Structure and Content:
Developing a logical structure of the catalog and categories for convenient navigation.
Importing/Creating products (up to [X] items, or "first batch of products") with full content (titles, descriptions, photos, specifications, prices).
Setting up attributes and characteristics for the correct functioning of filters.
Finance and Logistics:
Connecting payment systems (e.g., LiqPay, WayForPay).
Setting up delivery methods (Nova Poshta, courier) and integration with logistics services (if necessary).
Analytics and Advertising (Critically Important):
Basic SEO setup (filling in meta tags, robots.txt, sitemap).
Installing and configuring Google Analytics (GA4) and Google Tag Manager (GTM) for tracking conversions.
Preparing the store for launching Google Ads (setting up the product feed for Merchant Center).
-
Website for a climate company on WordPress
Website Development
Creation and filling of a website for a climate company in two languages. Modern design, Elementor SEO
-
23 USD Parser in Python + upload to Woocommerce IP + price update
Data Parsing
# E-commerce Automation Tool: Price and Availability Synchronization (WooCommerce)
## Project Overview
… This Python script is designed for **full automation of the process of populating and updating the product catalog** on the WooCommerce/WordPress platform based on data from an external supplier (web scraping).
The project demonstrates skills in developing reliable parsers, automating business logic (updating price/availability), and deep integration with E-commerce system APIs.
---
## Key Features
* **Catalog Automation:** The script addresses the issue of manual price updates and the creation of new products.
* **Web Scraping:**
* Collecting links to all products from the specified supplier category.
* Extracting key data: name, price, full description, specifications, image and video links.
* Using `requests`, `BeautifulSoup`, `fake-useragent` to bypass and process content.
* **API Integration with WooCommerce:** Using the official `python-woocommerce` library for:
* **Price Update:** If the product exists, the script checks the price's relevance and updates it if it has changed.
* **Creating New Products:** If the product does not exist, it is automatically created in WooCommerce.
* **Managing Attributes:** Automatically checks for the presence of attributes (e.g., "Brand", "Compressor", "WI-FI") and **creates them via API** if necessary.
* **Content Processing:**
* Transliteration of product names to generate correct `slug`.
* Parsing and saving description images locally for further uploading to the server.
* Creating a short HTML description (`short_description`) based on key specifications.
* **Status Management:** Variables are used to switch categories and brands (for different suppliers).
---
## Technologies Used
| Category | Technology | Description |
| :--- | :--- | :--- |
| **Main Language** | Python | |
| **Parsing** | `BeautifulSoup`, `requests` | Extracting data from HTML pages. |
| **E-commerce API** | `python-woocommerce` | Interacting with the WordPress/WooCommerce API for CRUD operations. |
| **Obfuscation** | `fake-useragent` | Simulating a real user to prevent blocking. |
| **Transliteration** | `unidecode` | Generating correct SEO-friendly `slug` (understandable URLs). |
| **File System** | `os`, `re` | Managing paths, regular expressions. |
Activity
| Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Creation of an analytical platform for the collection and analysis of Meta (Facebook & Instagram Ads) data
564 USD
|
|||||
|
Automated content system for Telegram channels based on Make + Google Sheets + OpenAI API.
300 USD
|
|||||
|
One-page website on Wordpress
79 USD
|
|||||
|
Online cosmetics store
451 USD
|
|||||
|
Landing page for employment in Europe
271 USD
|
|||||
|
Create a website on Khoroshop
169 USD
|
|||||
|
Development of the company website
496 USD
|
|||||
|
News parser from the website to Telegram
250 USD
|
|||||
|
Forwarding SMS messages to email or Telegram
68 USD
|
|||||
|
DEVELOPER OF TELEGRAM BOT
1128 USD
|
