Connectors

/

BigCommerce

/

Find BigCommerce refunds with no HubSpot ticket
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Find BigCommerce refunds with no HubSpot ticket
Which BigCommerce orders refunded in the last 30 days have no HubSpot ticket?
3 of the 18 refunded orders have no HubSpot ticket, and 2 more have no HubSpot contact. - Order 10455: dana@northwindtraders.com, 150.00 refunded of 150.00 - Order 10461: sam@contoso.com, 40.00 refunded of 120.00 - Open ticket: 6 orders, closed ticket: 7 orders Want the full table of all 18 orders?
BigCommerce
Sample figures. Your results come from your own account.
bigcommerce-get-order
hubspot-get-contacts
hubspot-get-tickets

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

BigCommerce

BigCommerce
Run it on your own BigCommerce data.

Connect BigCommerce, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Find

It reads refunded BigCommerce orders, up to 50.

bigcommerce-get-order

03

Check

It finds each buyer in HubSpot by billing email and reads tickets created since the order.

hubspot-get-contacts
hubspot-get-tickets

04

Report

It lists orders with no ticket first, then counts for each ticket status.

Your AI tool

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.

get-data

bigcommerce-get-order

Returns orders from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
get-data

hubspot-get-contacts

Returns contact records from HubSpot CRM, with email, phone, company, lifecycle stage, lead status, owner and location from the HubSpot connector. Filter by company id, state region, contact owner, email, last name, create date, company name, record id, lifecycle stage, lead status.
get-data

hubspot-get-tickets

Returns support tickets from HubSpot, with name, status, priority, category, owner, dates and associated contact and company from the HubSpot connector. Filter by category, record id, priority, ticket name, create date, ticket status, company id, contact id, ticket owner.
Read only.Nothing in BigCommerce Changes

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.

How Popdock AI secures your data

The outcome

No refunded buyer left without a follow-up

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation