Ecom Seller Profit

SKILL.md

# 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

```bash
# 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