Agent skill
profit-margin-calculator-shopify
Shopify/DTC profit margin calculator for sellers. Calculate cost breakdowns including ad spend, CAC, payment processing fees, and 3PL costs. Includes LTV/CAC analysis and DTC-specific benchmarks. No API key required.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/other/profit-margin-calculator-shopify
Metadata
Additional technical details for this skill
- nexscope
-
{ "emoji": "\ud83d\udcb0", "category": "ecommerce" }
SKILL.md
Profit Margin Calculator — Shopify/DTC 💰
Calculate product profitability for Shopify and DTC stores — cost breakdowns, profit margins, and CAC/LTV analysis.
Installation
npx skills add nexscope-ai/eCommerce-Skills --skill profit-margin-calculator-shopify -g
Cost Components
| Cost Item | Description | Notes |
|---|---|---|
| Product Cost | FOB purchase price | - |
| Inbound Shipping | To 3PL warehouse | - |
| 3PL Fulfillment | ShipBob/Deliverr etc. | - |
| Payment Processing | 2.9% + $0.30 | Shopify Payments |
| Advertising | 20-40% | Main cost ⚠️ |
| Return Cost | Return processing | - |
| Customer Shipping | If free shipping offered | Optional |
DTC Characteristics
- No platform commission: Only payment processing fees
- High ad spend ratio: 20-40%, main cost driver
- Requires high margins: 60%+ gross margin to support ads
- Focus on LTV/CAC: Recommended >3
Key Metrics
| Metric | Recommended |
|---|---|
| Gross Margin | >60% |
| Net Margin | >20% |
| LTV/CAC | >3 |
| Repeat Rate | Higher = better |
Usage
python3 scripts/calculator.py
python3 scripts/calculator.py '{"selling_price": 49.99, "ad_spend_ratio": 0.20, "product_cost": 12}'
Output Example
💰 **Shopify/DTC Profit Analysis Report**
Selling Price $49.99 100.0%
────────────────────────────────────────
Product Cost -$12.00 24.0%
3PL Fulfillment -$4.50 9.0%
Payment Processing -$1.75 3.5%
Advertising -$10.00 20.0% ⬅️ Main cost
...
────────────────────────────────────────
Net Profit $18.59 37.2%
💡 Max Affordable CAC: $10.00
DTC Golden Ratios
DTC Health Formula:
├── Gross Margin > 60%
├── Ad Spend < 30%
├── Fulfillment < 15%
├── Net Margin > 15%
└── LTV/CAC > 3
vs Amazon
| Item | Amazon | Shopify/DTC |
|---|---|---|
| Platform fee | 8-15% | 0% |
| Payment fee | Included | 2.9% + $0.30 |
| Ad spend | 10-20% | 20-40% |
| Margin need | 40%+ | 60%+ |
| Traffic | Platform | Self-built |
Part of Nexscope AI — AI tools for e-commerce sellers.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?