Automation for e-commerce

Budget: 5700 UAH Deadline: 7 days

😀 Hello!
I have extensive experience in developing automation with Python, integrating REST APIs, working with SQLite, and Telegram bots.

🛠 How I will do it:
1. I will set up automatic data retrieval through the KeyCRM API and Rozetka API, saving it in SQLite on your Linux VPS.
2. I will implement the calculation of average sales, stock in days, reorder point, and ABC analysis, extracting all parameters into a convenient configuration.
3. I will connect Telegram notifications with a formatted report and set up daily execution via cron.

🎥 Portfolio: Freelancehunt

I would be happy to discuss the details in private messages and get started right away! Expand

Budget: 6000 UAH Deadline: 3 days

Hello.

I can create such a system for you. Write to me, and we will discuss.

Budget: 18000 UAH Deadline: 7 days

I can take on a small but normal engineering phase - approximately 18,000 UAH and 7 working days for the first working version.

I would do this as a separate stable service on a VPS - data collection from KeyCRM and Rozetka, storage in SQLite, calculation of sales speed, stock in days, reorder point, ABC priority, and daily sending to Telegram. n8n can be used for orchestration, but the calculation logic itself is better kept in code to avoid getting a fragile scheme with a bunch of nodes.

Two things need clarification:
> whether there is access to the Rozetka API, or if stock will be through regular exports
> whether SKUs in KeyCRM and Rozetka match, or if a mapping table is needed

From our experience, similar types of tasks:
> https://business.ingello.com/prime-eva - e-commerce and operations automation
> https://business.ingello.com/eva - retail, data, processes, and system logic
> https://business.ingello.com/forma-crm - CRM and internal automation

The main page of Ingello Systems for the exchange - https://systems-fl.ingello.com/ua

After access to KeyCRM, Rozetka, VPS, and the Telegram bot, the first version can be quickly assembled. Look, there's a nuance here - the most important thing is not just to send a message, but to correctly calculate the recommended order, otherwise the automation will make beautiful mistakes =/ Expand

Budget: 6000 UAH Deadline: 5 days

Kyril, I will collect data specifically on n8n, as indicated in the technical specification: KeyCRM → Rozetka → SQLite on your Contabo → daily calculation → Telegram report. I do not suggest replacing the stack unnecessarily.

The key point in this task is not the cron itself, but the correct mapping of SKUs between KeyCRM and Rozetka. First, I will establish a matching rule by article / external ID, so that sales and stocks belong to the same product. Otherwise, the system may confidently recommend purchasing the wrong items.

What will result:
— daily collection of order history from KeyCRM and stocks from Rozetka via API or export;
— SQLite database on your VPS: history of launches, data, and calculations;
— calculation of average sales for the selected period, stock in days, and reorder point;
— recommended quantity for purchase considering lead time, safety, and target stock;
— ABC classification by revenue, so that critical class A items are shown first in Telegram;
— a separate message for critical stock and a clear daily report;
— all thresholds will be moved to the config so they can be changed without reworking the workflow;
— cron, error log, restart, and a brief instruction.

I already have a 24/7 monitoring system running on VPS: it regularly receives external data, stores history, controls duplicates, and sends technical and operational messages to Telegram. I will apply the same proven logic for controlling launches and errors here.

The cost for the entire described scope is 6,000 UAH. The term is up to 5 days, including deployment on Contabo, testing with real SKUs, and providing instructions.

To start, two points need clarification: does Rozetka already have API access to stocks or are we working with regular exports, and do the product articles in KeyCRM and Rozetka match? Expand

Budget: 5700 UAH Deadline: 3 days

Good day. I will start right away, and on the first working day, I will prepare the data flow diagram and the SKU mapping between KeyCRM and Rozetka. I will gather everything in SQLite on Contabo, add inventory calculations, ABC analysis, and Telegram recommendations, set up a cron job, and configure the thresholds. The final result will be ready in 3 days, and the cost is 5700 UAH. Will there be an available API for Rozetka, or are we working through data exports?

Budget: 6000 UAH Deadline: 3 days

