Prodlist Dashboard

Internal Operational Report — AI Product Title Processing System

Project Overview

Development Time
43 hours
Initial build and deployment
Purpose
Automated product title and description optimization for e-commerce catalogs. Processes bulk listings via AI to improve search visibility and standardize formatting.

Processing Efficiency

1,333 hrs
Manual Processing
80,000 products
vs
2.67 hrs
Automated Processing
80,000 products
99.8%
Time Reduction

Performance Metrics

500/min
Processing Speed
1.2s
Per Product
80,000
Total Products
Processing Timeline
10 min
5,000 products
30 min
15,000 products
1 hr
30,000 products
2.67 hrs
80,000 products

Resource Utilization

Cost Breakdown (MYR)
Development (one-time) RM 1,720
VPS Server (annual) RM 45
Total Operating Cost RM 1,815
RM 51,505
Total Savings vs Manual
Manual Cost (SEO Specialist)
RM 53,320

📈 ROI Visualization

Cost Comparison
Processing Timeline

Return on Investment

2,738%
ROI
43 products
Break-Even Point
5 min
Payback Time

Technical Specifications

Frontend
HTML5, CSS3, Vanilla JavaScript
Backend
PHP 8.3
Database
MySQL (prodlist)
AI Engine
Ollama qwen3.5 + OpenRouter
Server
Tencent Cloud Lighthouse
Integration
Google Sheets API

Processing Rules

≤120
Max Characters
100%
English Only
80+
Min Score
0
Duplicate Words

Operational Notes

System automates product title and description optimization across e-commerce inventory. Processes listings in batches via Google Sheets integration. AI analysis applies standardized formatting rules: maximum 120 characters, English-only output, minimum quality score of 80, no duplicate words. Real-time dashboard tracks batch progress and completion status.

Deployment: Single VPS instance (Tencent Cloud Lighthouse). API calls routed through OpenRouter free tier. Database stores processed listings with version history. Average processing rate: 500 products per minute at 1.2 seconds per product.