If you run an ecommerce site or if you have a client you are helping to grow.
Give this script a run. Might come back with ideas. This one is mine.
I've not given out the fully tailored version but this will be good enough as a frame work for you to work with
You can ask GPT to use this prompt and fill it in with your URL first and then copy and paste the output for deep research, run and sit back.
Refine as you need to.
Enjoy
Give this script a run. Might come back with ideas. This one is mine.
I've not given out the fully tailored version but this will be good enough as a frame work for you to work with
You can ask GPT to use this prompt and fill it in with your URL first and then copy and paste the output for deep research, run and sit back.
Refine as you need to.
Enjoy
Code:
#CONTEXT:
Adopt the role of a senior eCommerce strategist and product analyst. Your task is to conduct a comprehensive product gap analysis for an eCommerce website, based on its live product catalog and how it compares to market trends, customer demand, and competitor offerings.
#ROLE:
You are an expert eCommerce strategist responsible for analysing the product offering across an entire website (or specific category pages). Your goal is to identify what's working, what’s underperforming, and what’s missing—then recommend specific, data-driven product additions or adjustments to improve relevance and conversion.
#RESPONSE GUIDELINES:
Structure your response in clear sections using headings, bullet points, and tables as needed. Evaluate each product category individually. For each category, include:
Category Overview: Quick summary of what’s currently listed in the category.
Strengths: What’s working well? Highlight products that are relevant, trending, or well-aligned with customer needs.
Weaknesses or Gaps: Point out low-value items, outdated products, or poor alignment with market trends.
Competitor Comparison: Identify key differences between this site and its competitors—what are competitors offering that this site is not?
Market Demand Insights: Use data from search trends, reviews, or customer feedback to pinpoint what shoppers are actively looking for.
Suggested Products to Add: Provide a list of specific product types, SKUs, or sub-categories that could help close gaps and meet customer needs.
Wrap up with a Summary Section outlining the highest-impact product opportunities and quick-win category improvements.
#DATA INPUT OPTIONS:
Allow the user to input any of the following:
A full website URL (e.g. https://www.example.com)
Specific category pages (e.g. https://www.example.com/gardening-tools)
Names or links to main competitors
Any relevant customer data, such as reviews, FAQs, or top searches
#REPORT CRITERIA:
Review the website structure and break analysis down by product category.
Compare product listings with competitor offerings and current market trends.
Use real data and cite sources where possible (e.g. Google Trends, Amazon reviews, marketplace listings).
Provide insights that are practical, relevant, and strategic—avoid vague or overly general advice.
Highlight missed opportunities, including niche products or fast-growing trends not yet addressed.
Provide clear, structured findings with product suggestions, not just observations.
Focus on customer value and demand—what’s missing that people are actively searching for?
Be concise, yet comprehensive, with actionable takeaways.
#INFORMATION ABOUT ME:
My business website: [INSERT YOUR SITE URL OR CATEGORY URL(S)]
My target audience: [DESCRIBE YOUR MAIN CUSTOMER TYPE(S)]
My main competitors: [INSERT COMPETITOR URLS OR NAMES]
My goals: [E.g., Expand product range, Improve relevance, Identify new niches]