Claude.ai & MCP supported — another step towards a more powerful AdzviserRead Me
TikTok Shop Prompt Library
Ready-to-use AI prompts to analyze your TikTok Shop orders and revenue, uncover product winners, and tighten fulfillment. Customize with your shop name and date range, then paste into ChatGPT, Claude, or Gemini.
16
Ready-to-use prompts
4
Categories
∞
Customizations
Customize:
Showing 16 prompts
See available TikTok Shop metrics & breakdowns →Reporting
Weekly Sales Summary
Get a concise weekly snapshot of your shop's orders and revenue.
Pull the TikTok Shop sales data from my TikTok Shop account for the last 30 days. Show: Orders, Items sold, Items subtotal (after discounts), Total amount, and Average Order Value (Total amount / Orders). Include week-over-week change percentages and highlight any metric that moved more than 15%.
Reporting
Monthly Executive Report
Generate a comprehensive monthly report for stakeholders.
Generate a monthly TikTok Shop executive report for my TikTok Shop account covering the last 30 days. Include: 1) Orders, Items sold, Items subtotal (after discounts), and Total amount with month-over-month changes. 2) Top 10 products by Total amount using Product name. 3) Breakdown by Order status. 4) Total seller and TikTok Shop discounts via Items subtotal (seller discount) and Items subtotal (TikTok Shop discount). 5) A summary paragraph with 3 actionable recommendations.
Reporting
Product Performance Report
Identify your best and worst selling products and SKUs.
From my TikTok Shop account for the last 30 days, show TikTok Shop product performance broken down by Product name and SKU name. Include: Orders, Items sold, Items subtotal (after discounts), Total amount, and Item sale price. Sort by Total amount descending. Identify the top 10 products and the bottom 10 that may need to be discontinued or promoted differently.
Reporting
Revenue After Discounts Report
See how discounts shape net revenue across the shop.
Analyze TikTok Shop revenue after discounts for my TikTok Shop account during the last 30 days. Show: Items subtotal (before discounts), Items subtotal (seller discount), Items subtotal (TikTok Shop discount), Items subtotal (after discounts), and Total amount. Include Shipping fee (after discounts), Tax, Buyer service fee, and Handling fee. What percentage of gross value is lost to discounts? Summarize the net revenue picture.
Optimization
SKU Pricing Optimization
Analyze SKU pricing and discount patterns for optimization opportunities.
Analyze TikTok Shop pricing for my TikTok Shop account during the last 30 days, broken down by SKU name and Seller SKU. For each SKU show: Item original price, Item sale price, Item seller discount, Items sold, and Total amount. Identify SKUs where 1) high Items sold suggests room for price increases, 2) low volume suggests discounting might help, and 3) heavy Item seller discount may be eroding margins. Recommend pricing adjustments.
Optimization
Discount Impact Analysis
Evaluate whether seller and platform discounts drive incremental sales.
From my TikTok Shop account for the last 30 days, analyze TikTok Shop discount effectiveness. Compare Items subtotal (seller discount) and Items subtotal (TikTok Shop discount) against Orders and Items sold, broken down by Product name. Show AOV (Total amount / Orders) for discounted versus non-discounted orders. Are discounts driving incremental orders or just reducing margins? Recommend an optimized discount strategy.
Optimization
Fulfillment Efficiency Optimization
Reduce fulfillment friction across shipping and delivery types.
Analyze TikTok Shop fulfillment for my TikTok Shop account during the last 30 days, broken down by Order fulfillment type, Order shipping type, and Order delivery type. Show: Orders, Items sold, Shipping fee (after discounts), Shipping insurance fee, and Handling fee. Compare Order created date to Order shipped date and Order delivered date to gauge speed. Identify slow or costly fulfillment paths and recommend improvements.
Optimization
Shipping Cost Optimization
Find where shipping and handling fees erode margins.
Analyze TikTok Shop shipping economics for my TikTok Shop account during the last 30 days, broken down by Order shipping provider and Recipient region code. Show: Orders, Shipping fee (before discounts), Shipping fee (after discounts), Shipping insurance fee, Handling fee, and Small order fee. Which providers or regions carry disproportionate shipping cost per order? Recommend free-shipping thresholds and provider changes.
Analysis
Order Trend Analysis
Identify daily order and revenue trends and unusual swings.
Analyze daily TikTok Shop order trends from my TikTok Shop account for the last 30 days, broken down by Order created date. Show: Orders, Items sold, Items subtotal (after discounts), and Total amount per day. Identify 1) best and worst performing days, 2) day-of-week patterns, 3) unusual spikes or dips with possible explanations, and 4) overall trend direction. Summarize the trend.
Analysis
Cancellation Analysis
Understand why orders are being cancelled and who initiates them.
Analyze TikTok Shop cancellations from my TikTok Shop account for the last 30 days, broken down by Order cancel reason and Order cancellation initiator. Show: Orders, Items sold, and Total amount for cancelled orders, and the cancellation rate against all Order status values. Which reasons and initiators drive the most lost revenue? Are there patterns by Product name? Recommend actions to reduce cancellations.
Analysis
Payment Method Analysis
Compare order value and volume across payment methods.
From my TikTok Shop account for the last 30 days, analyze TikTok Shop orders by Order payment method name and Order currency. Show: Orders, Total amount, Buyer service fee, and AOV (Total amount / Orders) per method. Which payment methods drive the highest-value orders? Are any associated with more cancellations across Order status? Recommend which methods to prioritize or promote.
Analysis
Regional Sales Analysis
Discover which regions drive the most orders and revenue.
Analyze TikTok Shop regional performance for my TikTok Shop account during the last 30 days, broken down by Shop region and Recipient region code. Show: Orders, Items sold, Total amount, AOV (Total amount / Orders), and Shipping fee (after discounts) for the top 20 regions. Which regions have the highest AOV? Which carry disproportionate shipping costs? Recommend geographic marketing opportunities.
Audit
Order Status Audit
Review the distribution and health of orders by status.
Perform a TikTok Shop order status audit for my TikTok Shop account using data from the last 30 days. Break down by Order status: Orders, Items sold, and Total amount. Highlight stuck states, high cancellation share via Order cancel reason, and pending fulfillment. Cross-reference Order paid date, Order shipped date, and Order delivered date to find delays. Give a health score from 1-10 and list the top 5 improvements.
Audit
Product Catalog Audit
Review your product and SKU catalog for optimization gaps.
Audit the TikTok Shop product catalog for my TikTok Shop account using data from the last 30 days, broken down by Product ID, Product name, SKU ID, and Item display status. Check: 1) products and SKUs with zero Items sold (dead inventory), 2) SKUs with inactive Item display status, 3) price outliers using Item original price and Item sale price, and 4) revenue concentration by Total amount. Recommend specific catalog improvements.
Audit
Fulfillment & Shipping Audit
Review fulfillment speed, shipping fees, and provider reliability.
Audit TikTok Shop fulfillment and shipping for my TikTok Shop account during the last 30 days, broken down by Order fulfillment type and Order shipping provider. Show: Orders, Shipping fee (after discounts), Shipping insurance fee, Handling fee, and Small order fee, plus average time from Order paid date to Order shipped date and Order delivered date. Are shipping fees eating into margins? Recommend fulfillment process improvements.
Audit
Discount & Fee Audit
Verify discounts and add-on fees are applied correctly.
Audit TikTok Shop discounts and fees for my TikTok Shop account using data from the last 30 days. Reconcile Items subtotal (before discounts) against Items subtotal (seller discount), Items subtotal (TikTok Shop discount), and Items subtotal (after discounts). Verify Tax, Buyer service fee, Handling fee, Small order fee, and Shipping insurance fee roll up correctly into Total amount. Flag any orders where discounts or fees look inconsistent and recommend corrections.
Ready to use these prompts with your own data?
Connect your TikTok Shop account to Adzviser and start getting AI-powered insights in minutes. No coding required.
Start your 14-day trialNot looking for TikTok Shop prompts? Browse prompts for other platforms →
