The Free Shipping Threshold Formula for Shopify Stores

Most Shopify stores set their free shipping threshold with a vibe. They multiply AOV by some number their agency mentioned, copy a competitor’s €75, and call it done. Then they wonder why AOV did not move.

A threshold set wrong costs money two ways. Too low and you give away shipping revenue with no AOV lift to show for it. Too high and customers see it, decide they cannot be bothered, and abandon. The threshold that actually works sits in a narrow band based on your current AOV, your margin, and your shipping cost per order, and nowhere else.

This guide gives you the formula. It also gives you EU country benchmarks the US-focused guides skip entirely, and a testing framework that acknowledges the one thing those guides refuse to address: you cannot A/B test a shipping threshold naively. The experiment you were about to run will not tell you what you think it tells you.

Run the math first. Then display the threshold correctly. Then test it over weeks, not days.

The Core Formula

The question most guides try to answer is “what should my threshold be.” The question you actually need to answer is “at what threshold does the AOV lift outweigh the shipping cost I am absorbing.”

Three inputs:

• Current AOV. Pull this from Shopify Analytics (Orders, then Average order value). Use the last 90 days.
• Your actual shipping cost per order. Not your shipping rate charged to customers. Your cost paid to the carrier, including packaging. More on how to calculate this in the next section.
• Your gross margin percentage. Revenue minus cost of goods sold, divided by revenue. Use a weighted average across your product mix, not the margin on your best seller.

The formula for your target threshold:

Target threshold = AOV × (1 + uplift multiplier)

Where uplift multiplier is the AOV increase you need to cover the shipping cost you are absorbing. For most stores, the viable range is 20-35% above current AOV.

Calculate the minimum uplift you need:

Minimum uplift = shipping cost / (AOV × gross margin)

That tells you what percentage AOV increase is required to break even on absorbed shipping.

Worked example

A Dutch Shopify store. Current AOV €72. Average shipping cost €5.50 per order (including packaging). Gross margin 45%.

Minimum uplift = 5.50 / (72 × 0.45) = 0.17, or 17%.

That is the break-even point. Below a 17% AOV increase from the threshold effect, you are losing money on the change. In practice you want headroom, so aim for 25%. Target threshold = 72 × 1.25 = €90.

Now the secondary check. Will a €90 threshold actually pull orders up from the €72-89 range?

For most stores in the NL and EU market, yes. The progress-bar effect (section 4) reliably pulls 30-50% of orders in the near-threshold band up to the threshold. If your order value distribution is mostly in the €40-60 range with a thin tail at €80-100, a €90 threshold is too aggressive and you should run the calculation again at a lower multiplier.

When the formula breaks

The formula assumes a single-peak distribution of order values. It does not work cleanly for:

• Very low AOV. Below €40, customers are buying single-item orders and the “add another item to qualify” behavior collapses. Threshold lift effects are marginal.
• High shipping cost variance. If you ship some orders for €3 and others for €18 (mixed light and heavy items), the average misleads you. Calculate thresholds per product category or per weight band instead.
• Sub-30% gross margin. At thin margins, the shipping cost eats your profit on every order that qualifies. The threshold needs to be set high enough that the incremental orders are worth less in percentage terms than you might assume.

Calculating Your Actual Shipping Cost Per Order

The number you need is not your shipping rate table. It is what you actually pay the carrier, plus packaging, averaged correctly across your order mix.

Shopify Analytics gives you part of this. Go to Reports, then Finances, then Transactions. Filter by “shipping.” That gives you shipping revenue received. For cost paid, check your carrier dashboard (PostNL, DHL, UPS, DPD) or your 3PL invoice.

Two common mistakes that produce wrong thresholds:

Unweighted averages. Adding up shipping costs and dividing by number of orders treats a one-parcel €3 order the same as a three-parcel €15 order. Use order count as the weight, not parcel count. Shopify’s analytics report does this correctly if you filter on the Orders level.

