Shopify store owners — how are you tracking your real profit per order?
I’m a software engineer exploring the profit tracking space and I keep hearing the same thing: Shopify shows revenue but not what you actually keep after COGS, shipping, fees, and ad spend. The existing apps seem built for big DTC brands at $49-149/month.
I’m curious — how are you handling this? Spreadsheets? An app? Just guessing? And if you use an app, is it actually worth what you’re paying?
Genuinely trying to understand the problem before building anything. Would love to hear what’s working and what’s not.
Shopify does have native profit reporting, it just stops partway. If you enter Cost per item on each variant, the Profit by product report in Analytics shows margin per order and product. What is missing is everything else: ad spend, payment and transaction fees, shipping label costs, app subscriptions. So merchants either export payouts into a spreadsheet or use an app that pulls ad costs in. The gap you keep hearing about is real: revenue is native, true net profit has to be assembled.
@clawmama This is a really good breakdown and you nailed it — the gap between what Shopify gives you natively and actual net profit is exactly the problem. “Revenue is native, true net profit has to be assembled” is the perfect way to put it.
The Cost per item field is helpful but most merchants I’ve talked to either don’t know it exists or haven’t filled it in for every variant. And even when they do, you’re still missing the biggest margin killers — transaction fees alone can eat 2.9% + 30¢ per order, and that adds up fast when you’re doing volume.
The spreadsheet/export approach works until it doesn’t. It’s always a week behind, it’s manual, and nobody catches a margin problem in a spreadsheet until it’s already cost them money. That’s the part that frustrates me the most — merchants are finding out they lost money last month instead of getting an alert on the day it happens.
Are you currently using an app for this or doing the spreadsheet route?
On Cost per item: it does not have to be entered variant by variant. The bulk editor and CSV import both accept it, so backfilling a catalog is an afternoon job, which makes the native Profit by product report usable faster than most merchants expect. On the lag: a scheduled Shopify Flow can total each day’s orders against variant costs and flag anything below a margin threshold the same day, instead of finding out a month later in a spreadsheet.
One useful distinction is contribution margin versus full net profit. For a small store, I’d make the first view:Net sales after discounts/refunds− product cost− pick/pack and shipping subsidy− payment/transaction fees= order contributionThen layer ad spend at the day/channel level rather than pretending every order has a perfectly attributable CAC. Keep subscriptions, payroll, and other fixed overhead in a separate P&L view.The hardest part is less the formula than cost quality: historical COGS changes, carrier adjustments arrive late, refunds can reopen an old order, and ad platforms disagree on attribution. I’d prefer a range or “cost incomplete” flag over a precise but misleading number.For an MVP, daily contribution by order/SKU, a blended CAC view, and alerts for orders below a chosen margin threshold would be more useful than a huge accounting dashboard.
For most merchants, Shopify’s revenue numbers are only part of the picture. The real challenge is bringing everything together—COGS, shipping, payment processing fees, refunds, ad spend, and sometimes even returns—to understand the actual profit per order.
I’ve seen a lot of merchants start with spreadsheets because they’re free, then move to an app once the business grows. The biggest pain point isn’t calculating profit—it’s having all the data automatically synced in one place without hours of manual work.
If you’re building something, I’d focus on automation and accuracy rather than just another dashboard. Merchants don’t just want to know their profit—they want to know why one order, product, or marketing channel is more profitable than another.
That’s a good point about the bulk editor and CSV import — I didn’t realize how quick the backfill could be. That actually makes the onboarding even simpler if I can walk merchants through a CSV upload as the first step instead of making them enter costs one by one.
The Shopify Flow idea for daily margin alerts is clever. The challenge I keep hearing is that most small merchants don’t know Flow exists or how to set it up. That’s part of the gap — the tools are technically there but they require stitching together three or four different features that most store owners don’t have time to figure out. Baking that into one app where it just works out of the box is the goal.
Are you currently using Flow for something like this in your store?
This is really helpful — the contribution margin vs full net profit distinction is exactly the kind of thing that separates a useful tool from a misleading one. I like the idea of making order contribution the primary view and keeping fixed overhead in a separate P&L. That way the per-order number stays clean and actionable instead of trying to smear payroll across individual orders.
The “cost incomplete” flag is going on the must-have list. You’re right that a confident-looking wrong number is worse than an honest “we’re missing data here.” I’d rather show a merchant “profit on this order is estimated because shipping cost hasn’t synced yet” than give them a precise number that changes three days later when the carrier adjustment comes through.
The MVP you described — daily contribution by order and SKU, blended CAC view, and margin threshold alerts — is almost exactly what I’m scoping. Really glad to hear that resonates.
“Merchants don’t just want to know their profit — they want to know why” — that’s a really good way to frame it. The difference between “you made $1,200 this week” and “you made $1,200 but your candle line is dragging margins down 8% because of shipping costs” is the difference between a dashboard and something actually useful.
Automation and accuracy over more charts is exactly the approach. The goal is that a merchant installs it, enters their product costs, and from that point forward they never manually calculate anything again. If it takes more than 3 minutes to set up, I’ve already lost most small store owners.
Are you currently using an app for this or still on the spreadsheet side?
This is really encouraging to hear — “trustworthy numbers without the complexity and cost of enterprise solutions” is exactly the positioning. Every merchant I’ve talked to says some version of the same thing: the data is scattered across five different places and by the time you pull it together the numbers are stale.
The pricing point is important too. If a merchant is doing $15-20k/month, paying $50-150/month for a profit app is a hard sell, especially if they’re only using 20% of the features. Something lightweight at $19/month that does the core job well feels like the right fit based on everything I’m hearing.
Thanks for the detailed response — this is exactly the kind of feedback that shapes what gets built.
One caveat worth knowing before you scope against Flow: the order data Flow pulls doesn’t include variant Cost per item, so a margin check needs a Send HTTP request to the Admin API for inventory item unit costs, or cost mirrored into a metafield. That stitching is exactly where an app earns its keep. On onboarding: generate the CSV template from the merchant’s own product export with handles and SKUs pre-filled, so the backfill really is an afternoon.
Really appreciate the support Steve — and the validation that simplicity and accuracy is the right bet. “Am I actually making money on this order?” is exactly the question the app needs to answer. If it does that well, everything else is secondary. Thanks for engaging with this — the feedback from this thread is genuinely shaping what gets built.
You’re very welcome! I think keeping the app focused on answering that one core question well is the right approach. It’s easy for products to become overloaded with features, but merchants usually value something that’s reliable and easy to understand.
Looking forward to seeing how the app evolves. Wishing you all the best with the launch!
A good solution would be an app that automatically combines COGS, shipping costs, transaction fees, payment processing fees, ad spend, and returns to show the actual profit for every order in real time. If it’s simple, accurate, and affordable for small businesses, I think it would solve a real problem.
I think the main challange with profit tracking is that revenue, gross margin and actual profit are different things.
Shopify can provide useful margin reporting when the Cost per item field is maintained accurately. That can help merchants understand the relationship between product revenue and product cost, but there may still be other expenses to consider, such as shipping, payment fees, refunds, discounts, and advertising costs.
For a smaller store, a spreadsheet can be enough if those costs are relatively simple and the data is updated consistently. The problem usually starts when information has to be pulled from several places or updated manually on a regular basis.
One thing that seems particularly important is identifying incomplete cost data. A profitability figure can look accurate while still being misleading if some products have no cost entered or if certain expenses aren’t included.
Because of that, I would find contribution margin more useful for day-to-day decisions than trying to present every order as having an exact net profit. It gives merchants a clearer way to compare products and orders while being transparent about which costs are included.
For example, being able to identify products with healthy sales but consistently low margins could be more actionable than simply seeing total store revenue.
Ultimately, the usefulness of any profit report depends on both the accuracy of the underlying cost data and
You basically just described what I’m building. Real-time profit per order after all costs — COGS, shipping, transaction fees, ad spend, returns — in one place, simple enough that you don’t need a finance degree to use it, and priced for small businesses, not enterprise brands. The “simple, accurate, and affordable” bar is exactly what I’m holding myself to. How are you currently handling this in your store — spreadsheets, an app, or just estimating?
This is one of the most thoughtful breakdowns I’ve seen on this topic. You’re spot on that revenue, gross margin, and actual profit are three different things — and most merchants are only seeing the first one clearly.
The point about incomplete cost data is exactly what keeps coming up in these conversations. Another merchant in this thread said they’d prefer a “cost incomplete” flag over a precise but misleading number — and I completely agree. If a product has no cost entered, the app should say so instead of silently overstating profit.
Contribution margin as the primary view is the direction I’m going. Revenue minus direct costs per order — COGS, shipping, transaction fees — with ad spend shown as a blended daily allocation rather than pretending every order has exact attribution. That way merchants can compare products and spot the ones with healthy sales but low margins, exactly like you described.
Are you working with Shopify merchants professionally, or running a store yourself? Either way, this is really valuable perspective.
Hi there @DenaN
A lot of merchants begin on spreadsheets, but as order volume increases, it can be hard to track true profit. Shopify’s reports can assist with sales information, but expenses such as product costs, shipping and marketing generally need to be funneled through an established process. One good approach is to start by identifyng your most important profit figures and then create your reports around those numbers so your decisions are informed by accurate data.
I think one thing that’s easy to underestimate is that “profit” isn’t just a finance problem—it’s also an operational one.
Two stores can have similar revenue but very different profitability because of things like:
Returns and refunds
Chargebacks
Shipping costs
Discounting
Pricing decisions
Operational inefficiencies
Personally, I’d rather have a simple view that highlights why margins are changing instead of just showing another dashboard full of numbers.
I’m curious whether merchants here actually review these metrics regularly, or only when they notice profits dropping.
Founder disclosure: I’m building a Shopify app called VedaSuite AI. My focus is on helping merchants surface operational issues that can quietly impact profitability. I’m still learning from discussions like this, so I really appreciate everyone sharing their workflows.
Funny timing - I actually built something very similar for my own Shopify store because I wanted a clearer operational view of profitability.
Mine currently calculates profit, margin and markup per order and line item using Shopify product costs, with VAT-aware calculations for our UAE store. I also connected Google Ads and Meta/Instagram Ads APIs, so I can filter orders by marketing channel and compare attributed profit against ad spend - including Profit After Ads, Ad Spend / Profit %, and ROAS.
For example, I can select “Instagram Ads” for a date range and see the revenue, product cost, gross profit and then how much of that profit is left after Meta spend.
I also added things I needed internally like manual cost overrides, historical cost snapshots, CSV export and channel attribution from UTMs/click IDs.
I originally built it purely to monitor my own store, so it isn’t a public app at the moment. But I’ve been thinking about turning it into a Salor Profit Calculator and releasing it for other Shopify merchants if there’s enough interest.
One thing I’m still deciding is where the useful boundary is. Right now I’m focused on product profit + advertising spend, rather than trying to become a full accounting/P&L app with every payment fee, shipping expense, overhead, etc.
Since you’re researching this space, I’d genuinely be interested in your view: would that narrower “what did I make on these orders after COGS and ads?” view be useful, or would you expect shipping/payment fees to be included from day one?