Qisqa zanjir sotuv (Short Supply Chain): Telegram bot orqali tuxum obuna modelini sozlash

Kontsept

Qisqa zanjir (farm → iste’molchi) sotuv modeli vositachilarni cheklab, fermerga yuqori marja va mijozga yangi mahsulot ta’minlaydi. Telegram bot – O‘zbekistonda keng tarqalgan (20 mln+ foydalanuvchi) bepul platforma boʻlib, avtomatlashtirilgan savdo va obuna (subscription) tizimi yaratishga imkon beradi.

Talablar

  • Telegram akkaunt (ferma nomi bilan).
  • BotFather orqali yaratilgan bot token.
  • VPS yoki Cloud Functions (Heroku, Railway) PHP/Python backend.
  • To‘lov protsessor: Click, Payme yoki Stripe (USD).
  • Google Sheets (yoki Airtable) buyurtmalar jadvali.

Arxitektura

Mijoz ↔ Telegram Bot API ↔ Webhook (Flask) ↔ Sheets DB ↔ To‘lov API
  • Bot → Webhook (HTTPS) → vazifa (obuna, buyurtma, balans).
  • Har payshanba 17:00 cron → «yakuniy tasdiq» → sheets → eksport (CSV) → logistika.

Bot funksiyalari

BuyruqVazifa
/startXush kelibsiz, tariflar izohi
/tariflar(A) 10 tuxum/hafta – 59 000 UZS
(B) 20 tuxum/hafta – 109 000 UZS
/buyurtmaTarifni tanlash → to‘lov tugmasi (Click/Payme)
/manzilGeo‑tag yoki matn manzilini saqlash
/statusObuna holati, yetkazish kuni
/helpAloqa, qayta savol

Inline keyboard va callback_data yordamida UX soddalashtiriladi.

Kod namunasi (Python Flask, pyTelegramBotAPI)

import telebot, os, requests
from flask import Flask, request
TOKEN = os.getenv('BOT_TOKEN')
bot = telebot.TeleBot(TOKEN)
app = Flask(__name__)

@bot.message_handler(commands=['start'])
def send_welcome(m):
    kb = telebot.types.InlineKeyboardMarkup()
    kb.add(telebot.types.InlineKeyboardButton('Tariflar',callback_data='plans'))
    bot.send_message(m.chat.id, 'Assalomu alaykum!...', reply_markup=kb)

@bot.callback_query_handler(func=lambda call: True)
def callback(call):
    if call.data == 'plans':
        kb = telebot.types.InlineKeyboardMarkup()
        kb.row_width = 1
        kb.add(telebot.types.InlineKeyboardButton('A – 10 tuxum', callback_data='planA'),
                telebot.types.InlineKeyboardButton('B – 20 tuxum', callback_data='planB'))
        bot.edit_message_text('Tarifni tanlang:', call.message.chat.id, call.message.message_id, reply_markup=kb)
    elif call.data.startswith('plan'):
        amt = 59000 if call.data=='planA' else 109000
        pay_url = f'https://my.click.uz/pay?amount={amt}&desc=Tuxum+obuna'
        kb = telebot.types.InlineKeyboardMarkup()
        kb.add(telebot.types.InlineKeyboardButton('Toʻlov', url=pay_url))
        bot.send_message(call.message.chat.id, f'Siz tanladingiz: {amt} UZS/hafta', reply_markup=kb)

@app.route(f'/{TOKEN}', methods=['POST'])
def webhook():
    bot.process_new_updates([telebot.types.Update.de_json(request.stream.read().decode('utf-8'))])
    return 'ok', 200

@app.route('/')
def index():
    return 'Bot ishlamoqda.'

if __name__ == '__main__':
    bot.remove_webhook()
    bot.set_webhook(url=f'https://<your-domain>/{TOKEN}')
    app.run()

Heroku Config Vars: BOT_TOKEN, CLICK_MERCHANT_ID.

Sheets integratsiyasi

  • Google Apps Script webhook: POST → JSON → Sheets.
  • Kolonkalar: chat_id, tarif, toʻlov_id, status, manzil, deliver_date.

Yetkazib berish logistikasi

  1. Dushanba — obuna ro‘yxati tasdiqlanadi.
  2. Chorshanba 18:00 — tuxum yig‘ish va saralash.
  3. Payshanba 07:00 — kur’er marshrut (Google Maps Optimize).
  4. 30 km radiusda yetkazish bepul; olis zonaga + 10 000 UZS.

Xavfsizlik va huquq

  • SSL (LetsEncrypt) webhook.
  • Click/Payme — 3‑D Secure.
  • Uzbekistan “Elektron tijorat to‘g‘risida” Qonun 6‑modda: foydalanuvchi ma’lumotini sir saqlash.
  • Refund siyosati: 24 soat ichida xabar → keyingi siklda kompensatsiya.

KPI va iqtisodiy model

Ko‘rsatkichQiymat
Tuxum o‘z tannarxi1 500 UZS/dona
Abonent A daromadi (10 dona)59 000 – 15 000 = 44 000 UZS
Abonent B daromadi109 000 – 30 000 = 79 000 UZS
100 abonent (50 A, 50 B)≈ 6,15 mln UZS/hafta

Bot xostingi (Heroku Hobby $7/mo), Click komissiya 1,2 %.

Xulosa

Telegram bot asosidagi tuxum obuna modeli kichik fermerga marketing byudjetisiz 100+ doimiy mijozni boshqarish, naqd pul oqimini barqarorlashtirish va yetkazib berishda juda qisqa zanjirga erishish imkonini beradi.

Savollar: digital@parrandachi.com | +998 90 190‑55‑59

Manbalar: Click UZ API docs v1.11; Telegram Bot API 6.9; USDA Direct Marketing Guide (2023); “Digital Ag Marketing” webinar, IT Park UZ (2024).

Добавить комментарий