Forgetting packaging. Boxes, tape, paper, labels, picking labor. For a typical EU Shopify store, packaging adds €0.40 to €1.20 per order on top of carrier costs. Include it.

Weight and size variation

If your products vary significantly in weight or size, a single shipping-cost number will lead you to a threshold that is right on average and wrong for most individual orders.

Two approaches, depending on how much variance you have:

• Mild variance (most orders within 30% of average shipping cost): the average works. Run the formula once.
• High variance (some orders cost 3x more to ship than others): set thresholds per weight band. Shopify supports weight-based shipping rules natively. A threshold of €75 for orders under 2kg and €110 for orders above 2kg prevents the “free shipping on a 10kg order” margin disaster.

Stores that skip this step and use a single threshold for all products see their heaviest orders become unprofitable, and eventually realize their “free shipping is lifting AOV” is actually “free shipping is lifting AOV only in specific product categories while losing money in others.”

EU Country-Level Threshold Benchmarks

This is the section you will not find in any US-written guide. Free shipping psychology is not universal. It varies measurably across EU markets, driven by local delivery norms, payment method preferences, and baseline expectations.

Netherlands (NL)

Dutch consumers expect free shipping by default. Bol.com trained the market. A threshold above €50 is increasingly treated as “high shipping,” even on premium stores. The iDEAL payment step is fast and frictionless, so price sensitivity at the final step is sharp.

Typical viable threshold for NL: AOV × 1.15 to AOV × 1.30. Aim low. If your AOV is €65, a €75 to €85 threshold converts better than a €95 one. Display the threshold on the product page, not just the cart, because iDEAL’s redirect pattern means customers decide on shipping during product browse, not at checkout.

Belgium (BE)

Similar to NL for Flemish consumers, slightly more tolerant for Walloon. Bancontact parallels iDEAL in payment friction, so the same psychology applies. Use the NL benchmark as a starting point.

Germany (DE)

German consumers tolerate higher thresholds. Rechnungskauf (buy now, pay invoice) is a separate psychological lever that reduces shipping-cost objections, since the customer is not paying at purchase time. Threshold ranges of AOV × 1.30 to AOV × 1.45 are viable. Trust signals at the shipping step matter more than the threshold number itself.

France (FR)

Relay-point delivery (Mondial Relay, Colissimo Chronopost) changes the shipping calculation. Relay-point delivery is often free or low-cost and the preferred option for many French consumers. Setting a threshold for home delivery while offering free relay-point pickup at any order value is a common pattern that works well.

UK

Closest to US behavior. AOV × 1.25 to AOV × 1.40 works for most categories. Amazon Prime has anchored expectations around one-to-two-day free delivery, so the trade-off between threshold and delivery speed is explicit.

Nordics (SE, DK, NO, FI)

Higher AOV baseline, higher tolerance for elevated thresholds. AOV × 1.35 to AOV × 1.50. Delivery reliability matters more than the threshold itself in these markets.

The Threshold That Actually Lifts AOV

The formula tells you what threshold breaks even. The display pattern determines whether it lifts AOV at all.

The single most effective mechanism is a cart progress bar. A bar that shows “€8 more to unlock free shipping” converts the abstract threshold into a small, achievable goal. The psychology is goal-gradient: customers approaching a goal accelerate their effort toward it. For cart-progress-bar display on Shopify, you typically see 30-50% of orders in the near-threshold band (10-20% below the threshold) nudge up to qualify.

Without the progress bar, the same threshold has a fraction of the lift. Customers either know the threshold and buy accordingly, or do not know it and do not adjust. The progress bar is what activates the behavior.

Where to display the progress bar

• Cart drawer (Shopify mini-cart): the highest-impact location. Customers see the bar the moment they add an item, while they are still shopping.
• Cart page: essential. Use both €-remaining and percentage.
• Checkout: low-impact. Customers at checkout have already committed. Leave it out if you need to reduce visual noise.

Copy patterns that perform well: “€8 more to unlock free shipping” beats “78% of the way to free shipping” for most audiences. Euro amounts are concrete. Percentages are abstract.