Hello! I am ready to implement this automation. I have experience working with n8n, Python, APIs (KeyCRM, Rozetka), and Telegram bots on Linux servers (VPS/Contabo).

What I will do:
1. Set up data collection via the KeyCRM and Rozetka APIs.
2. Organize data storage and caching in SQLite.
3. Implement the logic for calculating sales velocity, ABC analysis, and determining the reorder point based on your parameters in the config.
4. Connect daily execution via cron and send reports to the Telegram bot.

I am ready to discuss the details and start working.

Budget: 6000 UAH Deadline: 3 days

Hello! I am ready to quickly assemble this analytical system. I have experience working with the API KeyCRM and Rozetka, as well as setting up server infrastructure on Linux VPS. I propose the following architecture: the n8n workflow on a schedule (cron) will retrieve sales history and current stock levels, record them in a local SQLite database on your Contabo server, and then perform calculations. All formulas (sales velocity, ABC analysis, reorder point) and variables from the config (safety stock, lead times) will be embedded in the script logic so that the system clearly prioritizes class A products. At the final stage, the bot will generate a structured report (as in your screenshot) with critical stock levels and send it to Telegram. I would be happy to discuss the details and start the setup right away!

Budget: 8000 UAH Deadline: 5 days

Good day, Kyrylo!

The task is clear. Regarding calculations (sales velocity, days of stock, reorder point, ABC) — this is the simple part. The main engineering challenge is to correctly map products between KeyCRM (orders) and Rozetka (inventory) by SKU — if the mapping is inaccurate, the system will recommend purchasing the wrong items.

My approach:
• First, I will fix the SKU mapping between the systems — a test run on 5-10 products, so you can see that the calculation is correct before launching it for the entire assortment.
• Python script (without n8n) — fetching KeyCRM API + Rozetka (API or export if the API is limited), saving to SQLite on your VPS.
• Calculation of sales velocity, days of stock, reorder point + ABC classification by revenue.
• Daily Telegram report via cron, class A — first.
• All thresholds (lead time, safety/target stock) — in a separate config, you can change without my involvement.

n8n is a possible option here, but for one daily task, maintaining a separate n8n instance on VPS is unnecessary infrastructure. A simple Python script on cron is easier to debug and modify.

To estimate more accurately, please let me know:
1) Do the items/SKUs between KeyCRM and Rozetka match one-to-one, or is mapping needed?
2) Is there access to the Rozetka API, or are stocks only available through export?
3) What is the approximate volume of SKUs in the assortment?

I am ready to discuss the details! Expand

Budget: 6000 UAH Deadline: 4 days

Good day, Kyrylo.

I will gather the scenario in n8n: KeyCRM and Rozetka → product normalization → SQLite on Contabo → daily calculation → Telegram report in a format close to your example.

The key nuance is not to overstate sales speed due to canceled and returned orders. I will save daily snapshots and make the re-run idempotent so that one day does not appear in the statistics twice. I will move the thresholds, calculation period, lead time, and safety stock to the configuration.

To start, I need to clarify whether the items in KeyCRM and Rozetka match and whether the Rozetka API is available, or if we are working through exports.

Budget: 6000 UAH Deadline: 3 days

Hello!

I have reviewed your task on e-commerce automation and am ready to implement this project. I have experience with parsing, integrating various APIs, and automating business processes in Python.

Budget: 5700 UAH Deadline: 3 days

Kirill, such systems do not break down on calculations — ABC analysis and stock in days are calculated trivially. The real problem is that sales from KeyCRM and stocks from Rozetka clash on different items, and if the mapping is inaccurate, the bot will recommend purchasing the wrong products every day.

I am working through Safe. First, I will gather the mapping and run one test with 5-10 products — you will see that the calculation is correct, then we will launch the full assortment via cron on Contabo.

An important question: do the items match one-to-one between KeyCRM and Rozetka, or is matching by names or internal IDs needed?

Budget: 6000 UAH Deadline: 3 days

Hello, I have extensive experience in integrations.
Message me privately.
I will be happy to help you!

Budget: 18000 UAH Deadline: 7 days

We already have a practically ready base for such automation - it can be quickly adapted for KeyCRM, Rozetka, SQLite on VPS, and Telegram notifications ))

