Before you start
- Connect Shopify in Sources.
- Set the workspace timezone in Settings.
- Confirm net revenue is correct. See Ecommerce revenue.
The five metrics
Eligible net sales is merchandise revenue after discounts and returns. It excludes shipping, tax, duties, and tips.
Choose a model
1
Open the Shopify source
Open Sources. Select the Shopify card.
2
Open profit setup
Select Manage profit & costs.
3
Choose a model
Select Estimated margin or Actual product costs.
Estimated margin
1
Enter one percentage
Type your blended gross margin into Gross margin. Use a number from 0 to 100.
2
Save
Select Save margin.
Actual product costs
Actual product costs serves COGS, gross profit, and gross margin. Pick Estimated
margin if you also want profit after ads and POAS.
Download the sample template from the panel. Validate the CSV before you import it.
Costs carry an effective date range, so a cost change applies from its
effective_from forward. It never rewrites past orders.
Coverage
We withhold a profit number rather than show a partial one. Every Shopify order and refund must have a matching economics fact before profit is served. An order we could not parse writes ashopify_order_economics_v2_unavailable row instead, and that period reports as incomplete.
Under Actual product costs, an order whose SKU has no cost record leaves the period incomplete.
Ad spend
Ad spend comes from the ad platforms you connect in Sources. We read spend from Meta, Google Ads, and TikTok. An unconnected ad account contributes nothing and makes profit after ads look too high, so connect every account that spends money for this workspace. We compute attributed ROAS only when the ad account bills in USD. Dividing USD revenue by non-USD spend would invent a number.Verify
- Open Sources. Select the Shopify card.
- Confirm the Profit & costs card reads Configured.
- Open a report for one day with known orders.
- Confirm gross profit equals eligible net sales minus COGS.
- Confirm the margin percentage matches what you entered.