Bimodal AOV distribution

If your order values cluster at two separate levels (a batch of €40 to €50 single-item orders and a batch of €120+ multi-item orders), a single threshold optimized for the mean will miss both clusters. Small orders will not add enough to qualify. Large orders already qualify without needing the incentive.

Two options:

• Set the threshold at the lower cluster’s upper edge plus 20 to 30%. This makes the threshold relevant to the small-order segment without giving away shipping on already-qualifying large orders.
• Use a tiered incentive. Free shipping at €60, 5% off at €120, free gift at €180. The progress bar advances through multiple goals, keeping the mechanism relevant across order-value ranges.

Testing Your Threshold

This is the section where most guides say “run an A/B test” and move on. That advice is wrong. You cannot A/B test a shipping threshold naively. Here is why and what to do instead.

Why naive A/B tests fail

Shipping thresholds interact with customer memory and repeat behavior. If you show half your traffic €75 and half €90 for two weeks, your returning customers (who learned the old threshold) will be confused. Your cookie-persistence test-assignment will fail for multi-device shoppers. Your holdout group will see the old threshold in cached pages.

Worse, shipping thresholds have a slow-burn effect. The first week of a new threshold shows mostly the wrong signal: customers who would have bought at €75 either qualify at €75 (in control) or do not qualify at €90 (in variant), and you see a conversion drop. The AOV lift from the uplift multiplier takes three to six weeks to materialize as customers encounter the new threshold and adjust behavior.

The approach that works

Time-split testing over 4 to 6 weeks. Run the baseline threshold for 2 weeks. Switch to the new threshold. Measure the following 4 weeks. Compare. This avoids the assignment-pollution problem and gives the slow-burn effect time to materialize.

Market-split testing. If you sell across multiple EU countries on the same store, test the new threshold in one country while keeping the baseline in others. Country serves as the natural cohort.

Metrics that matter. Do not measure conversion rate alone. Measure:

• Conversion rate (should be flat or up)
• AOV (should be up)
• Orders-per-visitor (should be flat or up)
• Gross profit per visitor (the only metric that matters for the shipping threshold decision)

Revenue per visitor can look fine while gross profit drops. If your threshold change lifts revenue €0.50 per visitor but costs €0.70 per visitor in absorbed shipping, you are losing money despite the “lift.”

Red flags

AOV flat, conversion drops. Threshold is too high. Customers see it, give up, do not buy.

AOV flat, margin drops. Threshold is too low. Customers who already bought at this value just got free shipping at your expense.

AOV up, conversion up, margin flat or up. Threshold is right. Roll out permanently.

Seasonal Adjustment

Shopping behavior shifts in Q4. Customers spend more, tolerate higher thresholds, and expect promotions. The thresholds that worked in Q2 are suboptimal in November and December.

Approach:

• Q4 (October to December): shift threshold up by 15 to 25%. Customers expect higher order values around gifting, and their shipping tolerance shifts with it. In NL, Sinterklaas (December 5) creates a predictable early-December AOV peak. In DE, the pre-Christmas shopping period runs longer and spreads through November.
• Post-holiday (January to February): shift threshold back down, or consider a temporary “free shipping on any order” during the January slump. Conversion is the constraint in this window, not AOV.

Re-run the formula quarterly. More often if your product mix or shipping costs shift.

Displaying the Threshold in Shopify

Mechanics. Shopify supports threshold-based free shipping natively through Settings, then Shipping and delivery. Add a shipping zone, add a flat shipping rate, then add a second rate that is free with a minimum order condition. That handles the backend.

The front-end display is where most stores miss the opportunity.

For cart progress bar functionality:

• Native Shopify themes (Dawn, Sense): support cart drawer messaging natively. Configure through Theme Customizer.
• Free Shipping Bar by Hextom: app-based progress bar. Simple to configure. Works across themes.
• Rebuy: if you are already using Rebuy for upsell, the progress bar is part of the suite and integrates cleanly with cart recommendations.
• Gift Ship: adds progress bar plus tiered-gift functionality if you want multi-tier incentives.