In terms of timelines, I would estimate 5-7 days for a working version with daily launches, configuration of thresholds, calculation of sales speed, stock in days, recommended reorder quantity, and ABC prioritization.

An important nuance - a budget of 6000 UAH seems realistic only for a very trimmed first stage without full API verification and a backup scenario through export. For a normal implementation with logs, error handling, cron, deployment on Contabo, and a test run, I would aim for 18000 UAH.

> What we will do
> Connect KeyCRM API for order history
> Connect Rozetka API or import export if the API is limited
> Store data in SQLite on VPS
> Add calculations for average sales, days of stock, reorder point, and recommended quantity
> Set up a Telegram bot with daily reports and prioritization of A-class products

What we will need from you - access to KeyCRM, Rozetka, VPS Contabo, Telegram bot token, and an example of 5-10 products for control verification of calculations.

I would like to clarify two points:
> Does Rozetka provide stock through the API or is a file export planned now?
> Do we calculate the recommended order volume from the target stock in days or from the minimum reorder point plus safety stock?

Relevant examples from Ingello:
> https://business.ingello.com/eva - e-commerce and systematic work with product processes
> https://business.ingello.com/forma-bpm - automation of business processes and regulatory notifications
> https://business.ingello.com/vorfahr - an example of automation with an AI approach and integrations

Main page for the exchange - https://systems-fl.ingello.com/ua

In touch, we can go through the API and quickly determine whether we are doing a full version or a compact first stage without unnecessary heroics =) Expand

Budget: 6000 UAH Deadline: 2 days

Good day!

I will do it turnkey: KeyCRM + Rozetka → SQLite on your VPS → daily calculation of sales speed, stock in days, and reorder point → Telegram report via cron. ABC class is calculated together with the rest, thresholds (lead time, safety stock, target) — in the config, you can change it without me.

This stack works for me in production every day: Python, SQLite, cron jobs, Telegram notifications. One of my projects is a service for e-commerce that processes catalogs with thousands of items.

Budget: 10000 UAH Deadline: 5 days

Good day
I have extensive experience in developing similar projects
Write to me

Budget: 6000 UAH Deadline: 2 days

Good day! I have experience = ready to implement such a system!!!
Feel free to contact me!!!

Budget: 6000 UAH Deadline: 3 days

Hello!

I will complete the project in 3 days turnkey. Invest this 6,000 UAH once — and the system will start saving you a lot of time daily and protect you from sales drops due to empty warehouses.

The logic of ABC analysis, working with API KeyCRM/Rozetka, SQLite, and generating reports in Telegram strictly according to your screenshot — I will do everything precisely. The cron job on your Contabo VPS is also on me.

Let me know if the API keys are ready for testing? I am ready to start working!

Budget: 6000 UAH Deadline: 3 days

Hello, Kyrylo! I have reviewed your technical task regarding the automation of warehouse analytics. I am ready to implement this system in Python perfectly, stably, and completely "turnkey."

I am a Fullstack developer specializing in asynchronous development, working with databases, and system automation (stack: Python, asyncio, SQLite). I have extensive experience in setting up scripts on Linux (Ubuntu) VPS.

I will accomplish your task according to the following clear engineering plan:
1. API Integration: I will set up a stable asynchronous data retrieval of order history through the KeyCRM API and stock/orders from the Rozetka API.
2. SQLite Database Design: I will create a clean structure of a relational database on your Contabo VPS to store history and quickly calculate the delta of stocks.
3. Analytics Logic and ABC Analysis: I will write clean algorithms to calculate average sales velocity, stock in days, and reorder points. I will implement prioritization of products by A/B/C classes based on revenue.
4. Threshold Configuration: I will extract all variables (lead times, safety, and target stocks) into a separate convenient config file (.env / JSON), so you can change them without editing the code.
5. Automation via Cron and Telegram Bot: I will set up a daily launch of the analytical script via cron on Linux, which will generate a beautiful structured report once a day and send it to your Telegram bot.

Budget: 6000 UAH Deadline: 3 days

Good day!

I have experience with PHP/Python, REST API, Linux servers, cron, Telegram bots, and business process automation.

