/
/
Spot unhappy Freshdesk customers who also got BigCommerce refunds
For support teams who ask their AI assistant which customers with low ratings also had refunded or cancelled orders.
On this page
Connector
Connect Freshdesk, pick your AI tool and paste the prompt.
The problem
Unhappy and costly customers never show up together
Low satisfaction scores sit in Freshdesk and refunds sit in BigCommerce, so customers who are both unhappy and costly never show up together. Each team sees half the picture and the expensive complaints go unnoticed.
Without PopdockAI
- Export low ratings from Freshdesk
- Find the requester behind each ticket
- Search BigCommerce for their orders and refunds
- Add up refunds in a spreadsheet
With PopdockAI
- Low ratings are read with the ticket and requester behind each
- BigCommerce orders around that period are checked for refunds
- Customers with both are named, largest refund first
- Customers with no orders are listed, and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List customers who left a satisfaction rating of `{max-rating}` or lower in the last `{lookback-days}` days (defaults 2 and 30) and show whether they had refunds or issues on BigCommerce orders.
**Step 1: Low ratings in Freshdesk**
Call `freshdesk-get-satisfaction-ratings` (Freshdesk server) with `rating.max` set to the maximum and `created-at.from` set to the lookback start. Collect each `ticket-id`.
**Step 2: Resolve the customer**
For each ticket call `freshdesk-get-tickets` with `ticket-id` and take `requester-email`.
**Step 3: Check BigCommerce**
For each distinct email call `bigcommerce-get-order` (BigCommerce server) with `billing-email` set to it and `date-created.from` set to the lookback start extended by 30 days. Note orders where `refunded-amount` is above zero or `status` is a cancelled, refunded or declined state.
**Step 4: Report**
A table: customer email, rating, ticket-id and subject, orders found, total refunded. Then name the customers with both a low rating and a refund, ordered by refunded amount.
**Rules & Guidelines:**
* `freshdesk-get-satisfaction-ratings` and `freshdesk-get-tickets` are on the Freshdesk server; `bigcommerce-get-order` is on the BigCommerce server.
* Do not call any write tool on either server (no freshdesk-add-*, freshdesk-update-*, freshdesk-delete-*, freshdesk-reply-to-ticket, and no bigcommerce-*-add, -update or -delete tools).
**Validation:**
* If no ratings match, say so and stop.
* If an email has no BigCommerce orders, list it as "no orders found" rather than dropping it.Who it's for
One answer, three teams that use it
Support managers
Find the costliest complaints
Customers with both a low rating and a refund come first, ranked by amount.
Which customers rated Freshdesk 1 this quarter and also had refunded BigCommerce orders?
Ecommerce managers
Link refunds to the support experience
Refunds, cancellations and declines beside low ratings show where service problems are costing sales.
Show low Freshdesk ratings from the last 60 days with refunded or cancelled BigCommerce orders for each customer.
Finance analysts
Quantify refunds tied to unhappy customers
Total refunded per unhappy customer gives you a number to bring to the service review.
How much did we refund in BigCommerce to customers who gave poor Freshdesk ratings last month?
How it works
What PopdockAI does when you ask
You set the highest rating to include and a period, and your AI assistant checks each unhappy customer for refunds. It only reads both systems.
01
Ask
You set the highest rating to include and a lookback window.
02
Find
It reads the low Freshdesk ratings and the requester behind each ticket.
03
Check
It looks for each customer's BigCommerce orders and notes refunds and cancellations.
04
Report
You get a table and the customers with both a low rating and a refund.
What PopdockAI provides
The tools behind the answer
Ready made tools for Freshdesk and one secure connection to your AI tool. No code, no exports.
freshdesk-get-satisfaction-ratings
freshdesk-get-tickets
bigcommerce-get-order
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
See which unhappy customers also cost you a refund
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)
