Prepare your next client call with answers about WooCommerce sales, orders and products. Connect the client's store through Catchr, then use ChatGPT or Claude to explore store results, review order discounts and identify products that need a closer look.
“Compare paid media performance across my client accounts and flag the biggest changes.”
WooCommerce
Google Ads
GA4
Used by the world's leading companies
Start with the store overview, investigate order details, then review individual products. Freelancers and agencies can use these three views to prepare ecommerce reporting and focused follow-up questions.
Review Shop Gross Sales, Shop Net Sales, Shop Total Orders and Shop Total Items Purchased to describe store activity for a reporting period. Shop Total Customers counts customers who placed orders.
Include Shop Total Shipping, Shop Total Tax, Shop Total Refunds and Shop Total Coupons Used when the client needs more context. Keep these measures separately labeled so the report distinguishes sales, charges and counts.
Use Order Total, Order Discount Total and Order Shipping Total to examine order values. Choose Order Date Created or Order Date Completed according to the reporting question, with site-timezone and GMT versions available.
At the line-item level, review Product Quantity, Product price, Subtotal before discounts and Total after discounts. Comparing line subtotals with line totals helps quantify discount reductions without treating them as profit or margin.
Review Product Total Sales alongside Product Average Rating and Product Rating Count, using Product Id to identify each product. This gives client discussions context about both sales and review feedback.
Product and variation creation and modification dates also support catalog reviews. These dates describe catalog changes; they should not be used as purchase dates.
A focused store analysis, a recurring report and a question through Catchr MCP serve different client needs. Choose the approach that fits the work, from reviewing order values to preparing a sales summary.
Use a recurring report to keep WooCommerce sales measures consistent across client reviews. Use Catchr MCP for follow-up questions about order discounts, purchasing activity or product ratings, with the store and reporting scope stated in each request.
Connect WooCommerce to Catchr using API-key authentication and select the relevant client account. Choose ChatGPT or Claude through Catchr MCP, then ask about the store's sales, orders or products. For order reporting, specify whether to use creation or completion dates and whether dates should follow the site's timezone or GMT.
Replace the bracketed details with your client's store, reporting dates and thresholds. Each prompt sets a specific reporting question and asks for figures you can review before sharing conclusions with the client.
Using Catchr, how did WooCommerce store [account] perform during [reporting period] compared with [comparison period]? Show Shop Gross Sales, Shop Net Sales, Shop Total Orders, Shop Total Items Purchased and Shop Total Customers. Calculate absolute and percentage changes, mark percentage changes as undefined when the comparison value is zero, and summarize the largest changes for a client call.
Copy promptUsing Catchr, which order creation dates for WooCommerce store [account] between [start date] and [end date] had total Order Discount Total above [discount amount threshold]? Use Order Date Created in the site's timezone. Group by that date and show summed Order Discount Total, Order Total and Order Shipping Total. Sort by discount amount and explain that the results follow order creation dates.
Copy promptUsing Catchr, how much did discounts reduce order-line values for WooCommerce store [account] between [start date] and [end date], using Order Date Created in the site's timezone? Use the available order-to-order-line relationship and confirm that date filtering is supported before calculating. Sum Order Line Subtotal and Order Line Total, calculate their difference and the difference as a percentage of subtotal, and show total Order Line Product Quantity. If the date relationship is unavailable, explain the limitation instead of presenting an unfiltered result.
Copy promptUsing Catchr, which products in WooCommerce store [account] have Product Average Rating below [rating threshold] and Product Rating Count of at least [minimum review count]? Show Product Id, Product Average Rating, Product Rating Count and Product Total Sales, sorted by Product Total Sales descending. Interpret numeric rating text where valid and flag values that cannot be interpreted. Present the products as candidates for review without claiming that ratings caused their sales results.
Copy promptConnect WooCommerce in Catchr using API-key authentication, select the relevant account, then choose ChatGPT or Claude through Catchr MCP. Start with a scoped question, such as comparing net sales and total orders for two specified periods.
Order Line Subtotal is the line value before discounts. Order Line Total is the value after discounts. Their difference shows the reduction between those two values; it does not measure profit or margin.
Use Order Date Created to group orders by when they were created, or Order Date Completed to group them by completion. Both have site-timezone and GMT versions. Keep the date field and timezone consistent when comparing periods.
Yes. Use Product Id with Product Total Sales, Product Average Rating and Product Rating Count to identify products for further review. Average rating is exposed as text, so numeric comparisons need valid numeric values. Ratings and sales together do not establish why a product performed as it did.
Connect your sources to Catchr, add the MCP server to your AI assistant, and ask about the work that matters now.