I can implement a system in n8n with:

* receiving orders from KeyCRM;
* uploading stock and orders from Rozetka via API or file;
* storing and updating data in SQLite;
* calculating sales velocity, stock in days, and recommended purchase volume;
* ABC analysis of products by revenue;
* daily Telegram notifications;
* configuring lead time, safety stock, and target stock;
* logging errors and retrying on API failures.

I will deploy the solution on your Contabo VPS and provide the n8n workflow and documentation.

Preliminary estimate: 5000-6000 UAH, timeline - 2-3 days. I will be able to confirm the final cost after reviewing the data structure of KeyCRM and Rozetka. Expand

Budget: 6000 UAH Deadline: 4 days

I will complete the task using Python and aiogram for a Telegram bot. I will develop a script to collect data from the KeyCRM and Rozetka APIs, process it according to your requirements (average sales, stock, ABC analysis), and save it in SQLite. Running via cron will ensure daily notifications.

Write to me, and we will discuss everything in detail, and I can start working immediately.

Portfolio: Freelancehunt
Reviews: Freelancehunt

Budget: 6000 UAH Deadline: 7 days

Hello!

The task is clear and fully aligns with my expertise: Python automation, REST API, SQLite, Telegram bots, and working with Linux/VPS.

I propose to implement an MVP:

— retrieving order history from the KeyCRM API;
— uploading stock and orders from Rozetka via API or available export;
— normalizing and storing data in SQLite;
— calculating average sales velocity, stock in days, reorder point, and recommended volume;
— ABC analysis of products by revenue;
— daily Telegram notification about products that need restocking;
— running on your VPS via cron or n8n;
— configuring lead time, safety stock, and target stock through configuration.

I suggest implementing the main integration and calculation logic in Python, while using n8n or cron for daily execution.

Before starting, I need to clarify:
1. Is there access to the KeyCRM and Rozetka APIs?
2. If the Rozetka API is unavailable, what export format is used?
3. Do the SKUs/articles match in KeyCRM and Rozetka?
4. For what period should average sales and ABC analysis be calculated?
5. Is n8n a mandatory requirement?

Cost — 6,000 UAH.
Deadline — up to 7 calendar days after receiving access and sample data.

After completion, I will provide a brief setup and launch instruction. Expand

Budget: 12000 UAH Deadline: 9 days

You need not just a daily report, but inventory control to avoid losing sales due to shortages and not to tie up money in slow-moving goods.

I will set up a scenario in n8n on your VPS: it will daily fetch order history from KeyCRM and stock data from Rozetka, store them in SQLite, and calculate average sales, stock in days, reorder point, and recommended purchase volume. A structured message will be sent to Telegram prioritized by ABC analysis, so the analyst sees class A items and critical positions first. I will move the thresholds for lead time, safety stock, and target stock into the configuration so they can be changed without reworking the logic.

What is the current average SKU volume in your assortment and how often do you encounter stockouts of fast-moving goods?

Budget: 6000 UAH Deadline: 3 days

Hello! The task is clear, I can implement such automation on n8n with deployment on your VPS.

Work plan:

— obtaining order history from KeyCRM API;
— obtaining current stock levels and orders from Rozetka API or through regular file uploads;
— saving and updating data in SQLite;
— calculating the average sales velocity for each SKU;
— determining how many days the current stock will last;
— calculating the reorder point and recommended quantity of goods;
— ABC analysis by revenue for prioritizing products;
— daily report in Telegram in a convenient format;
— extracting lead time, safety stock, and target stock into configuration;
— logging errors and monitoring successful execution of the script.

The main workflow can be built in n8n, and more complex calculations can be moved to a separate Python module or executed through Code Node if needed.

I specialize in developing Telegram bots, API integrations, and automating business processes. I have implemented bots and internal systems for a private clinic, as well as for the Astara platform — with scenarios, databases, payments, automated messages, and user interactions.

For an accurate estimate, it will be necessary to review the documentation and available methods of KeyCRM and Rozetka APIs, as well as clarify the formula for recommended restocking and the desired format of the Telegram report. Expand

Budget: 6000 UAH Deadline: 4 days

