/
/
Find BigCommerce refunds that have no HubSpot ticket
For support teams who want every refunded buyer followed up, by asking their AI assistant to check HubSpot.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Refunded buyers go without a support follow-up
Refunds happen in BigCommerce while support tickets live in HubSpot, so refunded buyers can go without a follow-up. Finding them means listing refunded orders and searching HubSpot for each buyer's tickets.
Without PopdockAI
- Filter BigCommerce orders to refunds
- Search HubSpot for each buyer by email
- Check for tickets since the order date
- Lose track of who has been contacted
With PopdockAI
- Refunded orders above your minimum are read, up to 50
- Each buyer is found in HubSpot by billing email
- Tickets since the order date are checked and statuses shown
- Orders with no ticket come first, and nothing is written
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List BigCommerce orders created in the last `{lookback-days}` days (default 30) with a refund of at least `{min-refund}` (default 1), and show whether the customer has any HubSpot ticket.
**Step 1: Find refunded orders in BigCommerce**
Call `bigcommerce-get-order` with `date-created.from` set to today minus the lookback, `refunded-amount.min` set to `{min-refund}`, and `max-records` of 50. Keep `id`, `billing-email`, `billing-last-name`, `total-including-tax`, `refunded-amount`, `date-created`.
**Step 2: Check HubSpot for tickets**
For each order call `hubspot-get-contacts` with `email` set to the `billing-email`. If found, call `hubspot-get-tickets` with `contact-id` set to the contact `record-id` and `create-date.from` set to the order `date-created`. If no contact exists, mark the order as having no HubSpot contact.
**Step 3: Report**
A table: order id, customer email, total, refunded, ticket status (none, open, closed, or no contact). Put orders with no ticket first. End with counts for each ticket status.
**Rules & Guidelines:**
* `bigcommerce-get-order` is on the bigcommerce server; `hubspot-get-contacts` and `hubspot-get-tickets` are on the hubspot server.
* Read only. Do not call `hubspot-add-ticket`, `hubspot-update-ticket`, `hubspot-add-contact-note` or any write tool on bigcommerce.
**Validation:**
* If no refunded orders are found, say so and stop.
* Orders with no `billing-email` are listed as unmatchable.Who it's for
One answer, three teams that use it
Support managers
Make sure refunds get a follow-up
Refunded orders with no ticket are listed first, so nobody slips through.
Which BigCommerce refunds in the last 14 days have no HubSpot ticket?
Customer success managers
Reach unhappy customers early
Large refunds with no ticket point to customers who may need a personal check in.
Show BigCommerce refunds over 200 in the last 60 days and whether the buyer has a HubSpot ticket.
Quality leads
Check refunds are being logged
Counts by ticket status show whether refunds are being captured as support cases.
How many BigCommerce refunds this month have an open, closed or no HubSpot ticket?
How it works
What PopdockAI does when you ask
You say how far back to look and the smallest refund, and your AI assistant checks each refunded BigCommerce buyer for a HubSpot ticket. It only reads.
01
Ask
You say how far back to look and the smallest refund to include.
02
Find
It reads refunded BigCommerce orders, up to 50.
03
Check
It finds each buyer in HubSpot by billing email and reads tickets created since the order.
04
Report
It lists orders with no ticket first, then counts for each ticket status.
What PopdockAI provides
The tools behind the answer
Ready made tools for BigCommerce and one secure connection to your AI tool. No code, no exports.
bigcommerce-get-order
hubspot-get-contacts
hubspot-get-tickets
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
No refunded buyer left without a follow-up
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
