Ecom Seller Profit

Multi-platform Order Profit Calculator — upload order exports from any e-commerce platform or ERP, get instant profit reports by order, store, SKU, and platf...

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