SKU or Product
- Requirement
- Required
- Example
- SKU-1001
- Purpose
- Identifies the inventory item
Upload an inventory export to analyze stock levels, inventory value, product categories, warehouses, low-stock items, and reorder signals.
VizMint turns stock snapshots or structured inventory movement data into a clear operational dashboard without replacing the systems used to manage inventory transactions.
Supports structured .csv and .xlsx files. Public examples use synthetic data. Review VizMint’s current privacy and retention policy before uploading sensitive information.
Use the fixed preview below to switch between the source spreadsheet and a dashboard sample. Open the full demo in a new tab for every KPI and chart.
Inventory Dashboard
Interactive preview from the sample inventory snapshot dataset
Switch preview
Total Records
51
rows in sample
Total Inventory Value
57,333
sum of Inventory Value
Total Stock Quantity
5,394
sum of Stock Quantity
Bin width 250 · 51 observations
Full dashboard with all KPI details and 6 charts is on the demo page.
Open full demoThe sample contains 51 SKUs across 3 warehouses. Charts and KPI cards are generated from the same JSON dataset.
Sample totals: $57,333 inventory value, 27 low-stock SKUs, 8 stockouts, and 14 products with more than 120 days of estimated cover — from 51 source records.
Identify low stock, excess value, warehouse imbalance, and products that need review.
Ecommerce exports often mix orders, line items, discounts, refunds, customers, and fulfilment records. Reliable analysis makes the aggregation level explicit so orders, units, customers, and line items are not confused.
The sample across 3 warehouses produces $57,333 in inventory value, 27 low-stock SKUs, 8 stockouts, and 14 products with more than 120 days of estimated cover.
The workflow is designed around visible aggregation rules and source-level evidence for every headline metric.
Inventory data often sits in ERP, ecommerce, or warehouse exports that are difficult to review outside the source system. A focused inventory dashboard helps teams identify low stock, excess stock, concentration, movement, and inventory value.
Snapshot files describe current stock, while movement files show receipts and issues over time. The workflow keeps those two data structures separate.
Follow the same dataset from source rows to the generated dashboard preview. The spreadsheet table, KPI cards, and charts all come from one JSON sample, so every visible result can be checked against the source.
The source preview highlights the exact columns and representative rows used in the analysis.
| Category | Warehouse | Low Stock Flag | Stockout Flag | Inventory Value |
|---|---|---|---|---|
| Accessories | Dhaka Warehouse | Low Stock | Stockout | 0 |
| Electronics | Chattogram Warehouse | Low Stock | Stockout | 0 |
| Home & Office | Gazipur Warehouse | Low Stock | Stockout | 0 |
| Packaging | Dhaka Warehouse | Low Stock | Stockout | 0 |
| Spare Parts | Chattogram Warehouse | Low Stock | Stockout | 0 |
The finished example is generated from the sample dataset rather than an unrelated mockup or stock image.
Bin width 250 · 51 observations
VizMint works best when every column has one clear heading and each row represents one consistent record.
| Column | Requirement | Example | Purpose |
|---|---|---|---|
| SKU or Product | Required | SKU-1001 | Identifies the inventory item |
| Stock Quantity | Required | 240 | Shows current stock |
| Unit Cost | Recommended | 18.50 | Calculates inventory value |
| Category | Recommended | Accessories | Creates category analysis |
| Warehouse or Location | Recommended | Dhaka Warehouse | Creates location comparison |
| Date | Recommended for trends | 2026-06-30 | Supports stock or movement trends |
| Quantity Received | Conditional | 80 | Tracks inbound movement |
| Quantity Issued or Sold | Conditional | 55 | Tracks outbound movement |
| Reorder Level | Conditional | 60 | Creates basic reorder signal |
| Lead Time | Optional | 14 | Supports more advanced reorder logic |
| Safety Stock | Optional | 25 | Supports reorder calculation |
Sum of current stock quantities.
Stock quantity multiplied by unit cost.
Number of distinct inventory items.
Items at or below the defined threshold.
Items with zero available quantity.
Total units divided by distinct SKU count.
Items holding the largest stock value.
Items meeting a verified reorder rule.
| Chart or Output | Required Fields | Business Question |
|---|---|---|
| Stock by Category | Category, stock quantity | Which categories hold the most inventory? |
| Inventory Value by Product | Product, stock quantity, unit cost | Which items hold the most capital? |
| Warehouse Comparison | Warehouse, stock quantity, value | Where is inventory located? |
| Low-Stock Ranking | Product, stock quantity, reorder level | Which products need attention? |
| Received vs Issued Trend | Date, received, issued | How is inventory moving over time? |
| Stock Concentration | Product or category, value | Is inventory concentrated in a small number of items? |
Use clear headers, one record per row, consistent dates, and numeric values stored as numbers.
Select the CSV or Excel file using the page’s upload control.
For multi-sheet workbooks, choose the sheet containing the relevant data table.
Review the detected fields and map any column VizMint could not identify confidently.
Check dates, numbers, categories, missing values, and record counts before generation.
Create the supported dashboard, report, presentation, chart, or answer.
Review calculations and limitations, then save, share, or export using the options available in the active plan.
| Metric | Formula or Method | Required Fields | Important Rule |
|---|---|---|---|
| Inventory Value | Stock quantity × unit cost | Stock quantity and unit cost | The result follows the supplied cost and is not a formal valuation method. |
| Basic Reorder Signal | Stock quantity ≤ reorder level | Stock quantity and reorder level | Only available when a threshold is provided. |
| Net Movement | Quantity received − quantity issued | Movement data | Requires consistent movement definitions. |
| Stock Turnover Proxy | Quantity issued ÷ average stock | Movement and stock history | Do not present as formal turnover without adequate period data. |
| Problem | Recommended Fix |
|---|---|
| SKU names are duplicated or inconsistent | Use a stable SKU or product ID. |
| Stock and available stock are mixed | Separate on-hand, reserved, and available quantities. |
| Unit cost is missing | Hide inventory-value calculations. |
| Movement types are inconsistent | Normalize receipt, sale, issue, transfer, and adjustment values. |
| Negative stock appears unexpectedly | Review returns, timing, and data-quality issues. |
| Warehouses use inconsistent names | Standardize location names before comparison. |
Available options depend on the live VizMint plan. The final page should list only verified capabilities, such as saving the analysis, downloading chart images, exporting PDF or PowerPoint files, creating a shareable link, refreshing with updated data, or removing branding on eligible plans.
Do not publish a plan comparison until product and billing owners confirm every feature.
VizMint analyzes exports; it does not replace the accounting, CRM, help-desk, HR, warehouse, advertising, or project-management system that produced them.
Upload a structured CSV or Excel file, review the detected fields, and generate the workflow-specific output described on this page.