Your Shopify dashboard says you made $24,000 last month. That's revenue. It's not profit. And the gap between those two numbers is where most merchants get blindsided.
Shopify tracks sales beautifully. It tells you how many orders came in, what your average order value is, and which products are selling the most. But it has almost nothing to say about what those sales actually cost you — and therefore, what you actually earned.
Revenue is not profit (and Shopify only shows revenue)
This is not a subtle distinction. A product that generates $48 in revenue might contribute $14 in profit or $2 in profit depending on the costs behind it. The problem is that Shopify's native reports treat revenue as the primary lens for everything: top products by revenue, sales over time by revenue, customer segments by revenue.
Revenue tells you how much money moved. Profit tells you how much money you kept. If you're making inventory, marketing, or pricing decisions based on revenue alone, you're operating with incomplete information.
The costs Shopify doesn't track for you
Here's what's typically missing from a Shopify analytics view:
Cost of goods sold (COGS)
Shopify has a "Cost per item" field on the product page, but it's optional, not enforced, and most merchants either skip it or enter it once and never update it. Even if you fill it in, Shopify's reports don't use COGS data to calculate margin in any meaningful way. You'll see revenue. You won't see gross profit per SKU.
For a product that retails at $48 with a landed cost of $8.40, your gross margin is roughly 82%. That looks great. But we're only getting started with costs.
Shipping costs
If you offer free shipping (and most competitive stores do), that cost comes directly out of your margin. On that $48 product, you might be paying $5.20 to ship it. That alone drops your effective margin from 82% to about 72%.
Shopify doesn't net shipping costs against product revenue in its analytics. You see shipping charges collected (if any) and total revenue, but never the gap between them.
Payment processing fees
Every order processed through Shopify Payments costs 2.9% + $0.30 (on the basic plan). On a $48 order, that's $1.69. On a $12 order, it's $0.65 — which is a much larger percentage of a smaller sale. Transaction fees are regressive: they hit low-AOV products disproportionately.
These fees are deducted from your payouts, so you feel them in your bank account. But Shopify's product-level and order-level analytics don't subtract them from reported revenue.
Discounts and promotions
If you ran a 15% off promotion and a customer bought that $48 product for $40.80, Shopify records the discounted amount. But it doesn't help you answer the harder question: was that discount incremental? Would that customer have bought at full price tomorrow?
Shopify shows you total discount amounts. It doesn't show you discount effectiveness — the relationship between margin sacrificed and incremental revenue gained.
Returns and refunds
A returned order isn't just lost revenue. It's lost revenue plus return shipping, plus restocking labor, plus potential damage to the product. Shopify tracks refund amounts, but doesn't calculate the total cost of a return or net it against the product's original margin.
What true margin actually looks like
Let's put real numbers on a single order to see the difference:
| Line Item | Amount |
|---|---|
| Product sale price | $48.00 |
| COGS | -$8.40 |
| Shipping (absorbed) | -$5.20 |
| Payment processing (2.9% + $0.30) | -$1.69 |
| Discount (15% off) | -$7.20 |
| True profit | $25.51 |
Shopify reports this order as $48.00 in revenue (or $40.80 after the discount, depending on the report). The actual profit is $25.51 — roughly 53% of the sale price, not the 82% gross margin you'd calculate from COGS alone.
Now multiply that gap across thousands of orders and dozens of SKUs. Some products look profitable on a revenue basis but barely break even after all costs. Others are quiet workhorses with tight pricing but excellent true margins.
The manual approach (and why it breaks)
Some merchants try to solve this with spreadsheets. The process usually looks like:
- Export orders from Shopify as CSV
- Export product costs from your supplier or inventory system
- Pull payment processing fees from your Shopify Payments summary
- Pull shipping costs from your carrier dashboard
- Match everything by SKU and order number
- Build formulas for net margin per product, per order, per customer
This works once. It breaks the second time because a new product was added, a cost changed, a discount code was applied differently, or someone forgot to update the COGS column. Manual margin tracking has a half-life of about two weeks before the spreadsheet diverges from reality.
The automated approach: AI-calculated margins
This is where purpose-built analytics changes the equation. When Spark by MishiPay connects to your Shopify store, it pulls order data, product data, cost data, refund data, and discount data — then layers on payment processing fees and shipping costs to calculate true margins automatically.
Instead of building spreadsheets, you ask questions:
"What are my top 10 products by true margin this quarter?"
"Which products have margins below 20% after shipping and fees?"
"How much did the spring sale actually cost me in margin per order?"
The AI cross-references all the cost dimensions — COGS, shipping, processing fees, discounts, returns — and delivers answers in seconds. When costs change, the calculations update automatically the next time data is synced.
What this unlocks
Once you have accurate margin data, several decisions get dramatically easier:
Pricing adjustments. You can identify products where a small price increase (even $2-3) would meaningfully improve margin without significantly affecting conversion. You can also identify products that are priced too high relative to their cost structure and could benefit from a strategic price reduction to drive volume.
Shipping strategy. If free shipping on orders under $30 is killing your margins, you can see exactly how much it costs and set a minimum threshold that protects profitability. Spark by MishiPay can show you the margin impact of different free shipping thresholds so you're not guessing.
Discount discipline. Instead of running 20% off site-wide and hoping for the best, you can see which products can absorb a discount and which can't. You can also measure whether past discounts drove incremental purchases or simply reduced the margin on orders that would have happened anyway.
SKU rationalization. Every product in your catalog has a carrying cost — warehouse space, photography, listing maintenance, customer support. If a product generates decent revenue but negligible profit after all costs, it might be a candidate for discontinuation or repricing.
Getting started with Shopify profit tracking
If you've been running your store on revenue data alone, you're not behind — most Shopify merchants are in the same position. The platform simply wasn't built to surface profit metrics.
Here's how to start:
-
Audit your COGS data. Even if you plan to use automated analytics, having reasonably accurate cost-per-item data in Shopify improves every downstream calculation. Prioritize your top 20 SKUs by order volume.
-
Know your blended shipping cost. Pull your last 90 days of shipping invoices and calculate your average cost per shipment. Even a rough number is better than ignoring shipping entirely.
-
Connect to analytics that calculates margin for you. Spark by MishiPay connects to your Shopify store in one click, pulls all the relevant data, and starts calculating true margins immediately. No spreadsheets, no formulas, no plugins.
Your Shopify data already contains most of what you need to understand profitability. The numbers are there — in orders, refunds, discounts, and product costs. They just need to be pulled together and calculated correctly. That's the part that should be automated.