Create a chat bot
Technical task: Telegram bot for procurement control and material accounting
Goal: Automation of the procurement process, strengthening of PTO control, photo documentation of deliveries, and accounting of materials from the Customer.
Implementation period: 10 days.
🏗 1. Role "Site Manager" (Data Submission)
Functionality for workers on the site.
1.1. Purchase request:
Selection of the site.
Entering the list of materials (Name, Quantity, Date needed by).
Status: "Under PTO review".
1.2. Receipt of materials (Photo report):
Selection of the active request (that has arrived).
Mandatory photo: (TTN, material, vehicle number).
Fact recording: What arrived, how much, is there any damage/defect.
Result: Instant notification to PTO.
1.3. Materials from the Customer (Consignment raw materials):
Separate menu block.
Input: Name, Quantity, Photo of the invoice/material.
Comment: "For which stage of work".
Status: "Awaiting PTO confirmation".
1.4. Weekly report (Write-off):
Submission of the act of material write-off for completed work for PTO verification.
👮♂️ 2. Role "PTO" (Control and Validation)
Central hub. No request proceeds without a button from PTO.
2.1. Processing purchase requests:
Sees new requests from Site Managers.
Actions:
✅ Approve (transferred to the Supply department).
✏️ Edit (change of quantity/nomenclature according to the estimate).
❌ Reject (with indication of the reason).
2.2. Control of receipt:
Receives photo report from the site.
Confirms accounting on the site balance.
2.3. Processing materials from the Customer:
Validates whether such materials have indeed been received from the customer.
Confirms the record (data falls into a separate tab of the table).
🚚 3. Role "Supply and Logistics" (Execution)
Only sees approved PTO requests.
3.1. Block "Procurement":
Sees the list of approved requests ("Need to buy").
Action: "Purchased / In stock".
After this action, the request disappears from the procurement list and goes to Logistics.
If the product is unavailable/price change — button "Return to PTO".
3.2. Block "Logistics" (Delivery):
Sees the list of materials that have already been purchased and are ready for shipment.
Action: "Sent to the site".
The Site Manager receives a notification: "A vehicle with [List] is on its way to you".
📊 4. Database (Google Tables)
All actions in the bot are automatically recorded in an online table in real time:
Requests: (Date, Site, PTO verdict, Procurement status).
Customer's warehouse: (Accounting of consignment raw materials).
Delivery archive: (Photos, Actual receipt).
Write-off: (Acts of Site Managers).
Work results
Client's review of cooperation with Dmytro Romanchuk
Create a chat botI am completely satisfied with the work. It was done very quickly and professionally.
Freelancer's review of cooperation with Alex R
Create a chat botEverything is great, the employer understands all the nuances and everything agreed upon is perfect.
-
Good day! I have experience in developing similar projects. I can implement everything quickly and efficiently! I have no questions about the technical specifications, so I can start working as early as this evening.
-
Good day. I will create a convenient menu structure, correct status logic, notifications between roles, and neat input forms. The deadline of 10 days is realistic; I complete everything on time and with quality, even earlier.
-
2264 18 3 Good evening. I am engaged in the development and configuration of Telegram bots. I have experience in developing bots for automating processes in enterprises, and I can develop a system for you as well. I would also like to draw your attention to the weak points:
- As a database, it would still be better to use SQLite/PostgreSQL (depending on scaling), and Google Tables only in read-only mode to avoid conflict situations and possible rate limits;
- It is better to upload photos to Google Drive (if quick access is needed), and work with a link to that photo in the table.
Write to me - we will discuss the details and I will immediately start working on it.
-
4602 51 1 Good day, I am a Python developer, I have experience in developing Telegram bots of various complexity, I also developed a similar bot but for logistics. I can complete your order. Write to me - we will discuss the details, I am ready to start today.
-
1455 8 0 Good day, I have experience working with Python as well as Telegram bots, I can complete everything quickly and efficiently, write to discuss the details.
Current freelance projects in the category Bot Development
BotTelegram bot for cryptocurrency exchange, the client needs to create a request, and the request should come to me in Telegram. Bot Development ∙ 1 hour 22 minutes back ∙ 43 proposals |
Development of a Telegram bot for a personal buyer service (MVP)Budget: up to 2200 USD Deadline: 4–6 weeksProject Description I am looking for an experienced Python developer to create an MVP Telegram bot for a personal buyer service (purchasing goods from Ukrainian and foreign stores). The project is designed for further scaling, so quality… Bot Development ∙ 19 hours 7 minutes back ∙ 52 proposals |
Telegram chatbot for a closed club
22 USD
Good day! I need to set up a bot for Telegram. Task: selling access to a closed channel. The bot should accept payments and after successful payment, issue a one-time invitation link. It is also necessary to set up automatic removal of a participant from the channel when their… Bot Development ∙ 1 day 2 hours back ∙ 81 proposals |
Mini apps Telegram. StoreGood afternoon An application is required in Telegram (online store) Example - essentially 1 to 1 like here brandspacebot Your experience is important, the stack you propose to use and why Price and timeframe approximately to start, I will be waiting for questions Web Programming, Bot Development ∙ 1 day 5 hours back ∙ 80 proposals |
Bots"I am looking for a programmer to create a turnkey Telegram bot. The bot should be an intelligent conversationalist based on AI (Gemini or ChatGPT), helping people on any topic and in any language. Payment (Monobank or LiqPay) for subscription needs to be integrated as well. I… Bot Development ∙ 1 day 13 hours back ∙ 58 proposals |