Seller Profit Guard

Free shipping threshold formula, inputs, and assumptions

Last updated: 2026-07-29

Written and reviewed by Seller Profit Guard Editorial Team.

The calculator uses threshold = (product cost + shipping subsidy + packaging + fixed fee) ÷ (1 − percentage fee rate − target margin rate). A result exists only when the denominator is positive. Round upward, then test actual package, destination, product-mix, coupon, ad, and return cases before publishing a rule.

Free shipping threshold equation with four dollar inputs and two percentage inputs
A platform guarantee and a seller's economic threshold answer different questions.

What is the exact free-shipping threshold equation?

Let C be product cost, S the shipping amount funded by the seller, P packaging cost, F a fixed per-order fee, r the combined percentage fee rate, and m the target contribution margin. The calculator solves T − rT − C − S − P − F = mT. Rearranging gives T = (C + S + P + F) / (1 − r − m). The calculation assumes those entered dollar costs apply to the modeled order and that the percentage fees scale with the same revenue base.

With the default public dummy inputs, fixed-dollar costs are $12 + $6 + $1 + $0.30 = $19.30. The fee rate is 8% and target margin is 25%, leaving 67% of revenue to cover the dollar costs. The threshold is $19.30 / 0.67 = $28.81 after rounding to cents. A seller should normally set a practical rule above, not below, that estimate.

The threshold is not the price lift needed for one listing. It is the order value at which this simplified cohort reaches the entered target margin. If product mix, shipping class, package size, fixed charges, or fee bases change with cart value, create separate scenarios instead of treating one equation as a universal shop rule.

Algebra from order revenue and six free-shipping inputs to a minimum order threshold
The formula makes every included assumption visible.
SymbolInputDefault dummy valueEvidence
CProduct cost$12.00SKU or bundle cost record
SShipping subsidy$6.00Label plus adjustments
PPackaging$1.00Packaging bill of materials
FFixed fee$0.30Current fee evidence
rPercentage fees8%Scoped platform/payment assumption
mTarget margin25%Documented operating policy

How should each input be scoped and measured?

Product cost belongs at the same grain as the likely cart. A single-item threshold can use one SKU cost; a bundle or mixed cart needs the sum of its product costs. Shipping subsidy is the seller's expected postage and shipping-service cost after buyer-paid shipping or documented platform coverage, not merely the displayed shipping price. Packaging includes the materials consumed by that package, while labor remains outside the current quick tool unless the seller includes it transparently in product cost.

The percentage field is an editable combined assumption. Etsy's transaction fee, payment processing, Offsite Ads, regulatory fee, and taxes on seller fees can use different bases and applicability rules. Combining them is useful only when the modeled percentage reflects the intended cohort. A fixed fee belongs in F only when it actually applies per modeled order.

Target margin is contribution divided by modeled revenue after the entered costs and fees. It is not a tax margin, accounting net income, or cash deposit ratio. Record whether advertising, expected return loss, labor, overhead, discounts, and currency conversion are excluded. If they are material to the decision, add a buffer or use the full profit calculator.

Input scope matrix for SKU cost label cost packaging fee base and target contribution
Matching grain matters more than adding extra decimals.

When does the denominator invalidate the result?

The denominator is the share of revenue left to cover fixed-dollar costs after percentage fees and target margin. At 8% fees and a 25% target, 67% remains. At 30% fees and a 70% target, nothing remains, so no finite order value can satisfy the assumptions. A negative denominator is not a software failure; it exposes an internally impossible target under the entered model.

A very small positive denominator can also produce an impractically high threshold. If $19.30 of costs must fit into 5% of revenue, the threshold is $386. That result should prompt a review of the offer, included percentage costs, target, and product economics. Do not lower the target only to force an attractive number without recording the policy change.

Test zero costs, negative or malformed inputs, 100% combined shares, and values just below and above the boundary. The current quick tool converts missing numeric values to zero, so an empty cell can create false optimism. Operators should reject incomplete evidence rather than interpreting zero as measured absence.

Threshold behavior as fee plus target margin approaches one hundred percent
A shrinking denominator makes the threshold rise nonlinearly.

How is the economic threshold different from Etsy's US guarantee?

