Shopify Profit Forecasting: How To Predict Future Store Revenue & Margin

Published: October 31, 2026 ET · Category:

Is your Shopify profit forecast just a guess in a spreadsheet? Here's exactly how to predict future revenue and margin—before you overstock and run out of cash.

Ad Slot: blogTop

Every merch seller I know runs the same two columns in a spreadsheet: last month's sales and last month's costs. And almost every one of them gets blindsided when next month doesn't look like last month. A POD store that sold 380 tees in September orders 600 for October, hits a flat week, and suddenly the bank balance that "should" be up $2,000 is sitting at a negative drawdown because the print supplier already invoiced.

But how do you predict what your store will actually make next month—before the money is already spent?

Why Your Profit Forecast Is Usually Wrong

Here's the uncomfortable truth: most Shopify sellers don't forecast profit at all. They forecast revenue, then subtract a "ballpark" cost that is always a few dollars too low per order. On a POD store, that gap is brutal.

Take Nina's merch store. She sells embroidered hats at $34, with a Printful production cost of $16.50 and shipping of $4.99. Her "profit per hat" was $12.51. When she finally built a real per-order cost line, she found another $2.20 in payment processing, $0.85 in allocated return liability, and $0.40 in print-error re-ships. Her true per-unit contribution was $9.06—28% lower than she thought.

That 28% error compounds across a whole forecast. Forecast 600 hats at $12.51 and you expect $7,506. Forecast at $9.06 and you get $5,436. That is a $2,070 gap—real money that was never actually going to exist.

The Three Inputs A Real Forecast Needs

Stop forecasting revenue. Start forecasting contribution. A usable Shopify profit forecast needs exactly three inputs, and each one is something you already have in your data.

1. Real contribution per order, not gross margin

Your Shopify product report only deducts the base product cost. It ignores shipping you pay, payment processing, and the return liability you carry. Build your per-order contribution the way a POD seller actually has to:

Line item Amount
Selling price$34.00
− Production cost (Printful/Printify)−$16.50
− Outbound shipping you absorb−$4.99
− Payment processing (2.9% + $0.30)−$1.29
− Allocated return liability (12% return rate × $9.06)−$1.09
− Allocated print-error re-ship−$0.40
True contribution per order$9.73

Notice I changed the return number. When returns are 12% of orders and each returned order eats about $9 in un-refunded cost, that's $1.09 per order of true contribution that your "gross margin" forecast never saw.

2. Forecasted order volume, segmented

Don't forecast one lump number. Split it. New customers driven by ads behave differently from repeat customers, and repeat customers carry higher contribution because you didn't pay a new acquisition cost on them. A POD store that ignores that split always over-forecasts ad-driven months.

3. Scenario, not single number

The single biggest forecasting mistake is committing to one "expected" number. Shopify's own playbook tells you to build three scenarios—base, best, worst—and see where your cash lands in each. A merch store that orders 600 tees on the base case and 400 on the conservative case is a store that keeps cash.

How To Build The Forecast (GitHub-Style)

Here is a working shopify sales forecast formula you can copy straight into a spreadsheet. Fill it with your real numbers before you place your next print order.

Metric Base case Conservative case Worst case
Forecast orders (next 30 days)600450350
True contribution per order$9.73$9.73$9.73
Contribution profit$5,838$4,379$3,406
− Fixed costs (apps, software, hosting)−$180−$180−$180
− Ad spend committed−$1,200−$1,200−$1,200
Projected net profit$4,458$2,999$2,026
Cash needed for next print order$3,000$3,000$3,000
Cash after order$1,458−$1−$974

The conservative case already wipes out the cash after that print order. That is the number you plan around, not the rosy base case. If your worst case puts you negative, you do not place the 600-unit order—you place 450 and re-order if the sell-through supports it.

The Strong Stance: Forecast Contribution, Never Revenue

Here's my hard position: a Shopify seller who forecasts revenue instead of contribution is not predicting store profit—they're gambling with the supplier's invoice. Revenue is a vanity number that ignores shipping, processing, returns, and re-ships. Contribution is the number that actually shows up in your bank account. I've watched sellers celebrate a projected $8,000 revenue month, only to find $600 of real contribution left after they paid the print bill. If your forecast spreadsheet has a "revenue" column but no "contribution" column, you don't have a forecast—you have a wish list.

Run Your Real Numbers In Seconds

Stop guessing whether the numbers hold. Open the Shopify profit calculator on the MerchCalc site, type in your selling price, your Printful or Printify production cost, shipping, and processing, and it returns your true per-order contribution in about five seconds. Use that as the "contribution per order" line in the table above, then run your three scenarios. That turns a guess into a number you can actually plan supplier orders around.

Why Merch Stores Miss This The Hardest

POD sellers think forecasting doesn't apply because "I don't hold inventory." That's the trap. You still commit cash to every print order, you still eat processing and return liability on every order, and you still have fixed costs. The only difference is your overstock is invisible—it's the markup you already paid to Printful before a single tee sold. That hidden cash lockup is exactly the gap between your reported profit and the cash you can actually spend, which is why a profit vs cash flow reconciliation belongs next to every forecast you build.

And forecasting hits merch stores hardest at exactly the moments the community complains about most. One seller on the Shopify community described it plainly: sales rise while cash falls, because growth consumes cash faster than payouts arrive. The forecast that catches that is the one built on contribution and scenarios, not the one built on "last month plus a hunch."

FAQ

How accurate should a Shopify revenue forecast be?

For a 90-day window, a properly segmented contribution model can land within about ±15% of reality. A 12-month forecast is harder and drifts wider, which is why you re-forecast every week or two as orders come in rather than setting it once.

What's the difference between forecasting revenue and forecasting profit?

Revenue is units times selling price. Profit (contribution) is units times your true per-order contribution after production, shipping, payment processing, and return liability. The second is the only number that pays your supplier invoice.

How do I forecast sales for my Shopify store?

Take last year's daily orders, line them up by weekday, multiply by your recent growth rate, and add what you know is different this year—a planned sale, a price change, or a product launch. Then price that volume with your true contribution per order, not gross margin.

Why does my Shopify payout not match my reported profit?

Because profit is booked on the order date while cash lands on payout date. Payouts lag 1–3 business days (up to 7 for new stores), and reserves, refunds, and ad charges can sit on top. A contribution forecast tells you what you'll earn; a cash reconciliation tells you when you'll see it. Another revenue trap that inflates your reported profit the same way is counting gift card and store credit as collected cash before it's ever redeemed.

Do POD sellers need profit forecasting if they don't hold stock?

Yes. You still commit cash to every print order, you still carry return and processing costs on every order, and you still have fixed costs. The only change is your "overstock" is invisible—already-paid markup sitting at the supplier.

What is a good profit margin for a Shopify POD store?

Contribution margin of 25–40% per order after production, shipping, and processing is a reasonable range for most merch. Below 20% leaves almost no room for ads, returns, and fixed costs. Forecast against your own contribution, not an industry guess.

How often should I re-forecast?

Weekly if you run ads or have a tight cash buffer, monthly otherwise. Every new print order or ad budget change is a trigger to rebuild the three scenarios. MerchCalc's Shopify profit calculator makes the per-order math take seconds, so re-forecasting stays cheap.

Ad Slot: blogMid
Ad Slot: blogBottom
← Back to Blog