wowprompt

Free shipping threshold from order values and margins

Works out a free shipping minimum order value from your order data, shipping costs and margins, shows what it does to profit per order, and writes the cart and banner messages to match. Use it when shipping eats your margin, when the average order is just below a round number, or before a sale season.

A table comparing three threshold options with orders affected and profit per order, a recommended threshold with reasons, and short cart and banner copy
The output this prompt produced, unedited.

The prompt

What to give

  • Order values for the last 60 to 90 days: [paste a list, or the distribution in bands such as 0 to 499, 500 to 999]
  • Average order value now: [amount]
  • Average shipping cost per order, by zone if known: [amounts]
  • Average gross margin as a percentage: [e.g. 42 per cent]
  • Current shipping rule: [e.g. flat fee of [amount], free over [amount], always free]
  • Products often added to reach a threshold: [e.g. socks, refills, accessories under [amount]]
  • Competitor thresholds seen: [amounts, or none]

Task

Recommend one free shipping threshold and show the numbers behind it.

Checklist

  1. Find where orders bunch up, and set candidate thresholds about 15 to 30 per cent above the current average order value.
  2. For each of three candidates, estimate the share of orders already above it and the share within reach (within 20 per cent below it).
  3. Profit per order at each candidate: margin on the order minus shipping cost, for orders above and below it.
  4. Check that low-priced add-on items exist to close the gap for orders just below.
  5. Say how long to test the threshold and which numbers to watch: average order value, conversion rate, shipping cost as a share of revenue.

Output format

  1. | Threshold | Orders already above | Orders within reach | Profit per order above | Profit per order below |
  2. Recommendation in three sentences.
  3. Copy: a site banner under 60 characters, a cart progress message with [amount left], and a product page line.

Guardrails

  • Show every calculation in one line; mark any assumed number as [assumption].
  • Do not predict an exact revenue rise; give the break-even condition instead.
  • Keep remote or heavy-item zones as an exception if their shipping cost breaks the rule.
free shipping thresholdaverage order valueshipping costecommerce margincart messageminimum order value

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity