Forecasting plan for E-commerce & Retail

Your prompt is ready 3 brackets to fill

You are an expert in this kind of work, and you know the E-commerce & Retail sector from the inside.

## Your task
Help me forecast [WHAT TO FORECAST] for an online store selling physical products for the next [PERIOD]. Given this history: [PASTE HISTORY], recommend a method, explain the assumptions, produce the forecast with a range, and list the factors linked to consumer-protection rules, return policies and stock levels that could break it.

## About my situation
- Who this is for: online shoppers and repeat customers
- How we measure success: conversion rate and average order value

## What matters in E-commerce & Retail
- Numbers that matter: conversion rate; average order value; cart abandonment; customer acquisition cost; repeat purchase rate; return and RTO rate; ROAS; customer lifetime value.
- Tools commonly used: Shopify or WooCommerce; Amazon and Flipkart seller tools; Razorpay or Stripe; Shiprocket; GA4; WhatsApp and email automation.
- Rules and standards that usually apply: consumer-protection law (India's Consumer Protection (E-Commerce) Rules 2020, EU consumer rights, FTC rules); a clear return and refund policy; honest pricing: real MRP, no fake discounts or drip pricing; product labelling requirements; payment security (PCI DSS) and marketplace policies.
- Rules differ by country. If I have not said where I work, ask me, and do not present one country's law as if it applied everywhere.

## How to work through it
1. Study the history for trend and seasonality.
2. Recommend a method and explain assumptions.
3. Produce the forecast with a range.
4. List what could break it.

## What to deliver
- Forecast table with range
- Method and assumptions
- Risk factors

## Rules
- Make every point specific to my situation and my industry; replace generic advice with detail that fits.
- Use plain language, short sentences, and tables where they make the answer easier to scan.
- Use only the facts I give you. Do not invent figures, laws, sources or quotes. Mark anything you had to assume with "Assumption:".
- If something important is missing, ask me up to 3 short questions before you start.

## Before you answer
Check your draft against this list and fix anything that fails:
- Every number comes from my data or is marked as an assumption, and correlation is never presented as cause.
- It is written for an online store selling physical products; nothing in it would read the same for any other business.
- Nothing in it breaks consumer-protection rules, return policies and stock levels.
- Every item under "What to deliver" is included.

Open in ChatGPT Claude Perplexity

How to use this prompt

Copy the prompt. Press Copy prompt and the full text goes to your clipboard.
Fill the brackets. Use the form above, or replace [WHAT TO FORECAST], [PERIOD], [PASTE HISTORY] with your own details.
Paste and send. Paste it into ChatGPT, Claude and Gemini and send. Ask follow-up questions to refine the answer.

Why this prompt works

The “Forecasting plan” prompt tells the assistant exactly what to hand back: forecast table with range; method and assumptions; and risk factors. It makes the assistant work through 4 steps in order, starting with "study the history for trend and seasonality", instead of jumping straight to an answer. Before replying, the assistant checks its draft against 4 tests and fixes anything that fails.

This version is written for an online store selling physical products, so the assistant keeps consumer-protection rules, return policies and stock levels in mind and judges the result by conversion rate and average order value. If an important detail is missing, it asks you up to 3 short questions before it starts.

How to get the best answer

Fill every bracket with real detail: [WHAT TO FORECAST], [PERIOD], [PASTE HISTORY] should hold real names, numbers and dates, not placeholders.
Paste real material: where the prompt asks for notes, data or text, paste the actual content rather than a summary.
Refine in the same chat: ask "make it shorter", "turn it into a table" or "add more detail on step 2".
Check the result: review it against what you know about conversion rate and average order value before you share it.

Other industries

Same prompt for other industries

The same forecasting plan prompt, rewritten for each industry.

FAQ

Frequently asked questions

Which AI assistant works best with the “Forecasting plan” prompt?

The “Forecasting plan” prompt works in any chat assistant and suits ChatGPT, Claude and Gemini best. Paste it in, send it, and ask follow-up questions in the same chat to refine the answer.

What do I fill in before sending the “Forecasting plan” prompt?

Replace the 3 highlighted brackets – [WHAT TO FORECAST], [PERIOD], [PASTE HISTORY] – with your own details. The more specific you are, the better the answer.

Is the “Forecasting plan” prompt only for E-commerce & Retail?

No. This version is written for an online store selling physical products, and the same prompt is also written for 15 other industries, listed on this page.

Is the “Forecasting plan” prompt free to use?

Yes. First AI Prompt prompts are free to copy and use in personal and business work, with no sign-up, no account and no daily limit.

Can I trust the answer the “Forecasting plan” prompt gives?

Treat it as a strong first draft: the prompt tells the assistant not to invent facts and to mark its assumptions, but check figures yourself, especially anything with legal, financial or safety consequences.

Keep exploring