Prepare your next ecommerce client review with answers from Magento orders and order items. Connect Magento to Catchr, choose ChatGPT or Claude through Catchr MCP, and ask about shipping locations, product types and refunded amounts.
Give your agency or freelance reporting a practical starting point: a specific client account, a clear date range and the store records you need to investigate.
“Compare paid media performance across my client accounts and flag the biggest changes.”
Magento
Google Ads
GA4
Used by the world's leading companies
Use order details to review shipping destinations and order-item details to investigate products and refunds. Creation dates define the reporting period; update timestamps help you examine changes to the selected records.
Explore orders by shipping country code, shipping region and shipping region code. Use these fields to organize a client report by destination and identify records with missing location details.
Keep country and region together when reviewing regional patterns so similarly named regions remain distinguishable.
Review order items using product ID, product type and Amount Refunded. Ask for items above a chosen refunded-amount threshold, then organize the results by product to focus your client discussion.
Applied Rule Ids provides additional detail for the review. Rule IDs alone do not explain a rule's terms or establish why an item was refunded.
Both orders and order items use creation dates for date selection. Order Updated At and Order Item Updated At let you inspect when selected records were subsequently updated.
For a period review, ask which records created in that period show later updates. An update timestamp does not identify what changed or when a refund occurred.
A focused Magento investigation, a recurring client report and an AI question serve different reporting needs. Choose the approach that fits the work in front of you.
Use a report for a repeatable view of Magento shipping and product details. Use Catchr MCP to follow up with a targeted question, such as which items exceed a refund threshold or which selected orders have missing shipping regions.
Connect Magento to Catchr using API-key authentication and select the relevant client account. Then connect your AI destination through Catchr MCP. Start with an order or order-item question and specify the creation-date range you want to review.
Replace the bracketed values with your client account, dates and review criteria. Each prompt focuses on Magento fields you can use to prepare a report or investigate records before a client call.
Using Catchr, review Magento orders for [account] created between [start date] and [end date]. Which records have a shipping country code but a missing shipping region or shipping region code? Return the shipping country code, shipping region, shipping region code and Order Updated At for those records, grouped by country.
Copy promptUsing Catchr, review Magento order items for [account] created between [start date] and [end date]. Which items have Amount Refunded greater than [refund threshold]? Return product ID, product type, Amount Refunded and Order Item Updated At, sorted by refunded amount from highest to lowest. Treat the threshold in the same units as the returned field.
Copy promptUsing Catchr, examine Magento order items for [account] created between [start date] and [end date] with Amount Refunded greater than zero. Which Applied Rule Ids values appear on these items? Group the results by the exact returned rule-ID value and show product ID, product type and Amount Refunded. Identify missing rule-ID values without inferring rule names or causes of refunds.
Copy promptUsing Catchr, review Magento orders for [account] created between [start date] and [end date]. Which selected records have Order Updated At later than [review cutoff date]? List Order Updated At, shipping country code, shipping region and shipping region code, with the most recently updated first. Explain that these timestamps do not identify what changed.
Copy promptConnect Magento to Catchr using API-key authentication, select the relevant account, then connect ChatGPT or Claude through Catchr MCP. Include the account and creation-date range in your first reporting question.
You can review order shipping countries and regions, plus order-item product IDs, product types, refunded amounts and applied rule IDs. Orders and order items also expose update timestamps for inspecting the selected records.
Amount Refunded supports reviewing refunded amounts on order items. It does not by itself provide the original sales amount or quantities needed for a meaningful refund rate. Use it to investigate items and products without labeling refunded amounts as a rate.
The date range selects orders or order items by creation date. Amount Refunded describes those selected items; it does not establish when their refunds occurred. An item update timestamp is not a refund date.
Connect your sources to Catchr, add the MCP server to your AI assistant, and ask about the work that matters now.
