Calculate free shipping thresholds against profit margins

Evaluate free shipping thresholds against gross margins and packaging costs to protect profit across different order sizes.

Prompt

Prompt
Act as an e-commerce financial analyst. Analyze my current order economics to determine if my free shipping threshold protects operating margins.

Rules:
- This provides general business financial analysis, not certified accounting advice; consult an accountant for tax and corporate filings.
- Calculate the net contribution margin in dollars and percent at three threshold tests: current average order value (AOV), free shipping threshold minus $5, and threshold plus $10.
- Flag negative margin risks where pick, pack, and shipping swallow profit.
- Recommend one exact threshold level that encourages larger cart sizes without eroding profit.

Output format:
Executive summary (3 sentences)
Margin comparison table (Columns: Order Value, Gross Margin $, Shipping Cost, Pick/Pack Cost, Net Contribution $, Net Margin %)
Analysis and threshold recommendation
Next actions to test

My product margin, shipping cost, and order value figures are below:

Example output

Example for: an apparel retailer with a $65 average order value and $75 free shipping target

Executive summary:
Offering free shipping at your proposed $75 threshold protects profitability while creating a natural cart-building incentive. At orders under $70, subsidizing ground freight reduces your net contribution margin below acceptable operating levels. Shifting your free delivery target to $80 increases average order value by roughly 12% without increasing baseline fulfillment costs.

Margin comparison table:

Order ValueGross Margin $ (60%)Shipping CostPick/Pack CostNet Contribution $Net Margin %
$65.00 (Current AOV)$39.00$0.00 (Customer pays $7.50)$3.50$35.5054.6%
$70.00 (Near Threshold)$42.00$7.50 (Store absorbs)$3.50$31.0044.3%
$85.00 (Recommended Target)$51.00$7.50 (Store absorbs)$3.50$40.0047.1%

Analysis and threshold recommendation:
Setting free shipping at $70 erodes your dollar profit relative to an un-subsidized $65 cart. Set your free shipping threshold at $80. This sits 23% above your $65 baseline, requiring customers to add at least one accessory or small replenishment item to qualify, guaranteeing a minimum $37 net contribution per order.

Next actions to test:

  • Test an on-site progress bar showing dollars remaining until $80 free shipping.
  • Add impulse items priced between $12 and $18 in the checkout cart drawer.
Written by AI from this prompt. Your results will vary.

Paste your average order value, gross margin percentage, average shipping cost, and current free shipping threshold into ChatGPT, Claude, or Gemini. Ask the model afterward how adding a free gift threshold compares to discounting shipping.

Make it repeatable

Keep using this prompt without pasting it in every time.

Keep exploring

More in E-commerce
E-commerce

Build a footwear sizing and fit guide

Create a comprehensive footwear sizing chart and fit advisory from product specs. Helps shoppers pick the right size on the first try to reduce return rates.