Shopify workflow

Calculate Break-even ROAS from Shopify Reports

Start with a consistent sales basis, then add the order costs Shopify cannot know or may not include in the same report.

60-second answer

Use net sales per order as the starting point.

For the ROAS Break model, start with Shopify net sales for a mature period, divide by the corresponding order count, and exclude tax. Reconcile shipping revenue separately. Then add landed product cost, fulfillment, payment or marketplace fees, return handling, and any other variable order cost not already reflected in net sales.

Model AOV = mature net product sales / corresponding orders

Do not double-count: If returns have already reduced net sales, do not enter the same refunded revenue again as a returns allowance. Add only economic losses that remain outside the sales figure.

Shopify field map

Translate report fields into model inputs.

Shopify or ledger field	ROAS Break input	Check
Net sales	Average order value numerator	Confirm discounts and mature returns are reflected.
Orders	Average order value denominator	Use the order population matching net sales.
Cost of goods sold	Product cost	Confirm landed costs and missing product costs.
Shipping charges	Revenue reconciliation	Do not hide merchant shipping cost inside it.
Taxes	Exclude	Do not treat tax collected as acquisition budget.
Payment or marketplace fees	Fee percentage or variable cost	Use processor or marketplace statements.
Fulfillment and return handling	Fulfillment / other variable cost	Use 3PL, carrier, warehouse, and return records.

Worked report

A reconciled $85 order breaks even at 2.05x.

Suppose a mature report shows $100 average gross product sales, $10 discounts, and $5 returns. Net product sales are $85 per order. The order has $30 landed product cost, $8 fulfillment, $3 return handling or other variable cost, and fees equal to 3% of net revenue.

Step	Amount
Net product revenue	$85.00
Product cost	-$30.00
Fulfillment	-$8.00
Other variable cost	-$3.00
Fees, 3%	-$2.55
Contribution before ads	$41.45

Break-even ROAS is $85 / $41.45 = 2.05x. At 2.40x attributed ROAS, acquisition cost is $35.42 per order and the model retains about $6.03 contribution after ads.

Open the Shopify report example

Before using the result

Check maturity and missing costs.

Use a period old enough for normal refunds and returns to appear.
Check whether product cost is populated for every product and variant.
Separate customer-paid shipping from the carrier and fulfillment cost paid by the merchant.
Add payment, marketplace, currency, chargeback, and return-handling costs when material.
Match the ad platform's conversion-value basis as closely as possible before comparing reported ROAS with the floor.

Shopify sales reportsGross sales, discounts, returns, net sales, and total sales. Checked August 20, 2026.
Shopify profit reportsProduct cost and profit reporting. Checked August 20, 2026.