Placement priority: cart drawer first, cart page second, everything else later. The cart drawer impression rate is 3x to 5x higher than the dedicated cart page on typical Shopify stores.

Copy examples that perform:

• “You are €8 away from free shipping”
• “Add €8 more to unlock free shipping”
• “Free shipping at €75. You are at €67.”

Avoid: “78% of the way to free shipping.” Percentages are abstract. Euro amounts are immediate and actionable.

When Free Shipping Thresholds Do Not Work

Three scenarios where thresholds fail and you should use a different model.

Low-margin categories (grocery, perishables, some beauty). Margins under 25% cannot absorb shipping reliably. Flat shipping rates plus transparent display are a better path than a threshold. Focus the conversion effort on cart-size promotions or subscribe-and-save, not free shipping.

Very high AOV (luxury, furniture). When AOV is €500+, a threshold set at any reasonable multiple is meaningless because nearly every order already qualifies. Use flat-rate shipping prominently displayed, and focus instead on delivery-speed tiering or white-glove service as the conversion lever.

Subscription-native businesses. Monthly boxes already have a fixed per-box economic model. A threshold on a single box makes no sense. Use subscription-included shipping as a core value proposition instead, and price the subscription to cover it.

Free Shipping Threshold FAQ

Have a specific threshold question about your store? Book a call

How do I set a free shipping threshold on Shopify?

Go to Settings, then Shipping and delivery. Select the shipping profile for your store and add a shipping rate. Choose 'Free shipping' and set a minimum order requirement. Apply it to the regions you want to cover. Display the threshold visibly in your cart drawer with a progress bar, either through your theme's built-in cart messaging (Dawn, Sense) or an app like Free Shipping Bar or Rebuy. Stores that display the threshold in the cart drawer see measurably higher attainment than stores that hide it at checkout.

What does free shipping threshold mean?

A free shipping threshold is the minimum order value at which shipping becomes free for the customer. Below the threshold, the customer pays shipping. At or above the threshold, the store absorbs it. The purpose is not to give shipping away; it is to lift average order value by incentivizing customers to add items to qualify. A correctly calibrated threshold increases both conversion rate and AOV simultaneously.

What is the $200 threshold on Shopify?

Some merchants refer to a $200 threshold because that is a common default Shopify suggests in its shipping setup flow. It is not a recommendation. $200 is too high for most Shopify stores; the right threshold for your store depends on your current AOV, your shipping cost per order, and your gross margin. For stores under €10M revenue, a threshold 20 to 35% above AOV is usually the viable range. Run the formula above to calculate yours.

How do I calculate my free shipping threshold?

Multiply your current AOV by 1.20 to 1.35 as a starting point. Then check the break-even constraint: minimum uplift = shipping cost per order divided by (AOV × gross margin). If the resulting percentage is above 25%, your margins may not support a threshold; consider flat shipping with transparent display instead. For most Shopify stores with AOV €50 to €120 and margins 40 to 50%, a threshold 20 to 30% above AOV is the viable range.

Should I set free shipping at €35 or €100?

Neither, probably. The right number depends on your AOV. €35 is almost certainly too low for any store with AOV above €50; you will give away shipping on nearly every order without meaningful AOV lift. €100 is only appropriate for stores with AOV €70+ or a premium positioning. The question is not 'round number,' it is 'AOV × 1.20 to AOV × 1.35.' Pick the specific number your formula produces, not a marketing-friendly round one.

Related Reading

• 10 Proven Strategies to Increase Average Order Value
• Top 12 Tips for Ecommerce Checkout Optimization in 2025
• Abandoned Cart Best Strategies to Recover Lost Sales
• Ecommerce Checkout Optimization EU Edition

---

Want someone to tell you exactly what threshold your store should run? A QuickScan is a 30-minute recorded teardown of your cart and checkout that includes threshold math using your specific numbers. Or book a call to discuss your store.