Prepare your next ecommerce client review with answers from BigCommerce. Catchr MCP lets freelancers and agencies query connected order, order product and customer data in ChatGPT.
Compare shipping and handling costs, inspect product pricing, or review customer registrations. Turn a specific reporting question into a focused analysis for your client conversation.
“Compare paid media performance across my client accounts and flag the biggest changes.”
BigCommerce
Google Ads
GA4
Used by the world's leading companies
Build your analysis around the part of the store you need to understand. Keep order-level charges, order product prices and customer records separate so each result has a clear meaning.
Explore order shipping, handling and wrapping costs with separate fields for amounts excluding tax, including tax and tax itself. Base costs are also available.
Use order creation dates to compare reporting periods and shipping address count to investigate orders with different delivery requirements. Keep the same tax basis across comparisons.
Review order product base price, base total and price excluding tax alongside cost price fields. Examine fixed shipping cost and wrapping costs for a more detailed view of charges recorded on order products.
Use fulfillment source to organize a product-level review. Distinguish individual price fields from totals before aggregating them for a client report.
Use customer creation dates to review registrations over a selected period. Customer IDs let you count distinct records, while address count helps you compare customers by the number of addresses recorded.
This provides a focused view of customer registrations. It does not establish purchase frequency or repeat buying on its own.
A focused order investigation, a recurring client report and a follow-up question each need a different approach. Use the same BigCommerce entities with a workflow that fits the task.
Use a report to present consistent BigCommerce figures across client reviews. Use Catchr MCP to investigate questions such as which orders have high shipping costs or how customer registrations changed between two periods.
Connect BigCommerce to Catchr using API-key authentication and select the relevant client account. Set the reporting timezone, then connect ChatGPT or Claude through Catchr MCP.
Start with a question about orders, order products or customers. Include the account, date range and fields you want to compare so the answer stays focused on your client’s store.
Replace the bracketed values with your client’s account and reporting choices. These prompts cover order costs, tax checks, fulfillment sources and customer registrations.
Using Catchr, query BigCommerce orders for [account] created between [start date] and [end date] in [timezone]. Find orders where shipping cost excluding tax exceeds [threshold]. Return the order ID, shipping cost excluding tax, handling cost excluding tax and shipping address count. Sort by shipping cost descending and summarize the results for a client review.
Copy promptUsing Catchr, review BigCommerce orders for [account] created between [start date] and [end date] in [timezone]. For shipping, handling and wrapping separately, compare the amount including tax minus the amount excluding tax with the recorded tax amount. List order IDs where the absolute difference exceeds [tolerance], show the values used and identify missing values separately.
Copy promptUsing Catchr, examine BigCommerce order products for [account]. Group records by fulfillment source and show the record count, average price excluding tax, average cost price excluding tax and average fixed shipping cost. Flag records with fixed shipping cost above [threshold]. Keep missing fulfillment sources in a separate group and label the averages as per-record averages, not quantity-weighted values.
Copy promptUsing Catchr, compare BigCommerce customers created during [first period start] to [first period end] with those created during [second period start] to [second period end] for [account] in [timezone]. Count distinct customer IDs in each period, calculate the absolute change and percentage change where the first count is nonzero, and group registrations by customer address count. Summarize the differences without treating registrations as purchases.
Copy promptYou can work with orders, order products and customers. Useful fields include order shipping, handling and wrapping costs; order product prices, costs and fulfillment source; and customer creation dates and address counts.
Connect your BigCommerce account in Catchr using API-key authentication, select the account and configure the timezone. Then connect ChatGPT through Catchr MCP and ask a question with the account and reporting scope specified.
Orders and customers use their creation dates for date filtering. Configure the reporting timezone, which defaults to UTC+00:00, and use it consistently when comparing periods. Order products have an event date field, but it should not be assumed to represent the order creation date.
Price excluding tax and cost price excluding tax support a focused price-and-cost comparison. They do not establish complete profit on their own. Keep individual prices separate from totals, and label any calculated difference with the fields and assumptions used.
Connect your sources to Catchr, add the MCP server to your AI assistant, and ask about the work that matters now.
