Freelance projects

Freelance projects

Telegram bot for receiving orders from sales managers

Bot Development, Python — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

Create a Telegram bot for automating order processing by sales managers, facilitating logistics work, reducing the number of errors, and simplifying data collection for invoicing. The bot should ensure transparency in the process, control the order queue, integrate with the product database and "Nova Poshta" addresses, support urgent orders, and work with additional scenarios (for example, orders via screenshots).

2. Functional Capabilities

2.1 Order Reception

Managers enter orders through the bot using a standardized form.
Data collected by the bot:
1. Product name.
2. Product quantity.
3. Product code.
4. Client's full name.
5. Contact phone number.
6. Delivery address (branch of "Nova Poshta" or exact address).
7. Payment type ("cash on delivery" or "paid").
8. Additional comments (if necessary).

2.2 Order Reception via Screenshots

The manager sends a screenshot with the order.
The bot runs OCR (optical character recognition), checks for the necessary data, and offers to confirm it.
If OCR cannot read the data, the bot asks the manager to enter the necessary information manually.

2.3 Inventory Control

Before confirming the order, the bot checks the availability of the product by code in the product database.
If there is insufficient product:
- The bot informs the manager of the available quantity and suggests adjusting the order.

2.4 Working Time Control

Outside working hours (after 5:00 PM on weekdays, after 2:00 PM on Saturday):
- Orders are accepted, but the bot automatically adds a comment:
```
Copy code⚠️ This order was entered outside working hours and will be processed on the next working day.
```
- Logistics receives a queue list for the morning of the next working day.
- The manager receives a confirmation indicating the processing time.
Urgent Orders:
- The manager enters the command /urgent_order, the bot asks for the reason for urgency.
- The order is sent with the "Urgent" label to the logistics Telegram group.

2.5 Invoice Generation

For legal entities/entrepreneurs:
- Data collection:
  - Company/entrepreneur name.
  - EDRPOU/Tax ID code.
  - Delivery address of the product.
  - Delivery address of documents.
  - Contact person and phone.
- Data is stored in the database for reuse.
- The bot generates the invoice text in a standardized format.

2.6 Sending Orders to the Group

A standardized order text is sent to the Telegram group for logistics, including:
- Manager data (name, Telegram nickname).
- Order details (product, quantity, address, payment type).
- Order entry time.
- Working time mark (if outside schedule).

2.7 Automatic Delivery Calculation

Integration with the "Nova Poshta" API for calculating the estimated delivery cost.

2.8 Duplicate Check

Before sending the order, the bot checks for similar orders by full name and phone number.
If duplicates are found, the bot asks for the manager's confirmation.

2.9 Templates for Regular Clients

Managers can create templates for quick order processing.
When using a template, the bot fills in the saved client data.

2.10 Reporting

For managers:
- Weekly and monthly reports on the number of orders, errors, out-of-hours orders.
- Data on the performance of each manager.
For logistics:
- Daily list of morning tasks.

3. Technical Requirements

3.1 Programming Language

Python (python-telegram-bot) or Node.js.

3.2 Integrations

Google Sheets/PostgreSQL: for the product and client database.
"Nova Poshta" API: for address verification and delivery calculation.
OCR services (Tesseract/Google Vision): for text recognition on screenshots.
CRM systems: integration via API.

3.3 Hosting

Heroku, AWS Lambda, or another server.

4. Interface

Commands for the manager:
- /new_order — create a new order.
- /new_order_screenshot — order via screenshot.
- /urgent_order — urgent order.
- /template_customer — use client template.
- /invoice — issue an invoice.
- /stats — view statistics.
Commands for managers:
- /daily_report — get a daily report.
- /weekly_report — get a weekly report.
- / — get a monthly report.

5. Message Examples

Order Outside Working Hours

In the logistics group:

yamlCopy codeOrder from the manager: 
---
Product name: Autonomous diesel heater Profinstrument M-2000 (12V, 2 kW)
Quantity: x1
Product code: 5021091
Cost: 5999₴
Client's full name: 
Contact: 
Address: 
Payment type: cash on delivery
---
⚠️ This order was entered outside working hours and will be processed on 06.12.2023.

Proposals 20

Olksandr Kazarov

3 1

Projects 3
Rating -
Rating 449

Budget: 19000 UAH Deadline: 4 days

To implement this Telegram bot, I propose the following approach:

What I propose:
Development of a functional Telegram bot:

Creation of bots for sales managers, logistics, and executives with the ability to use commands to manage orders.
Intuitive interface for quick data entry and processing.
Integration with systems:

Connection to the product database via Google Sheets or PostgreSQL.
Integration with the "Nova Poshta" API for address verification, delivery calculation, and obtaining data about branches.
Use of OCR for automatic text reading from order screenshots.
Connection to CRM via API (if available).
Process control:

Automatic calculation of stock levels.
Detection of duplicate orders by phone number or client’s full name.
Order notifications outside of working hours.
Automation of invoice creation:

Generation of invoices for legal entities in a standardized text format.
Data storage for reuse.
Reporting:

Generation of reports for executives and logistics with detailed analytics (daily, weekly, monthly).
Development stages:
Planning:

Analysis of client requirements.
Setting up integrations with the "Nova Poshta" API, OCR services, and databases.
Function development:

Commands for managers: creation, editing, urgent orders.
Commands for executives: reports, analytics.
Data export to Telegram logistics groups.
Testing:

Unit tests to check core functionality.
Integration testing with the database and API.
Deployment:

Hosting on Heroku/AWS or another server.
Setting up logging and backup.
Technologies:
Programming language: Python (python-telegram-bot) or Node.js.
Database: PostgreSQL/Google Sheets.
Integrations:
"Nova Poshta" API.
OCR services (Tesseract/Google Vision).
CRM via API (if needed).
Hosting: AWS, Heroku, DigitalOcean.

