nexscope-ai/eCommerce-Skills / profit-margin-calculator/profit-margin-calculator-shopify
profit-margin-calculator-shopify
VerifiedShopify/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.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 2.7 KB |
| scripts/calculator.py | script | 18.4 KB |
SKILL.md
View on GitHub---
name: profit-margin-calculator-shopify
version: 1.0.0
description: "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."
metadata: {"nexscope":{"emoji":"π°","category":"ecommerce"}}
---
# Profit Margin Calculator β Shopify/DTC π°
Calculate product profitability for Shopify and DTC stores β cost breakdowns, profit margins, and CAC/LTV analysis.
## Installation
```bash
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
```bash
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](https://www.nexscope.ai/?co-from=skill) β AI tools for e-commerce sellers.**
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| receiving-code-reviewobra/superpowersUse when receiving code review feedback, before implementing suggestions, especially if feedback seems unclear or technically questionable - requires technical rigor and verification, not performative agreement or blind implementation | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| requesting-code-reviewobra/superpowersUse when completing tasks, implementing major features, or before merging to verify work meets requirements | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| using-git-worktreesobra/superpowersUse when starting feature work that needs isolation from current workspace or before executing implementation plans - ensures an isolated workspace exists via native tools or git worktree fallback | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |
| verification-before-completionobra/superpowersUse when about to claim work is complete, fixed, or passing, before committing or creating PRs - requires running verification commands and confirming output before making any success claims; evidence before assertions always | Stars: 323k | Updated | Claude CodeCodex | Verified | Install |