Seller Profit Calculator

Upload order exports from any e-commerce platform or ERP → get instant profit breakdown by order, store, SKU, and platform.

Slug: ecom-seller-profit Price: $0.01 USDT per call Author: 91Skillhub Team

---

What It Does

Upload one Excel file → get a complete profit breakdown:

• 📋 Overall summary: total orders, completed, cancelled, total revenue, total cost, net profit, net margin %
• 🌍 By platform: revenue / expense / cost / profit per platform
• 🏪 By store: revenue / expense / cost / profit per store
• 🔴 Bottom 5 orders: worst loss-making orders highlighted
• 🟢 Top 5 orders: best performing orders highlighted

---

How It Works

You upload any Excel order export
        ↓
Agent reads headers + sample rows (analyze_headers.py)
        ↓
Agent identifies each column's meaning (LLM reasoning)
        ↓
Agent builds field_map JSON → passes to parse_orders.py
        ↓
parse_orders.py calculates with full field context
        ↓
Report with per-order breakdown + accuracy notes

CLI Usage

# Auto-detect format
python3 scripts/parse_orders.py orders.xlsx

# With field mapping
python3 scripts/parse_orders.py orders.xlsx --field-map @my_mapping.json

# Output JSON
python3 scripts/parse_orders.py orders.xlsx --json result.json

# Markdown report
python3 scripts/parse_orders.py orders.xlsx --markdown report.md

---

Supported Platforms

All e-commerce platforms and ERPs that export order data with standard fields.

| Platform | Status | |----------|--------| | TikTok Shop | ✅ Verified | | Allegro | ✅ Verified | | Temu Half-Hosted | ✅ Verified | | SHEIN | ✅ Verified | | Fruugo | ✅ Verified | | Amazon | ✅ Compatible | | Shopee / Lazada | ✅ Compatible | | Ozon | ✅ Compatible | | Walmart / eBay | ✅ Compatible | | Other platforms | ✅ Generic |

---

Supported File Formats

• Excel: .xlsx, .xls
• CSV: .csv

---

Calculation Logic

Net Profit = Platform Revenue - Platform Expense - Order Cost

| Module | Description | |--------|-------------| | Platform Income | Transaction + shipping income + refunds + subsidies | | Platform Expense | Commission + tech fees + shipping + refunds + fines + taxes | | Order Cost | Purchase cost + first-leg freight + last-mile shipping + packaging + warehouse + advertising |

---

Tiered Features

| Feature | FREE | PRO | |---------|:----:|:---:| | Multi-platform support | ✅ | ✅ | | Header auto-detection | ✅ | ✅ | | Per-order profit calculation | ✅ | ✅ | | By-store / by-platform breakdown | ✅ | ✅ | | Top/bottom 5 orders | ✅ | ✅ | | Markdown report | ✅ | ✅ | | JSON export | ✅ | ✅ | | Custom field mapping | — | ✅ | | Priority support | — | ✅ |

---

Billing

This skill charges $0.01 USDT per execution via SkillPay.me.

• Billing is processed on each run via skillpay.me/api/v1/billing/charge
• Your user ID (FEISHU_USER_ID) is transmitted to SkillPay for billing identification
• When balance is insufficient, the system returns a payment link for top-up

Required environment variables: | Variable | Description | |----------|-------------| | SKILL_BILLING_API_KEY | SkillPay Builder API Key | | SKILL_BILLING_SKILL_ID | SkillPay Skill ID | | FEISHU_USER_ID | User ID for billing |

---

File Structure

seller-profit-calculator/
├── SKILL.md
└── scripts/
    ├── parse_orders.py      # Core parser + billing
    └── analyze_headers.py   # Header analyzer

---

Limitations

• CSV support: in v2.0 roadmap
• Settlement report: in v2.0 roadmap
• Per-order profit is precise; platform-level aggregation may have minor variance due to internal settlement adjustments

---

License

MIT