I Built an AI Retail Analyst for Any eCommerce Business | Python + GPT-4o

🤖 I built an AI-powered Retail Analyst that takes your Amazon Vendor
Central CSV exports and generates a complete GPT-4o analyst report
in under 60 seconds — no spreadsheets, no manual work, no coding needed.

This tool is built for Amazon Vendor agencies, Account Managers, and
eCommerce Business Owners who spend 3-5 hours every week manually
analysing sales, inventory, and traffic data.

Drop 3 CSV files in → Pipeline runs → GPT-4o writes the full report.
What took hours now takes 60 seconds. Every week.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
📌 WHAT THIS VIDEO COVERS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
— Introduction & What We're Building
— The Problem (Manual Amazon Reporting)
— The 3 Input Files (Sales, Inventory, Traffic CSVs)
— Before vs After — Manual vs AI Analyst
— The 5-Step Pipeline Explained
--- Streamlit UI Demo (For Business Users)
-- FastAPI Demo (For Developers)
— GPT-4o Output Report Walkthrough
— Real ASIN Example — What Gets Flagged & Why
— Live Code Demo (pipeline.py + insights.py)
— Tech Stack + GitHub

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🔧 WHAT THIS TOOL DOES
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
✅ Ingests 3 Amazon Vendor Central CSV exports automatically
✅ Cleans, joins, and processes all data on ASIN (product ID)
✅ Calculates 10 business KPIs — WoW sales, revenue & traffic changes
✅ Flags 8 risk conditions — inventory risk, sales drops, low Buy Box & more
✅ GPT-4o generates a 3-section professional analyst report
✅ Streamlit UI for business users — no coding needed
✅ FastAPI REST endpoint for developers to integrate into any app
✅ Report auto-saved with timestamp + downloadable from UI

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
📁 GET THE CODE — GITHUB
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🔗 https://github.com/JohnDBSDSN/amazon-vendor-ai-analyst

Clone it, add your OpenAI API key to .env, pip install requirements.txt
and it runs immediately. Full README included.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ TECH STACK
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🐍 Python 3.10+
📊 Pandas + NumPy
🤖 OpenAI GPT-4o API
🖥️ Streamlit (Browser UI)
⚡ FastAPI + Uvicorn (REST API)
📋 Swagger UI (Auto-generated API docs)
🔐 python-dotenv (API key security)
📁 GitHub (Version control)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
🔗 CONNECT WITH ME
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
💼 LinkedIn: https://www.linkedin.com/in/john-daniel-ai/
🌐 Portfolio: https://johndbsdsn.github.io
💻 GitHub: https://github.com/JohnDBSDSN
📝 Medium: https://medium.com/@a.johndaniel

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 COMMENT BELOW
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
What challenges do you face in your Amazon or eCommerce business?
What would you want an AI analyst to flag for you automatically?
Drop your thoughts below — I read every comment!

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
⚠️ DISCLAIMER
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
This tool works with CSV exports only. No Amazon API, no scraping,
no login automation. Your OpenAI API key is stored locally in .env
and is never shared or uploaded.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

#ArtificialIntelligence #Python #GPT4 #eCommerce #AmazonFBA
#AmazonVendorCentral #AIAnalyst #MachineLearning #LLM #OpenAI
#Streamlit #FastAPI #DataScience #NLP #PythonProjects
#AIEngineering #RetailAnalytics #AmazonSeller #ChatGPT
#ZenithQuest #AIforBusiness #GPT4o #PythonTutorial
#AIAutomation #eCommerceAnalytics

Видео I Built an AI Retail Analyst for Any eCommerce Business | Python + GPT-4o канала ZenithQuest