How to Build a Fashion E-Commerce Product Profitability Dashboard

Revenue alone doesn't tell the full story. A product may sell well but still lose money once returns, fulfillment, discounts, and product costs are counted. In this tutorial we use ChartGen AI to build a dashboard that compares revenue, net profit, margin, category and size performance, and expected-margin gaps.

The goal is to help a business owner decide:

• Which products to keep or optimize
• Which products generate high revenue but weak profit
• Which sizes cause disproportionate losses
• Where pricing, return handling, or cost adjustments are needed

Dataset Overview

We use two datasets:

Together, these files let the dashboard answer both performance questions (what is profitable) and diagnosis questions (what is underperforming against plan).

Step-by-Step Walkthrough

Step 1: Upload the Profitability Datasets

Open ChartGen AI and upload both fashion_order_items_profit.csv and fashion_product_cost_structure.csv. After uploading, preview the datasets so ChartGen AI recognizes the key fields. Use the order-item dataset as the main performance source and the cost-structure dataset as the benchmark source.

Step 2: Define the Dashboard Goal

Before building, decide which business questions the dashboard should answer.

Step 3: Enter the Dashboard Prompt

Paste this prompt into ChartGen AI:

Build a product profitability dashboard for a fashion e-commerce business. The dashboard should include:
1. Net profit overview by product and category.
2. Comparison of revenue vs net profit to highlight high-revenue, low-profit products.
3. Net profit breakdown by size to surface size-related return risks.
4. A list or table of products with consistently negative net profit.
5. Reference expected margin rates from the product cost structure data where available.
The goal is to help a business owner decide:
- Which products to keep or optimize
- Which sizes cause disproportionate losses
- Where pricing or cost adjustments are needed
The overall color scheme is pink-purple.

This prompt works well because it gives ChartGen AI both the dashboard structure (metrics, required views, benchmark comparison) and the business purpose (the final decision to support).

Step 4: Generate the Dashboard

ChartGen AI generates a pink-purple profitability dashboard with summary KPI cards:

Plus four analysis areas: Net Profit by Category, Top 20 Products: Revenue vs Net Profit, Net Profit by Size, and Actual vs Expected Profit Margin.

Step 5: Interpret Category & Size Profitability

Step 6: Compare Revenue vs Net Profit

High revenue does not always mean high profit. The Top 20 Products chart reveals wide margin variation (roughly 17.49%–31.48% across top Outerwear products). Use it to classify products:

Step 7: Review Margin Gaps & Underperforming Products

The actual-vs-expected margin chart compares real margin against the expected margins in fashion_product_cost_structure.csv.

💡 Prioritize products with large negative margin gaps, consistently negative net profit, high revenue but low profit, or weak size-level performance.

Step 8: Make Business Decisions

Conclusion

We built a fashion e-commerce profitability dashboard from two CSV files. It summarized total revenue, net profit, overall margin, and underperforming products, then broke performance down by category, size, revenue-vs-profit, and expected-margin gaps. The main findings: Outerwear drove the strongest profit, Tops lagged in margin, XL/XS sizes underperformed, and 20 products missed expected margins by more than 10 points. The dashboard shows business owners exactly where profit comes from — and where it leaks.