Benefits of collaboration:
Experience in developing Telegram bots with database integration, APIs, and process automation.
Guarantee of process transparency and regular reports on completed work.
Post-implementation support for necessary improvements.
I would be happy to discuss the details and start working!

Maksym Sokolskyi

24 0

Projects 24
Rating -
Rating 3 853

Budget: 16000 UAH Deadline: 1 day

Hello,

I am ready to take on the development of a Telegram bot for automating order processing by sales managers. My experience includes developing bots to facilitate logistics work, managing order queues, integrating with product databases and delivery services.

My team and I can ensure the creation of a bot that will accept orders through a standardized form and send them to the logistics group. The bot will also support order acceptance through screenshots, inventory control, and automatic delivery calculation via the "Nova Poshta" API.

My rate is $16 per hour.

I look forward to the opportunity to collaborate.

Best regards,
Maxim

Kyrylo Hetman

0 0

Projects -
Rating -
Rating 217

Budget: 27000 UAH Deadline: 5 days

Good day!

I am ready to complete your project in a short time.
I have extensive experience in developing both commercial and personal Telegram bots, and I can provide links upon request.

I look forward to collaborating.

Diana Zalevska

1 0

Projects -
Rating -
Rating 330

Budget: 20000 UAH Deadline: 30 days

Good day, I am interested in your project. I have experience in developing bots in Python and working with databases.

Yurii S.

11 0

Projects 11
Rating -
Rating 2 198

Budget: 27000 UAH Deadline: 77 days

Good day, I am interested in your project and ready to discuss and implement it! I have been in web development for over 15 years and have extensive experience in writing various Telegram bots and Telegram mini-apps. Write to me - I will be glad to cooperate!

Nick Osipov

41 4

Budget: 27000 UAH Deadline: 7 days

We professionally develop Telegram bots in Python (Aiogram3), installation, DevOps + further support

Write to me in private messages, we will discuss all the bot's logic

Example of a similar functional bot:
https://freelancehunt.com/project/otc-bot/1355327.html

Andrey K.

1 282 1

Budget: 27000 UAH Deadline: 7 days

Hello. I have extensive experience in developing Telegram bots. I am ready for collaboration.

Nikita Chaus

13 0

Budget: 10000 UAH Deadline: 6 days

Hello, I have confident experience with Telegram bots, I will complete your task without any problems.
To ensure the required functionality, I will integrate:
Google Sheets or PostgreSQL: for storing data about products, customers, orders.
API of "Nova Poshta": for checking addresses, calculating delivery costs, checking the availability of branches.
Tesseract: for processing orders through screenshots.

Yehor I.

84 0

Budget: 8000 UAH Deadline: 10 days

Ready to take it on.
But we need to clarify the order details, write!
I will implement it with a script in python+aiogram3+pgsql/sqlite.

Vitalii Shevtsov

5 2

Budget: 27000 UAH Deadline: 7 days

There is experience in developing similar bots on python/Django and python-telegram-bot. The advantage of Django is that there is a convenient admin panel for managing employee access rights. Convenient viewing and searching of data.

Authorization in the work by username and chat_id (a password can also be added for reliability) - these are specified in the admin panel when adding a manager, and access to the bot can also be restricted at any time;

2.1 – 2.4 – everything is clear, no problems;
2.6 - simple sending of requests to a private group of employees? We can also manage employee roles (manager, logistician) in the admin panel, and each has their own access rights;
2.7 – 2.8 – everything is clear, no problems;
2.9 - I suggest adding templates in the admin panel, this will save a lot of time on development;
2.10 - can be viewed in the admin panel (more convenient in the form of tables or graphs with search and sorting). In the bot, there will simply be a text list;
3.1 – 5 – everything is clear, no problems.

Oleksandr Stinkovyi

117 0

Budget: 14000 UAH Deadline: 7 days

Hello!

I am developing bots for Telegram using NodeJS. I am ready to take it on. Write to me, we will discuss.

Artem Albovsky

9 0

Budget: 9000 UAH Deadline: 15 days

Ready to write such a bot for you on NodeJs. Contact me in private messages.

Mikita Linnyk

19 0

Budget: 12000 UAH Deadline: 5 days

Good day! I am ready to develop a turnkey Telegram bot for you. I will implement all the listed tasks. The cost and deadlines are approximate.

Serhii Stovbik
Chernovtsy, Ukraine

Projects 5
Rating -
Rating 469

Telegram bot for receiving orders from sales managers

2. Functional Capabilities

2.1 Order Reception

2.2 Order Reception via Screenshots

2.3 Inventory Control

2.4 Working Time Control

2.5 Invoice Generation

2.6 Sending Orders to the Group

2.7 Automatic Delivery Calculation

2.8 Duplicate Check

2.9 Templates for Regular Clients

2.10 Reporting

3. Technical Requirements

3.1 Programming Language

3.2 Integrations

3.3 Hosting

4. Interface

5. Message Examples

Order Outside Working Hours

Olksandr Kazarov

Maksym Sokolskyi

Kyrylo Hetman

Diana Zalevska

Yurii S.

Nick Osipov

Andrey K.

Nikita Chaus

Yehor I.

Vitalii Shevtsov

Oleksandr Stinkovyi

Artem Albovsky

Mikita Linnyk

Proposals concealed

Proposals are currently absent

Current freelance projects in the category Bot Development

Creation of a bot

Deploy a Node.js Telegram bot on a VPS using Docker.

Parser with output result in TG bot

Development of a Telegram Mini App (store) with CRM integration and Nova Poshta.

Improvement and restoration of the existing bot's functionality