Good day!
I am ready to create an auto-notification system for stock replenishment with analytics.
I will do:

Daily calculation of sales velocity for each product
Calculation of remaining stock in days and ordering recommendations
ABC analysis
Sending reports to Telegram
Data storage and scheduled execution

Budget: 6000 UAH Deadline: 7 days

Hello! I am ready to implement the automation of inventory tracking and daily Telegram notifications. I work with Python, API, SQLite. Before starting, I will clarify the access to KeyCRM and the method of obtaining data from Rozetka.

Budget: 6000 UAH Deadline: 3 days

SQLite on VPS is a reliable foundation for storing sales history and inventory without dependence on cloud services. I will create a Python script that will daily fetch data from the KeyCRM API and Rozetka, calculate average sales and stock in days, perform ABC analysis based on revenue, and then send recommendations via Telegram through a cron job — all thresholds will be in the config for easy adjustment. I offer 2 weeks of free code support after delivery to ensure that synchronization works smoothly. I am ready to start.

Budget: 6000 UAH Deadline: 5 days

I have reviewed the task, and it is clear what is needed: automation on n8n that calculates the sales velocity for each product once a day (based on data from KeyCRM and Rozetka), determines the reorder point and recommended quantity, performs an ABC analysis for restocking priority, and sends everything to Telegram.

What I will do:

Set up data retrieval from the KeyCRM API (order history) and Rozetka (inventory/orders)
Store data in SQLite on your VPS (Contabo)
Calculate average sales, days of stock, and reorder point
Perform ABC analysis for restocking prioritization (class A first)
Daily sending to the Telegram bot via cron in n8n
All thresholds (lead time, safety stock, target stock) will be moved to a separate config so you can change them independently without interfering with the logic

Budget: 5700 UAH Deadline: 3 days

Good day, Kyrylo!

I understand the task: daily calculation of sales speed via KeyCRM + stock from Rozetka, ABC analysis, and notifications in Telegram that it's time to order.

You are focusing on n8n, but I want to suggest an alternative: a pure Python script on cron instead of n8n. The task is essentially the same pattern I have already implemented in bots with a scheduler/notifications: data collection via API, calculations, saving in SQLite, daily execution via cron, and sending to Telegram.

Why this might be better than n8n for your case:
- One simple script without a chain of nodes — easier to debug and change the calculation logic
- All thresholds (delivery time, safety stock, target stock) — in one config file, not scattered across nodes
- No need to maintain a separate n8n instance on VPS for just one daily task

If it is fundamentally important for you to use n8n (for example, to edit the flow visually on your own) — I can do it on n8n as well; both options fit within the same budget and timeline.

A couple of clarifying questions:
1. Do you already have access to the Rozetka API, or do you only get stock through file exports?
2. Are there ready API keys for KeyCRM?
3. Is it fundamentally important to use n8n, or is the main thing that the system works stably?

I am ready to start after your responses. Expand

Budget: 6000 UAH Deadline: 2 days

Hello!

I am ready to implement an auto-notification system and ABC analysis on n8n. The logic of operation is clear, and the stack (KeyCRM + Rozetka -> SQLite on your VPS -> Telegram) is fully suitable for this task.

The estimated cost of implementation is (6000 UAH) and the completion time is 2 days.

To confirm the estimate and start working, please clarify a few technical details:

1. Access to Rozetka: Do you already have direct access to their API (tokens) for obtaining current stock levels, or is it planned to retrieve data through periodic file exports (XML/CSV)?
2. Configuration management: You mentioned that all thresholds will be in the "config". Would it be convenient for you to change these values directly in the file on the Linux server, or is it better to move the threshold settings to Google Sheets? The second option is usually more convenient for e-commerce: you can change the safety stock in two clicks without server access.

3. Data volume: Please provide an approximate number of active products (SKUs) that the script will process each day? This is important for considering API request limits.

I would be happy to discuss the details and start the setup! Expand

Budget: 6000 UAH Deadline: 7 days

I read the brief carefully, the task is clear. Automation of warehouse analytics for e-commerce with KeyCRM and Rozetka, SQLite on VPS, ABC analysis, and a daily Telegram bot via cron. Nothing excessive, everything is to the point.

