Thinking about returns creeping up 2 points over a few weeks. Discount codes
eating a bit more each month. Real shipping cost drifting up.
On their own each number looks fine, so nothing ever alerts you. But put
together they eat your margin.
I’m setting up my store right now and I’m curious how people with real volume
handle this. Do you have a system, a routine, a file you check? Or do you find
out at the end of the year?
This is exactly the kind of problem that hides in plain sight. I’d keep a small baseline table rather than add another dashboard: return rate by reason, discount share, actual shipping cost, and contribution margin per order.
Review the first three daily for anomaly detection, then review the combined story weekly. If returns rise only on one product or market, that is a very different action from a store-wide margin leak.
I’d also check data freshness before reacting. A “slow decline” can be real, but it can also be a late refund feed or a changed shipping allocation. The useful alert is not “a number moved”; it is “this segment’s profitable buying path moved outside its normal range.”
Let’s start from simple question - how many IT resources do you use for this?
In my personal career we usually built many “sanity checks monitors and alerts” for these type of issues. Basically you fetch all the numbers to the data storage and automate reports. Are using something like this?
If not: I’d check this weekly manually rather than wait for month-end reports.
A simple spreadsheet is enough: track return rate, discounts as a percentage of sales, shipping cost per order, and contribution margin. Compare each week with the previous four. One odd week may be noise, but a number moving the same way for several weeks needs attention.
Then break it down by product, market, or discount code. Storewide averages can look fine while one product quietly loses money.
I’d spend 15 minutes on this every Monday. Since you’re still setting up (but how there are real volumes
), compare actual results with the assumptions behind your pricing. Over time, your own numbers become the baseline.
Hello @BBprime10
I wouldn’t wait until the end of the year for this. I’d suggest doing a simple margin review every month. Look at your revenue after discounts, product costs, shipping, returns, and payment fees, then compare that number with the previous month. If your margin drops compared with the previous month, you can then look at which cost changed.
For discounts, setting a clear limit and checking whether each promotion is actually generating enough additional sales to justify the reduced margin can help keep things under control. Even a basic spreadsheet is enough to get started.
Hope this gives you a good starting point to figure it out.
What works for us is one weekly sheet, but we compare order cohorts rather than calendar weeks. Returns lag, so this week’s refunds divided by this week’s sales can give a false signal.
- Every Monday, export orders, refunds, discounts, shipping labels, and payment fees.
- Calculate contribution per order: net sales minus product cost, outbound shipping, payment fees, and refunds.
- Compare the latest completed 4-week period with the prior 4 weeks. Investigate any cost line that moves over 10% or margin that drops 2 points.
- Then split the change by SKU, discount code, country, and carrier. Usually one segment explains most of the drift.
I also keep the review to 20 minutes. If something trips the threshold, that becomes a separate task rather than turning the weekly check into a full audit.
At zero volume, the most useful thing you can do today is write down what you think those numbers are going to be.
- Target return rate
- What share of revenue you’re willing to give away in discounts
- What you think shipping should cost per order
- The margin you priced against, etc
In three months, the weekly review everyone’s describing becomes genuinely useful, because you’ll have something to measure the drift against. Of course, your standard may change over time, but it’s good to have a target.
I would add one operational measure alongside the margin numbers: how long orders spend waiting at each handoff.A slow increase in orders waiting for stock confirmation, production, picking, or carrier collection often shows up financially only later as expedited shipping, refunds, extra discounting, or “where is my order?” support work.
The useful comparison is not simply an average. Look at the share of orders that exceed the promised or expected time for that step. A small number of unusually delayed orders may be normal; a steady increase is an early warning that the process is starting to lose capacity or something has changed upstream.
I would review that weekly with the margin table. If shipping cost, refunds, and delayed handoffs are all moving in the same direction, that is usually a workflow problem rather than three unrelated numbers.
Hi there @BBprime10
I would encourage you to check these numbers on a routine basis as opposed to holding off until the end of the year. In Shopify, you can monitor returns, discounts, shipping expenses, and sales trends in your analytics and reports, and then you can compare them on a weekly or monthly basis.
Just like that, a monthly margin analysis can help you detect small changes before they get expensive. I’d set some thresholds on returns, discounting and shipping costs, and then look into it whenever one or more swings out of the norms. The key is to be consistent, not more complicated.