ACI Edulink
Powering Automation with AI
↗ Report Hub 01 / 12
Stationery Division AI Operations Review · 2026

Powering Automation
with AI

How ACI Edulink is solving real operations challenges.

📊 5 Live Dashboards ⚡ Telegram Automation Built In-House
Where We Started

Real Problems, at Scale

🧾
No Digital Proof at Point of Sale

Field and spot sales happened without any digital invoice or authenticity record — customers had no formal proof of the discounts or transactions they received.

📦
Stock Visibility Across 340+ SKUs

Mismatches between records and field reality. The FF and corporate teams struggled to quickly verify stock levels, pack sizes, or pricing when visiting distributors or customers.

📉
Unclear Product Velocity & Regional Demand

With 340+ products, it was genuinely difficult to know which SKUs were fast-moving, slow-moving, or nearing stockout — especially when broken down by zone.

🔄
Distributor & Performance Gaps

No structured way to track distributor health, spot declining primary/secondary trends, follow up on overdue tasks, or push real-time performance feedback to the sales team.

The Response

Five Solutions. Built In-House.

Each project started from a real pain point and was built without depending on an external MIS team — and is in active daily use.

📱
01
EDULINK POS
Mobile POS with digital invoicing
📊
02
Stock Intelligence
Real-time SKU stock & pricing dashboard
⚡
03
Product Velocity
Fast/slow SKU tracker by zone
🏪
04
Distributor Dashboard
Primary/secondary trend & flag system
🤖
05
Automation Layer
Task tracking + Telegram performance bot
Solution 01

EDULINK POS

Customers needed authenticated proof of purchase and clear discount records. We built a mobile-ready POS in-house — no MIS dependency.

  • Secure User ID & password login per staff member
  • Barcode scan → instant product & pricing lookup
  • On-the-spot invoice generation at point of sale
  • Print-ready PDF invoice handed to the customer
📱 Mobile-Ready 🖨️ Print Invoice No MIS Dependency
Invoice Preview
ACI EDULINK ✓ Authenticated
Invoice #EDU-2026-4821  ·  06 Sep 2026
PRODUCTQTYPRICE
EQ100-BK Flickwell Pen12৳94.80 EH324 iSelect Eraser Col.6৳39.00 EQ9-BK Every Ballpen24৳189.60
Distributor Discount −৳32.34
Total ৳291.06
Solution 02

Stock Intelligence

A single source of truth for all 340+ SKUs — stock levels, pack structures, and pricing — accessible by any team member anywhere.

  • Live stock quantity per SKU across locations
  • Full pack structure and pricing detail per product
  • Filter by Brand (Deli / iSelect) and Category
  • Export to Excel or PDF — for orders and pricing reviews
340+ SKUs Excel & PDF Export
Stock Intelligence Dashboard
Solution 03

Product Velocity

Understand demand patterns across 340+ products — by category, zone, and urgency — before stockouts happen.

  • Fast-moving vs slow-moving SKU classification
  • Zone & area-wise sales breakdown
  • At Risk flags for SKUs nearing zero stock
  • Category-level velocity graph: sales, velocity, demand
⚡ Fast-Moving ⚠ At Risk 🐢 Slow-Moving
Product Velocity Dashboard
Solution 04

Distributor Performance

A complete view of every distributor's health — primary and secondary sales trends — so declining partners are actioned before it's too late.

  • Primary & secondary sales trend per distributor
  • Declining trend detection & automatic flagging
  • Action planning & follow-through for underperformers
  • Review tracking and performance history log
Distributor Sales Trend Dashboard
Solution 05

Automation & Telegram Intelligence

📋
Task & Project Management
For management & business heads
  • Weekly task tracking by team and project
  • Overdue task reports pushed to management via email
  • Pending items surfaced automatically each week
  • Accountability loop with no manual follow-up needed
✈️
Telegram Performance Bot
For the field sales team
  • Target vs Achievement report per salesperson
  • Pushed directly to individual Telegram accounts
  • Order creation system integrated into the workflow
  • Daily performance trigger — a real nudge toward targets
📱 Telegram · SR Performance Alert
👤 SR: Rahim  ·  06 Sep 2026
🎯 Target: ৳85,000
✅ Achievement: ৳72,450
📊 Attainment: 85.2% — Keep pushing! 💪
Coming Next

The Next Phase

Integrating target-setting, ordering, and achievement reporting into one automated, trigger-driven system. Expected deployment within the next few months.

01

SKU-wise Target Setup — Zone to SR Level

340+ SKU targets broken down from Zone to Territory to individual SR — enabling granular performance benchmarking for the whole team.

In Progress
02

Order → Target → Sales Integration

One unified system: target set → order placed → sale recorded → achievement calculated. All connected, no manual reconciliation.

Designing
03

Full Telegram Achievement Automation

Achievement vs target pushed automatically to each SR's Telegram with no manual report generation — a closed-loop performance system.

Designing
Behind the Scenes

The AI Build Process

Every dashboard follows the same AI-assisted pipeline — from live spreadsheet data to a deployed, interactive web app. The same cycle repeats on each data refresh.

📊
Live Data
Spreadsheet link &
desktop storage file
connection as Source DB
Google Sheets Local Files
→
🔗
LangChain Orchestration
Central workflow engine — chains prompts, LLMs & data scripts sequentially into one automated pipeline
Claude Gemini RAG
→
🧪
Development
Google Colab
Python + Pandas
↗ View Notebook
→
🌐
HTML Dashboard
Generated HTML/JS
charts, filters, export
Interactive
→
🚀
Deployed
Deploy Pages live link
via Git repositories
Password-protected
Live to Teams
⛓️
Chaining — Sequential Pipeline

Links multiple components together — user input → prompt template → LLM → data processing script — so each step feeds the next automatically, no manual handoff.

🔎
Retrievers (RAG)

Lets the LLM search private, company-specific data — sales records, SKU databases, distributor lists — that wasn't in the model's training, grounding outputs in real operational context.

✨

Built for Real Work,
by the Team Doing It

Every tool shown today came from a real operational pain point and was built without waiting for a dedicated tech team. The goal: keep building, keep learning, and scale what works.

5
Live Dashboards
340+
SKUs Tracked
4
Automations Active
0
MIS Dependencies

ACI Edulink Stationery Division  ·  2026  ·  Questions welcome