Vendor Management Portal
B2B portal for managing vendor price lists, tracking inventory movements, and generating custom sales reports with Excel export.
Screenshot coming soon
The Challenge
A distribution company receiving price lists from multiple vendors in various formats (CSV, Excel) needed a centralized system to normalize pricing data, track daily inventory movements, and generate custom reports — all without manual spreadsheet work.
The Solution
Built a vendor portal that accepts price list uploads in any format, normalizes everything to a unified schema, and provides real-time inventory tracking with daily sales metrics. A custom report builder lets users slice data by any dimension and export to formatted Excel files.
Key Features
Smart File Uploads
Accepts CSV and Excel files with chunked processing (500-row batches) to handle large datasets without timeout issues.
Custom Report Builder
Drag-and-drop column selection with filters. Build any report you need and export to color-coded Excel files.
Real-Time Inventory
Track stock levels, sold quantities, and daily movements. See exactly what moved and when.
Daily Sales Reports
Automated daily sales tracking by channel with trend analysis and vendor-specific breakdowns.
AI Chat Integration
Built-in AI assistant for answering questions about inventory, orders, and vendor data.
How It Works
Vendor Upload
Vendors submit price lists via file upload. The system auto-detects format and maps columns to the unified schema.
Data Normalization
All products are normalized to UPC codes, creating a single source of truth across all vendor price lists.
Inventory Tracking
Daily inventory snapshots capture stock movements. The system calculates sold quantities automatically.
Report & Export
Users build custom reports with the report builder, then export to professionally formatted Excel files.
Tech Stack
Results
Unified in one portal
With Excel export
Real-time inventory movement
For price list processing