Claude.ai & MCP supported — another step towards a more powerful AdzviserRead Me
Shopify Prompt Library
Ready-to-use AI prompts to analyze your Shopify store data, uncover sales trends, and optimize your product catalog. Customize with your store name and date range, then paste into ChatGPT, Claude, or Gemini.
20
Ready-to-use prompts
4
Categories
∞
Customizations
Customize:
Showing 20 prompts
See available Shopify metrics & breakdowns →Reporting
Weekly Sales Summary
Get a concise weekly snapshot of your store's revenue and orders.
Pull the sales data from my Shopify account for the last 30 days. Show: Total Revenue, Number of Orders, Average Order Value (AOV), Total Units Sold, Refund Amount, and Net Revenue. Include week-over-week change percentages. Highlight any metrics that changed by more than 15%.
Reporting
Monthly Executive Report
Generate a comprehensive monthly report for stakeholders.
Generate a monthly executive report for my Shopify account covering the last 30 days. Include: 1) Total revenue, orders, and AOV with month-over-month changes. 2) Top 10 products by revenue. 3) Top 5 traffic sources driving orders. 4) Refund rate and top refunded products. 5) A summary paragraph with 3 actionable recommendations.
Reporting
Product Performance Report
Identify your best and worst selling products.
From my Shopify account for the last 30 days, show product performance. Include: Product Title, Variant, Units Sold, Revenue, Average Selling Price, Refund Rate, and Gross Margin (if available). Sort by Revenue descending. Identify the top 10 products and the bottom 10 that may need to be discontinued or promoted differently.
Reporting
Sales by Channel Report
Compare performance across online store, POS, and other channels.
Analyze sales by channel for my Shopify account during the last 30 days. Break down by channel (Online Store, POS, Buy Button, etc.): Orders, Revenue, AOV, and percentage of total sales. Which channels are growing? Which are declining? Recommend channel investment priorities.
Reporting
Geographic Sales Report
Discover which regions drive the most revenue.
For my Shopify account during the last 30 days, break down orders by country and state/province (top 20). Show: Location, Orders, Revenue, AOV, and Shipping Costs. Which regions have the highest AOV? Which have disproportionate shipping costs? Recommend geographic marketing opportunities.
Optimization
Product Pricing Optimization
Analyze pricing patterns and identify optimization opportunities.
Analyze product pricing for my Shopify account during the last 30 days. For each product: Current Price, Units Sold, Revenue, and Average Discount Applied. Identify products where: 1) High sales volume suggests room for price increases. 2) Low sales at current price suggest discounting might help. 3) Frequent discounting may be eroding margins. Recommend pricing adjustments.
Optimization
Discount & Promo Code Analysis
Evaluate the effectiveness of your discount strategies.
From my Shopify account for the last 30 days, analyze discount code usage. Show: Discount Code, Times Used, Total Revenue, Average Discount %, and AOV with vs without discount. Are discounts driving incremental revenue or just reducing margins on purchases that would have happened anyway? Recommend an optimized discount strategy.
Optimization
Cart Abandonment Insights
Understand and reduce cart abandonment.
Analyze checkout data from my Shopify account for the last 30 days. Show: Checkouts Initiated, Checkouts Completed, Abandonment Rate, Average Cart Value of Abandoned Checkouts, and Top Products in Abandoned Carts. What percentage of revenue is being lost to abandonment? Identify patterns and recommend strategies to recover abandoned carts.
Optimization
Inventory Velocity Analysis
Identify fast-moving and slow-moving inventory.
Analyze inventory velocity for my Shopify account during the last 30 days. For each product: Current Inventory Level, Units Sold, Days of Supply Remaining, and Revenue per Unit. Identify: 1) Fast sellers at risk of stockout. 2) Slow movers tying up capital. 3) Products with good margins but low sales (promotion candidates). Recommend reorder priorities and clearance candidates.
Optimization
Repeat Purchase Optimization
Identify products and strategies that drive repeat purchases.
Analyze repeat purchase patterns from my Shopify account for the last 30 days. Show: 1) First-time vs repeat customer revenue split. 2) Most common first-purchase products. 3) Products most likely to drive a second purchase. 4) Average time between purchases. Recommend strategies to increase repeat purchase rate.
Analysis
Sales Trend Analysis
Identify daily and weekly sales trends and seasonal patterns.
Analyze daily sales trends from my Shopify account for the last 30 days. Show: Date, Orders, Revenue, and AOV. Identify: 1) Best and worst performing days. 2) Day-of-week patterns. 3) Any unusual spikes or dips with possible explanations. 4) Overall trend direction (growing, flat, declining). Visualize with a trend summary.
Analysis
Customer Lifetime Value Analysis
Understand the long-term value of your customer segments.
Analyze customer value from my Shopify account for the last 30 days. Calculate: 1) Average number of orders per customer. 2) Average revenue per customer. 3) Distribution of customers by order count (1 order, 2-3, 4-5, 6+). 4) Revenue concentration (what % of revenue comes from top 10% of customers). Recommend strategies to increase average customer lifetime value.
Analysis
Product Collection Performance
Compare performance across product collections.
Analyze performance by product collection for my Shopify account during the last 30 days. Show: Collection Name, Number of Products, Units Sold, Revenue, AOV, and Revenue per Product. Which collections drive the most revenue per product? Which have underperforming products that could be reorganized? Recommend collection optimization strategies.
Analysis
Refund & Return Analysis
Understand why products are being returned.
Analyze refund and return data from my Shopify account for the last 30 days. Show: Total Refunds, Refund Rate, Top 10 Refunded Products, Refund Amount, and Refund Reasons (if available). Which products have the highest refund rates? Are there patterns (size issues, product quality, shipping damage)? Recommend actions to reduce refunds.
Analysis
Traffic Source Revenue Attribution
Understand which traffic sources drive the most valuable orders.
From my Shopify account for the last 30 days, analyze revenue by UTM source and medium. Show: Source/Medium, Orders, Revenue, AOV, and Units per Order. Which marketing channels drive the highest-value customers? Which have the highest AOV? Recommend marketing spend reallocation based on revenue per order by source.
Audit
Store Health Check
Run a comprehensive health check on your Shopify store.
Perform a store health check for my Shopify account using data from the last 30 days. Evaluate: 1) Revenue and order trends (growing, flat, or declining). 2) AOV trends. 3) Refund rate and top refunded products. 4) Product catalog utilization (% of products with sales). 5) Repeat customer rate. Give a health score from 1-10 and list the top 5 improvements.
Audit
Product Catalog Audit
Review your product catalog for optimization opportunities.
Audit the product catalog for my Shopify account using data from the last 30 days. Check: 1) Products with zero sales (dead inventory). 2) Products missing descriptions or images. 3) Price distribution and outliers. 4) Products without variant options that should have them. 5) SEO completeness (meta titles, descriptions). Recommend specific catalog improvements.
Audit
Order Fulfillment Audit
Review order processing and fulfillment efficiency.
Audit order fulfillment for my Shopify account during the last 30 days. Analyze: 1) Average time from order to fulfillment. 2) Orders by fulfillment status (fulfilled, unfulfilled, partially fulfilled). 3) Refund rate by product and variant. 4) Discount code usage rate and impact on margins. 5) Repeat order rate. Recommend specific process improvements.
Audit
Shipping & Fulfillment Audit
Review shipping costs and fulfillment efficiency.
Audit shipping and fulfillment for my Shopify account during the last 30 days. Show: Total Shipping Revenue, Total Shipping Costs, Average Shipping Cost per Order, Average Fulfillment Time, and Late Shipment Rate. Are shipping costs eating into margins? Are there opportunities to offer free shipping thresholds? Recommend fulfillment improvements.
Audit
Customer Segmentation Audit
Ensure your customer segments are well-defined and actionable.
Audit customer segments for my Shopify account using data from the last 30 days. Analyze: 1) New vs returning customer ratio. 2) High-value customer characteristics (what do they buy, how often). 3) At-risk customers (previously active, now dormant). 4) Geographic concentration. 5) Acquisition channel by customer segment. Recommend targeted marketing strategies for each segment.
Ready to use these prompts with your own data?
Connect your Shopify account to Adzviser and start getting AI-powered insights in minutes. No coding required.
Start your 14-day trialNot looking for Shopify prompts? Browse prompts for other platforms →
