wowprompt

Self-ship versus marketplace fulfilment cost comparison

Compares the full cost per order of packing and shipping orders yourself against sending stock to a marketplace warehouse, including storage, returns, packaging and staff time, and shows which products should go where. Use it before a festive season, when a seller must decide what to stock in a fulfilment centre and what to keep shipping from their own shop.

A per-product cost table for both options, the cost difference per order and per month, a decision for each product and the assumptions used
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Products: [paste rows: name, price, weight, size, monthly orders, return rate]
  • Self-ship costs: [courier rate by weight and zone, packaging per order, staff time per order and hourly cost]
  • Marketplace fulfilment fees: [pick and pack, weight handling, storage per cubic foot per month, inbound shipping]
  • Stock you would keep in the warehouse: [e.g. 30 days of sales]
  • Effect on sales, if known: [e.g. faster delivery badge raised conversion by a stated share, or unknown]
  • Return handling cost for each option: [paste]

Calculate for each product

  1. Full cost per order for self-ship.
  2. Full cost per order for marketplace fulfilment, with storage spread across the units sold.
  3. The difference per order and per month.
  4. The break-even monthly order count where fulfilment becomes cheaper, if there is one.

Output format

  1. | Product | Self-ship cost per order | Fulfilment cost per order | Difference | Monthly difference | Decision |
  2. The products to send first, and those to keep self-shipping, with a one-line reason each.
  3. Assumptions used, and the three numbers that change the answer most.

Rules

  • Show the working for one product in full, so the seller can check it.
  • Use only figures given; mark any missing figure as unknown rather than guessing.
fulfilment cost comparisonself ship vs marketplace fulfilmentecommerce logistics costper order costwarehouse feesseller fulfilment decision

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