Real-time overview of orders, inventory, and business health
📦
—
Today's Orders
📋
—
Total Orders
🏪
—
Active Parties
💊
—
Products Synced
📅 Orders Last 14 Days Daily
⚡ Order Status Distribution
🏆 Top 10 Ordering Parties
🌆 Revenue by City
🕐 Recent Orders
Loading…
🤖 AI Business Analyst
Powered by Claude AI — Ask anything about your orders, inventory, parties, or demand patterns
🤖
JAP AI Analyst
Trained on your live order data · Demand forecasting · Reorder alerts · CRM insights
👋 Hello! I'm your JAP AI Business Analyst.
I have access to your complete order history, party data, and product catalog. Ask me anything:
Demand forecasting and MOQ recommendations
Slow-moving or fast-moving products
Party segmentation and at-risk customers
Reorder alerts and inventory health
City-wise performance analysis
🔍 Auto-Generated Insights
Generating insights from your data…
Order Management
Track, filter, and manage all customer orders
Loading…
Inventory Health
Stock levels, reorder alerts, aging analysis, and MOQ tracking
📦
—
Total SKUs
🚨
—
Reorder Alerts
🐢
—
Slow Movers
🔥
—
Fast Movers
🚨 Reorder Alerts
📊 Product Demand & Stock Analysis
Product
Code
Company
Orders
Avg Box/Order
Demand Level
Suggested MOQ
Last Ordered
Action
Loading inventory data…
Advanced Analytics
Deep-dive into trends, party segments, product performance, and city growth
📅 30-Day Order Trend Daily Volume
🏆 Party A/B/C Segmentation
🟢 A = Top performers 🟡 B = Mid-tier ⚫ C = At-risk
💊 Top Products by Order Volume
📈 Order Fill Rate by Status
⏱ Average Order Duration
AI Demand Forecast & MOQ
Machine-learning demand signals from order history — reorder suggestions, stock turn rates, and purchase recommendations
📈 7-Day Forecast vs Actual Predictive
📋 Product Demand Intelligence Table
Calculating…
Devices — Approval & Permissions
Approve each device here. All permission checkboxes live on the Devices sheet: all checked = full access; uncheck to withdraw a permission for that device.
CRM — Party Management
Customer lifetime value, order patterns, segmentation, and engagement scoring
🏪
—
Total Parties
🟢
—
Active (30d)
😴
—
Inactive (30d+)
⭐
—
VIP Parties
Loading…
Supplier Management
Map products to suppliers, track performance, lead times, and automate reorder alerts
ℹ️ How to use: Add your supplier details below. These are stored locally on this device.
Link products to suppliers to get automatic reorder recommendations when demand is high.
Returns Management
Log returns, track reasons, and manage reverse logistics
↩️
—
Total Returns
⏳
—
Pending
✅
—
Resolved
📊
—%
Return Rate
Push Notifications
Broadcast messages to all party portal users in real-time
Current Active Notification
—
—
📢 Compose & Push
Product Catalog
Manage visibility, sync from Google Sheets, and monitor catalog health
⚠️
Added new products to the sheet?
Click Sync Products to clear the cache and push fresh data to all party portals immediately.
📦 — products ·
🕐 Last sync: Never ·
🎁 — offers
Sync products to manage visibility
Audit Log
Complete trail of all admin actions — order updates, syncs, notifications, and settings changes
Settings
Sheet connection, WhatsApp, AI configuration, and system preferences
🔒 Admin Password
Change the admin password (stored only on the server, never in the app code). Use at least 6 characters.
🔗 Google Sheet Connection
Status: Not configured
Setup:
1. Sheet tabs required: Products, Offers, Orders, Parties, Notifications
2. Apps Script → paste apps-script.js → Deploy → Web App → Anyone
3. Always select New version when redeploying
🤖 AI Configuration
Connect Claude AI or Gemini AI to enable business insights, demand forecasting, and conversational analytics.
Claude: get from console.anthropic.com · Gemini: get from aistudio.google.com
📲 WhatsApp Number
📦 Inventory Thresholds
Set minimum order counts to trigger reorder alerts on the Inventory tab.
📦 Party Portal — Stock Display
Control how stock availability is shown to customers on the ordering portal.