Etsy's official help states that an enabled free-shipping guarantee can apply to individual items of $35 or more and orders totaling $35 or more that ship to US buyers. That is a platform offer rule. The calculator's $28.81 dummy result is a seller-specific estimate from entered costs. A threshold below $35 does not change Etsy's guarantee, and a $35 platform guarantee does not prove the seller meets a 25% margin.

The official rules also distinguish US buyers from other destinations, allow shipping profiles for other free-shipping offers, and treat buyer-selected upgrades separately. Package weight, dimensions, origin, destination, and mail class can change label cost. The threshold must therefore be tied to an offer and shipping cohort, not copied from a platform headline.

Use a comparison table in the operating record: platform eligibility, buyer destination, currency or region conditions, lowest-cost service, upgrade treatment, actual seller subsidy, and calculated economic floor. This prevents a marketing setting from silently becoming a financial assertion.

Free-shipping formula questions

Should the result be rounded? Yes—round upward to a usable threshold and preserve the unrounded calculation.

Can one average shipping cost cover every order? Only for a documented cohort; heavy, distant, international, upgraded, or fragile cases need separate scenarios.

Does the formula include ads or returns? Not unless they are explicitly added through a broader cost or fee assumption.

Can the tool set an Etsy profile? No. It only calculates locally in the browser.

What proves a safe rule? Formula integrity plus representative and adverse live-order evidence after launch.

Which evidence supports this free-shipping threshold formula?

Use current carrier or Etsy label receipts for postage, adjustments, insurance, and services; packaging purchase records for mailers, boxes, inserts, tape, and protective material; product or SKU records for the cost of goods; and the Etsy Payment Account for fees tied to actual orders. Use shipping profiles and the current listing only to describe what the buyer is offered. A profile does not prove the seller's final label cost.

Record the analysis period, currency, destination cohort, package class, included costs, excluded costs, fee assumption, fixed fee, target margin, calculator version, and source dates. Reconcile a small public dummy example by hand before applying the result to a catalog. A file fingerprint proves that an input did not change; it does not prove that the input represents the next order mix.

Keep official platform rules separate from business assumptions. Etsy's US free-shipping guarantee can apply to qualifying US-bound orders of $35 or more after it is enabled, while the calculator derives a shop-specific economic threshold from entered costs and rates. Neither value proves conversion lift, tax treatment, carrier eligibility, or profit on every destination.

Privacy and commercial sensitivity for free-shipping threshold formula

The threshold calculation needs costs, rates, a package or cart scenario, and a target margin. Buyer names, email addresses, phone numbers, delivery addresses, order IDs, messages, personalization, and payment credentials are unnecessary. Use aggregate destination zones or public dummy locations rather than exposing a buyer's exact address. Seller Profit Guard runs this quick calculation in the browser and does not need an Etsy login.

Supplier prices, package dimensions, negotiated carrier rates, product mix, margin targets, and exception rules can reveal commercial strategy even without buyer data. Keep detailed worksheets in controlled storage. Public reports should use rounded dummy numbers, aggregate ranges, redacted product names, and non-reversible fingerprints. Never paste a private order row or label into an article, analytics event, ticket, email draft, or community post.

How to apply this free-shipping threshold formula in the calculator

Open the Free Shipping Threshold Calculator and enter product cost, seller-funded shipping, packaging, the combined percentage fee assumption, fixed fee, and target margin. The tool adds the four fixed-dollar costs, subtracts the fee and target-margin shares from one, and divides the cost total by the remaining revenue share. It reports no safe threshold when the denominator is zero or negative.

Round the result upward to a practical cart rule, then rerun at least a representative, adverse, and mixed-cart case. Confirm that the products likely to reach the threshold can actually produce the modeled cost mix. The output is a planning estimate, not an Etsy setting, carrier quote, conversion forecast, accounting profit statement, or promise that every qualifying order is profitable.

  1. Define one destination, package, product-mix, and offer cohort.
  2. Enter evidence-backed dollar costs and editable percentage assumptions.
  3. Hand-check the formula and round upward rather than down.
  4. Stress-test heavy, distant, upgraded, discounted, and mixed-cart cases.
  5. Publish only a bounded rule with owner, review date, exception, and rollback.

Sources and further reading

Related Seller Profit Guard tools

Next step: Open the Free Shipping Threshold Calculator.

This is operational planning help, not tax, accounting, legal, financial, or platform-policy advice. Review the Terms and disclaimer, and verify current platform rules and fee assumptions before changing prices.