wowprompt

Shipping rate table by weight and zone for an online store

Turns courier rate cards into one simple shipping table for your store, with weight slabs, zones, free shipping threshold and the cost you absorb. Use it when setting up checkout shipping charges or when the courier changes its rates.

A shipping charge table by weight slab and delivery zone, the courier cost behind each cell, the free shipping threshold, and a short customer-facing shipping note
The output this prompt produced, unedited.

The prompt

Goal

Set shipping charges customers find fair while the store does not lose money on delivery.

Inputs

  • Courier rate cards: [paste rates by weight slab and zone, including fuel surcharge and cash on delivery fee]
  • Typical parcel weights: [e.g. 80 percent of orders under 500 g]
  • Average order value: [amount]
  • Delivery zones you serve: [e.g. same city, same state, rest of country, remote areas]
  • Free shipping goal: [e.g. free above a certain order value, never, always]
  • Volumetric weight rule of the courier: [e.g. length x width x height / 5000]

Steps

  1. Build the courier cost table by weight slab and zone, including surcharges.
  2. Set the customer charge for each cell, rounded to a clean number.
  3. Calculate the free shipping threshold that keeps delivery cost under a stated share of order value.
  4. Flag products where volumetric weight exceeds actual weight.

Output format

  • | Weight slab | Zone | Courier cost | Customer charge | Store absorbs |
  • Free shipping threshold with the arithmetic shown.
  • Products to repack or price differently because of volumetric weight.
  • A shipping note for the store page, under 80 words.

Check before answering

  • Every courier cost comes from the rate cards given; none are estimated.
  • Cash on delivery fees are shown separately, not hidden in the slab price.
  • Remote area surcharges are listed if the courier applies them.
  • The customer note matches the table exactly.
shipping rate tableecommerce shipping chargesweight slab shippingfree shipping thresholdcourier rate comparisondelivery zone pricing

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