I have about 3.5 years of commercial experience, part of which is in B2B e-commerce: API integrations, order processing, sales calculations. I have written similar things in TypeScript and Node.js, storing data in relational databases. SQLite is perfect for this scale, I know the KeyCRM API, and I will quickly figure out Rozetka.

Regarding implementation: calculating the average sales for selected days, stock in days, reorder point, and ABC classification by revenue can be handled by one daily script. Thresholds (lead time, safety stock) are in a config file, cron triggers it, and the Telegram bot sends a summary. I will make the code clean and understandable so you can adjust the thresholds yourself without the help of a developer.

I am ready to discuss the details and start soon.

Budget: 6000 UAH Deadline: 1 day

Good day. For the implementation of the auto-notification system, I propose a modular architecture that will ensure reliable data integration with KeyCRM and Rozetka API, efficient computations, and secure storage in SQLite on your VPS. I will implement ABC analysis mechanisms for order prioritization and a flexible threshold configuration system that will allow precise adaptation of the logic to your business processes while maintaining high processing speed. I have successful experience in developing similar automation systems and ready-made solutions for the quick deployment of such integrations and Telegram bots. I suggest discussing all implementation details, final budget, and timelines in private messages.

Budget: 6000 UAH Deadline: 3 days

I noticed that the data comes from two sources: KeyCRM for orders and Rozetka for stock, so it's important to correctly reconcile the items between the systems before the calculation.

I will do it on n8n: a daily flow for data retrieval, storage in SQLite on your Contabo, calculation of average sales and reorder point, ABC classification by revenue, and a message in Telegram with the recommended purchase volume. I will move the supply thresholds and safety stock into the configuration.

Approximately 3 days. Please let me know if there is already access to the Rozetka API, or if the data from there is only through exports?

Budget: 6000 UAH Deadline: 3 days

Hello 👋
I have reviewed the task 👀 It can be done more easily without n8n.
Write to me, and we will discuss the project details!

Example: https://sushi-drive.mk.ua
https://ealcoach.com
https://ms.mk.ua

----------------------------------
Development of Wordpress / OpenCart websites and AI automation.

Budget: 6000 UAH Deadline: 5 days

Hello! I can help with automation for e-commerce, including API integration and creating a Telegram bot for notifications. I have experience with databases and calculations. I am ready to discuss the details.

Budget: 6000 UAH Deadline: 7 days

Good day, Kirill!

To automate notifications about stock replenishment, it is important to have a clear understanding of your business and the specifics of the products. I have experience in developing systems that integrate APIs, process data, and automate processes, which will help optimize your inventory.

To develop an effective strategy, we first need to study your data: sales volume, product stock, as well as the specifics of the API KeyCRM and Rozetka. I propose the following work plan:
1. I will familiarize myself with your data and API.
2. We will identify key products for automating notifications.
3. I will conduct an analysis and provide an implementation plan.

The preliminary cost of my services is from $400 per month. Achieving results may take from 2 to 4 months, depending on the complexity of the integration and the volume of data.

In my profile, you will find examples of completed projects that demonstrate my skills in automation and data analysis.

I suggest discussing the details of your project in private messages to define the goals and action plan. Expand

Budget: 6000 UAH Deadline: 3 days

The idea is clear: to calculate the sales speed of products daily using KeyCRM and Rozetka, perform ABC analysis, and send recommendations on what to order via Telegram.

I will implement it on n8n: SQLite on Contabo VPS, with stock in days and reorder point, thresholds in the configuration.

Ready in 3 days. Rozetka: API or file export?

Budget: 6000 UAH Deadline: 5 days

Kirill, it seems you need a stable inventory control system to avoid losing profit due to empty shelves. The task involves properly processing data from KeyCRM and Rozetka for timely procurement forecasting.

I will set up a script that will collect current stock levels and sales history, conduct ABC analysis, and provide a report in Telegram in a format convenient for you. All parameters for calculations will be moved to a separate config so you can adjust them for seasonality without interfering with the code.

Do you already have API keys for KeyCRM and the Rozetka cabinet, or will we need to figure out the access specifics?