"Finally sat down and calculated everything. Shopify shows 45% gross margin. Reality is 18% after all costs. I've been making decisions on fantasy numbers for 2 years."
— Source: r/ecommerce (89 upvotes)
Your dashboard shows gross margin. Your accountant shows net profit. Neither shows you true cost per order—the number you actually need to make pricing, marketing, and product decisions.
Most ecommerce operators have never calculated their real cost per order. They use "revenue minus product cost" and call it margin. Then they're confused when profit doesn't match projections.
This calculator walks you through every cost category, with formulas and benchmarks. By the end, you'll know your true cost per order—not the optimistic number your dashboard shows.
Typical discovery: Stores find their true cost per order is 20-40% higher than they assumed. That "profitable" product? Maybe not.
Why Your Numbers Are Wrong
Here's what Shopify shows versus what's real:
| What You See | What's Missing |
|---|---|
| Revenue: $100 | Discounts, refunds absorbed |
| COGS: $35 | Freight, duties, packaging not included |
| Gross Profit: $65 | Fulfillment, processing, returns ignored |
| Gross Margin: 65% | True margin is 25-35% |
The gap exists because your costs live in different systems:
- Shopify knows revenue and basic COGS
- 3PL portal knows fulfillment costs
- Stripe/PayPal knows processing costs
- Returns portal knows return costs
- Accounting software knows overhead
- No single system connects them per order
This calculator does what your systems don't: combines all costs into one true number.
The Data Fragmentation Problem
Why don't stores calculate this automatically? The data lives in silos:
| Cost | Where Data Lives | Format |
|---|---|---|
| Product COGS | Shopify/supplier invoices | Per SKU |
| Inbound freight | Freight invoices | Per shipment |
| Fulfillment | 3PL portal | Per order + monthly |
| Shipping | 3PL or carrier | Per order |
| Processing | Stripe/PayPal | Per transaction |
| Returns | Returns portal + 3PL | Per return |
| Marketing | Ad platforms | Per campaign |
| Overhead | Accounting software | Monthly total |
Calculating true cost requires pulling data from 5-8 systems and doing math. Most stores do this once (if ever) instead of continuously.
This is exactly what Niblin's AI analytics agent solves. Ask "what's my true cost per order?" and the agent connects your order data to your cost data across all platforms—giving you computed, deterministic answers in seconds for every order, not a one-time spreadsheet that's outdated next month.
The True Cost Per Order Calculator
Work through each section. The formulas are provided—you supply your numbers.
| Component | Formula | Your Number |
|---|---|---|
| Product cost | Supplier invoice ÷ units | $_____ |
| Inbound freight | Total freight ÷ units shipped | $_____ |
| Duties/tariffs | Total duties ÷ units | $_____ |
| Packaging materials | Packaging cost per unit | $_____ |
| Prep/labeling | Labor + materials per unit | $_____ |
| TRUE COGS | Sum of above | $_____ |
Benchmark: True COGS is typically 10-20% higher than product cost alone.
| Component | Formula | Your Number |
|---|---|---|
| Pick & pack base | Monthly 3PL invoice ÷ orders | $_____ |
| Additional picks | Multi-item fees ÷ orders | $_____ |
| Shipping | Total shipping ÷ orders | $_____ |
| Materials (if not included) | 3PL materials charge | $_____ |
| Storage allocation | Monthly storage ÷ orders | $_____ |
| TOTAL FULFILLMENT | Sum of above | $_____ |
Benchmark: True fulfillment (including shipping) typically runs $8-15/order.
| Component | Formula | Your Number |
|---|---|---|
| Effective rate | Total fees ÷ revenue (not advertised rate) | _____% |
| Processing per order | AOV × effective rate | $_____ |
| Chargeback reserve | Chargeback rate × avg chargeback cost | $_____ |
| TOTAL PROCESSING | Sum of above | $_____ |
Benchmark: Effective rate is usually 3.2-4.0%, not the advertised 2.9%.
| Component | Formula | Your Number |
|---|---|---|
| Return rate | Returns ÷ orders | _____% |
| Cost per return | See return cost calculator | $_____ |
| RETURN RESERVE | Return rate × cost per return | $_____ |
Benchmark: At 12% return rate and $35 cost per return, reserve is $4.20/order.
| Component | Formula | Your Number |
|---|---|---|
| Marketing spend | Monthly ad spend | $_____ |
| Orders from ads | Attributed orders | _____ |
| CAC (paid orders) | Spend ÷ attributed orders | $_____ |
| Blended CAC | Total spend ÷ total orders | $_____ |
Use blended CAC for overall economics, specific CAC for channel decisions.
| Component | Monthly Cost | Per Order (÷ monthly orders) |
|---|---|---|
| Shopify subscription | $_____ | $_____ |
| Apps & software | $_____ | $_____ |
| Labor (your time or team) | $_____ | $_____ |
| Customer service | $_____ | $_____ |
| Professional services | $_____ | $_____ |
| TOTAL OVERHEAD | $_____ | $_____ |
| Category | Amount |
|---|---|
| Revenue (AOV) | $_____ |
| - True COGS | $_____ |
| - Fulfillment | $_____ |
| - Processing | $_____ |
| - Return Reserve | $_____ |
| - Customer Acquisition | $_____ |
| - Overhead Allocation | $_____ |
| = TRUE PROFIT PER ORDER | $_____ |
| TRUE MARGIN | _____% |
Example Calculations
| Line Item | Amount |
|---|---|
| Revenue (AOV) | $75.00 |
| True COGS | -$22.00 |
| Fulfillment (incl. shipping) | -$11.00 |
| Processing (3.5%) | -$2.63 |
| Return reserve (20% × $40) | -$8.00 |
| Blended CAC | -$12.00 |
| Overhead allocation | -$4.00 |
| TRUE PROFIT | $15.37 |
| TRUE MARGIN | 20.5% |
Dashboard shows: 71% gross margin ($75 - $22)
Reality: 20.5% true margin
| Line Item | Amount |
|---|---|
| Revenue (AOV) | $120.00 |
| True COGS | -$55.00 |
| Fulfillment (incl. shipping) | -$9.00 |
| Processing (3.5%) | -$4.20 |
| Return reserve (12% × $50) | -$6.00 |
| Blended CAC | -$18.00 |
| Overhead allocation | -$5.00 |
| TRUE PROFIT | $22.80 |
| TRUE MARGIN | 19.0% |
Dashboard shows: 54% gross margin
Reality: 19% true margin
| Line Item | Amount |
|---|---|
| Revenue (AOV) | $35.00 |
| True COGS | -$15.00 |
| Fulfillment (incl. shipping) | -$8.00 |
| Processing (4%) | -$1.40 |
| Return reserve (8% × $30) | -$2.40 |
| Blended CAC | -$5.00 |
| Overhead allocation | -$2.00 |
| TRUE PROFIT | $1.20 |
| TRUE MARGIN | 3.4% |
Dashboard shows: 57% gross margin
Reality: 3.4% true margin—one bad month wipes out the year
Amazon vs. Shopify Cost Comparison
Calculate separately for each channel—costs differ significantly:
| Cost Category | Shopify | Amazon FBA |
|---|---|---|
| Platform fee | $0-39/month (plan) | 8-15% referral |
| Fulfillment | 3PL: $5-10/order | FBA: $4-12/order |
| Processing | 2.9-4% | Included in referral |
| Customer acquisition | Ad spend (you control) | PPC + Amazon brings traffic |
| Returns | You handle | Amazon handles (higher rate) |
| Storage | 3PL storage fees | FBA storage (strict limits) |
Many sellers are profitable on one channel and break-even on the other—without knowing which is which.
Don't blend channels: Calculate true cost per order for Shopify and Amazon separately. The "profitable" channel might be subsidizing the "growth" channel.
Using Your True Cost Numbers
Once you know true cost, here's what to do with it:
- Set minimum viable price = True Cost + Target Margin
- Identify products where you need to raise prices
- Calculate discount limits that keep you profitable
- Max viable CAC = True Profit Per Order (break-even)
- Target CAC = 30-50% of True Profit (sustainable)
- Compare actual CAC by channel to decide where to spend
- Rank products by true margin, not gross margin
- Consider discontinuing products with <10% true margin
- Identify products where cost reduction would help most
Your largest cost categories are where to focus improvement:
- If COGS is highest: negotiate suppliers, find alternatives
- If fulfillment is highest: audit 3PL, optimize packaging
- If returns are highest: improve product descriptions, QC
- If CAC is highest: optimize ad targeting, improve conversion
From Spreadsheets to Automated Tracking
This calculator gives you your true cost per order today. But costs change—3PL raises rates, return rates shift, ad costs fluctuate. A one-time calculation is outdated next month.
Stores with continuous cost visibility track true profit per order automatically. They see when fulfillment costs creep up, when a product's return rate spikes, when a channel becomes unprofitable.
The difference between annual profit calculation and continuous tracking? Often catching a $5,000/month margin erosion before it becomes $60,000/year in lost profit.
Stop calculating in spreadsheets.
Ask your data anything. Niblin's AI agent answers questions like "what's my true cost per order for each product?" by connecting your Shopify, Amazon, Meta, Google, TikTok, and GA4 data in seconds. Deterministic intelligence—computed, not generated. $299/mo to start.
Ask Your Data Anything — 15 Minute Setup
Key Takeaways
- Dashboard gross margin is typically 20-40% higher than true margin after all costs
- True cost includes: COGS, fulfillment, processing, returns, acquisition, overhead
- True COGS = product cost + freight + duties + packaging (10-20% higher than product alone)
- Return reserve should be included in every order's cost calculation, not just returns
- Calculate separately for each channel—Shopify and Amazon have different cost structures
- Max viable CAC = true profit per order; target CAC should be 30-50% of true profit
- Update calculations monthly as costs change; one-time calculations become stale
Frequently Asked Questions
What costs should be included in cost per order?
Include: true COGS (product + freight + duties + packaging), fulfillment (pick/pack + shipping + storage), payment processing (effective rate, not advertised), return reserve (rate × cost per return), marketing allocation, and overhead. Most stores only count product COGS.
How often should I calculate cost per order?
Monthly at minimum, as costs change frequently. 3PLs adjust rates, return rates fluctuate, ad costs vary seasonally. Continuous automated tracking is ideal; at minimum, quarterly deep-dives with monthly monitoring of major cost categories.
Should I calculate cost per order differently for each product?
Yes—different products have different true costs. A high-return-rate product needs higher return reserve. A large product has higher fulfillment costs. Calculate at SKU level for important products, and use category averages for long-tail.
What's a healthy true profit margin for ecommerce?
After all costs, 10-20% true net margin is healthy. Below 10% is risky—one bad month erases profit. Above 20% is excellent and usually indicates strong pricing power or operational efficiency. Most stores run 12-18%.
Should I include marketing costs in cost per order?
Yes, either as blended CAC (total marketing ÷ total orders) for overall unit economics, or attributed CAC for channel-specific analysis. Marketing is a real cost of acquiring each order—excluding it inflates apparent profitability.
How do I allocate overhead to orders?
Sum all monthly fixed costs (software, labor, services) and divide by monthly order volume. This gives per-order overhead. Example: $5,000 monthly overhead ÷ 1,000 orders = $5/order overhead allocation.