Free shipping threshold calculator for online stores

How much does a customer need to spend for you to cover shipping and still keep your target contribution? Enter your own costs in one currency, excluding tax.

Minimum order subtotal

Try the example with advertising costs

How the threshold works

Minimum subtotal = (shipping + other per-order costs + target contribution) ÷ (product margin rate − payment fee rate). Use decimals for rates. Round the result up to the smallest currency unit.

Example: at a 45% product margin and a 3% payment fee, $6 shipping, $2.30 in other costs and a $20 target require a $67.39 order. At $65 you would keep $19, one dollar below target.

Use margin on merchandise sales after discounts, before shipping and payment fees. This model holds product mix, shipping cost and fee rates constant. It covers orders qualifying for free shipping. Adjust separately for returns, advertising, tax and overhead.

How much is left after you pay to get an order?

Try the $48 order: what can you spend to win a customer?

Use one currency for all three amounts. Use revenue after discounts and exclude tax. Costs include the item, fulfilment, packaging and payment fees. Enter costs before advertising.

48 − 31 − 8 = 9. Your ad ceiling is 9 per order, in the currency you entered.

This is the amount available for one purchase, before fixed costs and income tax. The workbook example below is in Japanese yen.

See the Excel workbook for pricing, refunds and monthly profit

Try a worked example from the paid pricing workbook. In this fictional example, each order contributes JPY 1,530 before advertising and monthly fixed costs are JPY 10,000.

Contribution per order after ads
JPY 1,030
Monthly modeled profit after fixed costs
JPY 93,000

These illustrative results use different assumptions from the shipping calculator above.

Want to use your own costs, fees and refund rate?

The full Excel workbook lets you change 17 inputs and calculate the orders you need to break even. One purchase includes nine languages.

View the profit and pricing workbook
Try a scene from the films

English film with captions · The eighth order (30s)

Japanese film with Japanese captions · The order notification (31s)

HTS Voice Mei · MMDAgent Project Team, Nagoya Institute of Technology · CC BY 3.0