Telegram Inventory Bot

A simple Telegram bot that helps manage inventory using Microsoft Excel. This bot allows users to add, update, remove, and view inventory items through Telegram commands.

Features

• Add items to inventory
• Update items (modify name, quantity, etc.)
• Remove items from inventory
• View all items in a report format
• Fetch details of a specific item
• Record stock usage
• Add stock quantity
• Generate various reports (stock summary, low stock, category-based, location-based, total inventory value, and transaction history)
• Excel Integration for easy data management

Bot - Commands

• /add – Add item
• /update – Update item
• /remove <ID> – Remove item
• /check <ID> – View item
• /report – View inventory
• /usestock – Record stock usage
• /stockadd – Add stock quantity
• /offlineadd <ID> <Name> <Category> "<Location>" <Quantity> <Price> "<Description>" – Add an item offline
• /reportstock – Stock Summary
• /reportlowstock – Low Stock Items
• /reportcategory – Items by Category
• /reportlocation – Items by Location
• /reportvalue – Total Inventory Value
• /historyreport – View stock transaction history

Requirements

• A secure Gmail account as the admin
• Basic knowledge of Google Spreadsheet

Installation

1. Clone this repository:

   git clone https://github.com/yourusername/telegram_bot_inventory.git
   cd telegram_bot_inventory

2. follow the step

How to Create a Telegram Bot with BotFather

1. Open Telegram and search for @BotFather.
2. Start a chat with BotFather and type:

   /newbot
   

3. Follow the instructions to set a name and username for your bot.
4. After completion, BotFather will provide a bot token. Save this token securely.
5. Use this token in your Python script to authenticate your bot.

Setting Up Google Apps Script for Spreadsheet Integration

Before deploying the script in Google Apps Script, make sure to update these three parts:

1. Replace the bot token:

   token = "TELEGRAM_TOKEN";

2. Replace the Web App URL:

   var webappurl = "YOUR_WEB_APP_URL";

3. Replace the Spreadsheet ID:
   • Find all occurrences of EXCELIDFROMSPREADSHEET and replace them with the new spreadsheet ID.
4. Follow Example of excel to build your spreadsheet. -At the USER Sheet you need to put ur telegram username in.

   ✅USERNAME
   ❌@USERNAME
   

License

This project is open source but requires permission before being posted or redistributed.