Prepare your next ecommerce client call with answers about sales, discounts, refunds and customer totals. Connect your client's Shopify store to Catchr, then use ChatGPT or Claude through Catchr MCP to investigate the numbers and build your explanation.
“Compare paid media performance across my client accounts and flag the biggest changes.”
Shopify
Google Ads
GA4
Used by the world's leading companies
Start with the question your client needs answered: how much the store sold, where discounts affected sales, or how new and returning customer totals compare. Choose the Shopify fields and reporting scope that fit each question.
Review Gross sales, Total net sales, Total sales, Discount and Refund to explain store performance. Add Total Shipping, Total tax and Duties when the client needs more detail about order amounts.
Total net sales is measured after discounts but before shipping, duties, taxes and tips. Keep that definition visible when comparing it with Total sales, and report monetary values in the shop currency.
Use Order items number for an order-level view, or explore Number of items of line alongside Line Gross sales, Line Discount and Line Total net sales for line-item analysis. Cost of Goods Sold and Inventory Unit Cost add cost context.
Keep order totals and line-item metrics at their intended level of detail so repeated order values do not inflate a client report.
Compare Total New Customer and Total Returning Customer to discuss the store's customer mix. For sales analysis, use Billing country or Shipping country to explore markets, and UTM medium, UTM name or UTM Content to examine tagged promotions.
Order tags offer another way to focus an investigation. Treat UTM breakdowns as a view of the values recorded on orders, with missing values shown separately.
A focused Shopify investigation, a recurring client report and a question through Catchr MCP serve different needs. Choose the approach that fits the work, while keeping sales definitions and order filters consistent.
Use focused analysis to investigate a Shopify question, a report to share a consistent view, and Catchr MCP to ask follow-up questions. Carry the same store selection, metric definitions and fulfillment settings across each workflow.
Connect Shopify in Catchr and select the client's store. Then connect Catchr MCP to ChatGPT or Claude and start with a question about sales, orders or customers. Before comparing results with another report, check whether unfulfilled orders are included: Catchr excludes UNFULFILLED orders by default, with an option to include them across order-derived data.
Replace the bracketed details with your client's store, dates and review threshold. Each prompt asks for a specific Shopify analysis and the context needed to interpret the result.
Using Catchr, how did Gross sales, Total net sales, Total sales, Discount and Refund for Shopify store [store] change between [first date range] and [second date range]? Show each metric separately, calculate absolute and percentage changes where meaningful, and identify changes above [percentage threshold]. State the shop currency, explain the net sales definition and report whether unfulfilled orders are included.
Copy promptUsing Catchr, which UTM name and UTM medium combinations recorded the most Total net sales for Shopify store [store] during [date range]? Include Gross sales and Discount, rank the combinations by net sales, and show missing UTM values separately. Explain what the recorded order tags support without inferring advertising spend or return on ad spend.
Copy promptUsing Catchr, which Shipping country values have Refund totals above [refund amount threshold] for Shopify store [store] during [date range]? Show Refund, Total net sales and Total Shipping by shipping country, keep missing countries visible, and state the currency and fulfillment filter. List the countries worth investigating without assuming why refunds occurred.
Copy promptUsing Catchr, how did Total New Customer and Total Returning Customer for Shopify store [store] change between [first date range] and [second date range]? Show both totals and their absolute and percentage changes where meaningful. Prepare a short client-call summary and distinguish these customer totals from a retention or cohort analysis.
Copy promptYou can investigate sales, discounts, refunds, order items and new versus returning customer totals. Use shipping or billing geography, order tags and recorded UTM values to focus relevant order analyses.
Connect Shopify in Catchr, select the relevant store, then connect Catchr MCP to ChatGPT or Claude. Start your question with the store, date range and metrics you want to inspect, such as Total net sales and Refund.
Check the store, date range, sales definition and fulfillment filter. Catchr excludes UNFULFILLED orders by default; the include-unfulfilled-orders option applies across order and line-item data. Also check that order-level totals have not been repeated when using line-item detail.
Reporting does not modify your Shopify source data.
Connect your sources to Catchr, add the MCP server to your AI assistant, and ask about the work that matters now.
