Product or SKU
- Requirement
- Required
- Example
- Nova X Headphones
- Purpose
- Needed for the core workflow
Upload product sales and cost data to identify profitable products, low-margin items, discount impact, refund impact, and category-level margin performance.
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 used in the product profitability workflow.
Product Profitability Dashboard
Interactive preview from the sample product sales and cost dataset
Switch preview
Total Records
48
rows in sample
Total Gross Sales
3,877,376
sum of Gross Sales
Total Net Revenue
3,496,218
sum of Net Revenue
Bin width 10,000 · 48 observations
Full dashboard with all KPI details and 6 charts is on the demo page.
Open full demoThe sample aggregates $3,496,218 net revenue and $1,719,572 gross profit across 4 products, 3 categories, and 3 channels over 12 months.
Sample results: 49.2% gross margin, 6.7% discount rate, and Echo Speaker ranks third by net revenue but fourth by gross profit; Nova X Headphones leads revenue but has the lowest margin at 46%; Orbit Keyboard has the highest margin at 58%.
Find which products truly drive profit, which high-revenue SKUs erode margin, and where discounts or refunds distort performance.
Product sales exports reveal revenue concentration, cost leakage, refund drag, and margin variation across categories and channels. The content should make the next pricing or assortment action clear.
The sample shows 48 product-month rows across 4 products with 49.2% gross margin. Nova X Headphones leads gross profit at $781,421 while Orbit Keyboard delivers the strongest margin at 58%.
The workflow is designed around summary metrics connected to the products, orders, tasks, or records that explain them.
Product sales files often contain enough information to understand revenue, cost, margin, and refund impact, but the data is difficult to review in raw line-item form. This workflow helps create transparent profitability views without inventing cost or margin claims.
The result brings the most important metrics, trends, and exceptions into one view, while keeping the supporting records available for review.
Use the downloadable sample to follow the source rows, field mapping, validation, and final output as one reproducible workflow.
The source preview highlights the exact columns and representative rows used by the workflow.
| Date | Quarter | Product | Region | Gross Sales |
|---|---|---|---|---|
| 2025-07-01 | Q3 2025 | Nova X Headphones | North America | 124,033 |
| 2025-07-01 | Q3 2025 | Pulse Smartwatch | Europe | 77,937 |
| 2025-07-01 | Q3 2025 | Orbit Keyboard | APAC | 29,025 |
| 2025-07-01 | Q3 2025 | Echo Speaker | Middle East & Africa | 30,251 |
| 2025-08-01 | Q3 2025 | Nova X Headphones | Europe | 153,314 |
The finished output includes the KPI cards, charts, tables, and report views described below.
Grouped by Date
VizMint works best when every column has one clear heading and each row represents one consistent record. Fields that are not available should not be invented; dependent outputs should be hidden or clearly marked as unavailable.
| Column | Requirement | Example | Purpose |
|---|---|---|---|
| Product or SKU | Required | Nova X Headphones | Needed for the core workflow |
| Quantity | Required | 377 | Needed for the core workflow |
| Revenue or Gross Sales | Required | 124033.00 | Needed for the core workflow |
| Unit Cost or COGS | Required | 59593.51 | Needed for the core workflow |
| Date | Recommended | 2025-07-01 | Adds an important comparison or breakdown |
| Category | Recommended | Electronics | Adds an important comparison or breakdown |
| Discount | Recommended | 8682.31 | Adds an important comparison or breakdown |
| Refund | Recommended | 4992.33 | Adds an important comparison or breakdown |
| Channel | Optional | Online Store | Adds detail when present |
| Region | Optional | North America | Adds detail when present |
| Shipping Cost | Optional | 5278.00 | Adds detail when present |
| Platform Fee | Optional | 7945.80 | Adds detail when present |
$3,496,218 after 6.7% discounts and 3.1% refunds in the sample scope.
$1,776,646 recorded as cost of goods sold across eligible product rows in the selected period.
$1,719,572 after subtracting COGS from net revenue using the documented formula.
49.2% gross profit divided by net revenue, with the denominator shown beside the result.
Nova X Headphones with $781,421 gross profit in the sample reporting scope.
Nova X Headphones at 46% margin despite leading net revenue in the sample.
6.7% of gross sales under the selected discount definition.
$119,964 in refunds, or 3.1% of gross sales, reducing recorded revenue.
| Chart or Output | Required Fields | Business Question |
|---|---|---|
| Revenue by Product | Product, net revenue, date | Shows revenue by product for the selected records and reporting scope. |
| Profit by Product | Product, gross profit, COGS | Shows profit by product for the selected records and reporting scope. |
| Margin by Category | Category, gross profit, net revenue | Shows margin by category for the selected records and reporting scope. |
| Revenue vs Margin Quadrant | Product, net revenue, gross margin | Shows revenue vs margin quadrant for the selected records and reporting scope. |
| Discount/Refund Impact | Discount, refund, gross sales | Shows discount/refund impact for the selected records and reporting scope. |
| Monthly Profitability Trend | Month, net revenue, gross profit | Shows monthly profitability trend for the selected records and reporting scope. |
Upload the workflow-specific sample or a user file with clear headers and one record per row.
Select the correct worksheet when the workbook contains multiple sheets.
Confirm the detected header row and field mapping before generation.
Review the data preview, exclusions, and validation warnings.
Generate the dashboard, chart, report, presentation, or answer.
Review KPI values, calculations, charts, and source traceability.
Save, share, or export using capabilities available on the active plan.
| Metric | Formula or Method | Required Fields | Important Rule |
|---|---|---|---|
| Net Revenue | Gross sales − discounts − refunds | Gross sales, discount, refund | Taxes and shipping should remain separate unless the chosen definition includes them. |
| COGS | Net units sold × unit cost | Quantity, COGS or unit cost | Return quantities must reduce net units when supported. |
| Gross Profit | Net revenue − COGS | Net revenue and COGS | Requires cost data. |
| Gross Margin | Gross profit ÷ net revenue × 100 | Gross profit and net revenue | Hide or flag when net revenue is zero. |
| Problem | Recommended Fix |
|---|---|
| Missing product cost | Add the missing field when available; otherwise hide dependent metrics and explain the limitation. |
| Duplicate order lines | Use a stable identifier, review repeated rows, and remove or reconcile duplicates before calculation. |
| Refunds stored in another file | Join files using a reliable shared identifier and validate unmatched records. |
| Product-name or SKU variations | Standardize labels so the same entity or category uses one consistent value. |
| Mixed currencies | Keep currencies separate or convert them with a verified exchange-rate method before aggregation. |
Available sharing and export options depend on the live VizMint plan. Publish only capabilities confirmed in production, such as saving the analysis, downloading images or PDF files, exporting PowerPoint, creating private links, refreshing a saved report, or removing branding on eligible plans.
Do not hardcode plan limits, file-size limits, privacy promises, or export features until product and billing owners confirm them.
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 to generate the supported metrics, charts, and comparisons for this workflow.