# Set one flat shipping rate that covers your real costs

> It tests a flat rate, a free-shipping threshold and two tiers against your own past orders, with the math shown.

Give Gemini your recent orders with weights and real shipping costs, and get three flat-rate options compared side by side, with what customers pay and what you keep.

- Page: https://thesolocreators.com/prompts/flat-shipping-rate-from-past-orders/
- Category: Make smarter decisions
- Made for: Small business owners, Creators
- Works in: Gemini, ChatGPT, Claude
- Time: About 15 minutes
- Effort: A few steps
- Note: Gemini in Google Sheets needs Google AI Pro or Ultra, or a Workspace Business plan. Pasted data works in any tool.
- Published: 2026-11-01

## How do I pick a flat shipping rate for my small business?

Paste your recent orders, with weight, region and real shipping cost, into Gemini and have it test a few flat-rate options against them. If your orders already live in Google Sheets, the Ask Gemini side panel (as of November 2026) can read them in place, but it needs a paid Google AI or Workspace plan. If you'd rather not, copy the columns into ChatGPT or Claude and use the same prompt. More orders give a fairer answer.

## The prompt

Fill in the parts in [square brackets], or leave them and the AI will ask you for them.

```text
I run [YOUR BUSINESS, e.g. a handmade soap shop] and my shipping costs swing too much. Below are my last [NUMBER OF ORDERS, e.g. 90] orders with order total, package weight, destination region and what shipping really cost me: [YOUR ORDER DATA]. Please: 1) show my average, lowest and highest real shipping cost, and how it changes by weight and region, 2) suggest one flat rate that covers my cost on at least 90 percent of orders, plus what I'd have gained or lost over these orders at that rate, 3) test two other options: a lower flat rate with a free-shipping threshold, and two tiers by order size, 4) put all three in one table with what customers pay and what I keep, and 5) recommend one in plain words and tell me what to watch next month. Show your math.
```

## Step by step

1. Open your orders sheet in Google Sheets.
2. Click Ask Gemini in the top right to open the side panel.
3. Paste the prompt and point it at your order columns, or paste the data into any chat.
4. Pick the option you like and update the rate at checkout.

## What you'll get

A side-by-side table of three shipping options tested on your real orders, plus a plain recommendation and the math behind it.

## Good to know

**How do I pick a flat shipping rate for my small business?** Paste your recent orders, with weight, region and real shipping cost, into Gemini and have it test a few flat-rate options against them. If your orders already live in Google Sheets, the Ask Gemini side panel (as of November 2026) can read them in place, but it needs a paid Google AI or Workspace plan. If you'd rather not, copy the columns into ChatGPT or Claude and use the same prompt. More orders give a fairer answer.

**Which AI tools does this work in?** It works in Gemini, ChatGPT and Claude. On this page, ChatGPT and Claude open with your prompt already typed in. Gemini in Google Sheets needs Google AI Pro or Ultra, or a Workspace Business plan. Pasted data works in any tool.

**How long does it take?** About 15 minutes. It's rated "A few steps". There are 4 steps, listed above.

**What do I need before I start?** Just your details for 3 blanks: your business, number of orders and your order data. You can skip any, and your AI will ask for them.

**What will I get back?** A side-by-side table of three shipping options tested on your real orders, plus a plain recommendation and the math behind it.

Idea spotted on X, shared by @GoogleWorkspace: https://x.com/GoogleWorkspace/status/2116153898482213305. The prompt is The Solo Creators' own version.

## Go further

Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: Board of Advisors (Convene seven AI advisors who debate your decision, vote, and hand back a stress-tested verdict); Fact Checker (Every quote, number, date, and link in your draft checked against its real source, with the fixes handed back as tracked changes you accept or reject).

From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.