In Shopify: Orders → Export → Export orders (CSV). Use last 90 days minimum. Shipping revenue is subtracted and GST stripped automatically. Orders below the minimum value are excluded. Your data never leaves your browser.
📂
Click to upload or drag & drop
Shopify orders export (.csv)
Minimum order value filter
$
Excludes $0 orders, gift cards and very low value orders. Default $10.
Step 2 — Your store numbers
Used to calculate gross profit, contribution margin and net profit separately — and to model LTV uplift from new customer acquisition.
Gross margin
%
Revenue minus COGS ÷ revenue
MER %
%
Ad spend ÷ revenue × 100
Monthly OPEX
$
Wages, rent, software, 3PL
Your shipping cost per order
$
What YOU pay to ship
Returning customer rate
%
% of orders from returning customers. From Shopify Analytics.
Cost of free gift optional
$
What the gift costs you at cost price
Conversion uplift — from Shopify Analytics
A lower or more reachable free shipping threshold converts browsers who abandoned due to shipping cost. Enter your traffic data to model new orders created — often larger than the AOV nudge effect.
Monthly sessions
Shopify Analytics → Overview
Current conversion rate
%
Shopify Analytics → Overview. Sitewide CVR.
Add-to-cart rate optional
%
Shopify Analytics → Behaviour. Default 10% if unknown.
Customer LTV — from Shopify Analytics
Analytics → Overview for revenue. Customers → All customers, filter last 12 months for unique count. Used to calculate 12-month LTV per customer.
Total revenue — last 12 months (inc. GST)
$
From Shopify Analytics overview — inc. GST
Unique customers — last 12 months
From Shopify Customers report — unique buyers
Step 3 — Test your thresholds
Enter your current thresholds and type new ones to test. The P&L and recommendation update instantly as you type.
Free shipping
Current free shipping threshold (inc. GST)
$
Enter 0 if you don't offer free shipping
Shipping rate charged to customers
$
Flat rate customers pay when below threshold
Test new free shipping threshold (inc. GST)
$
Enter a new threshold to test — results update instantly. Set same as current to see existing state.
Free gift with purchase optional
Current free gift threshold (inc. GST)
$
Enter 0 if you don't offer a free gift
Requires cost of free gift to be entered in Step 2.
Test new free gift threshold (inc. GST)
$
Optional. Enter 0 or leave blank to skip. Requires cost of free gift in Step 2.
Chart bucket size
Store overview
Loading...
$0
Mean AOV
Simple average
$0
Median AOV
True middle order
$0
Mode AOV
Most common value
$0
Gross profit / order
After COGS
$0
Contribution / order
After COGS, ads & shipping
$0
Customer LTV
12-month gross LTV
Order value distribution
Product revenue only, ex GST. Shaded zones = orders affected by threshold change.
🚚 Free shipping — current none → proposed $0
Who will actually spend more?
P&L impact — per month
🎁 Free gift — current none → proposed $0
Who will actually spend more?
P&L impact — per month
🛒 Conversion uplift — new orders from shipping-sensitive browsers
48–55% of cart abandonments cite unexpected shipping costs (Baymard Institute). A more reachable threshold converts a portion of these browsers into paying customers — modelled below across three scenarios.
New orders created — conservative to optimistic
Combined P&L — nudge uplift + conversion uplift
The Boom take
All calculations run in your browser. No order data is uploaded or stored anywhere.