/
/
Review an Attio account's WooCommerce spend and refunds
For account teams who want their AI assistant to total a company's store orders and refunds from its Attio contacts.
On this page
Connector
Connect Attio, pick your AI tool and paste the prompt.
The problem
Refund risk hides in spreadsheets of store orders
Judging an account means adding up what a company's people bought and refunded in WooCommerce, then comparing it with the Attio record. That takes exports and manual matching, and risky accounts hide in the sums.
Without PopdockAI
- Find the company and its people in Attio
- Export WooCommerce orders and refunds to a spreadsheet
- Match each order to a contact by hand
- Work out refund rates and miss the risky accounts
With PopdockAI
- The company is matched in Attio by domain
- Orders and refunds are read for each known contact only
- Spend and refunds are totalled per person and per currency
- Accounts with a refund rate above 10 percent are flagged
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Review store revenue and refunds for the Attio company with domain {company-domain} over the last {lookback-days} days (default 180).
**Step 1: Find the company in Attio**
Call `attio-get-record-companies` with `domains` = {company-domain}. If none match, stop. Keep `record-id`, `name`, `estimated-arr` and `last-interaction`.
**Step 2: List its people**
Call `attio-get-record-people` with `company` = the company `name`. Collect every email in `email-addresses`. If no people have emails, report that and stop.
**Step 3: Pull store activity**
For each email call `woocommerce-get-order` with `customer-email` and `created-date.from` = today minus {lookback-days} days, and `woocommerce-get-refund` with `customer-email` and the same `created-date.from`. People with no orders and no refunds are listed as inactive buyers.
**Step 4: Report**
Company header; per person: orders, spend, refunds; company totals: order count, gross spend, refunded amount, refund rate (refunded / gross), and the most common refund `reason` values. Flag the account when the refund rate is above 10 percent, or when there are no orders in the period although `last-interaction` is recent.
**Rules & Guidelines:**
* Tools named attio-* are on the attio server; tools named woocommerce-* are on the woocommerce server. Both servers must be connected.* This is read-only. Do not call any add, update, upsert, delete or send tool on either server (for example `attio-add-person`, `attio-update-person`, `attio-add-deal`, `woocommerce-update-customer`, `woocommerce-add-refund`, `woocommerce-send-order-details`).
**Validation:**
* Total each currency separately.
* Do not guess people from the company domain in WooCommerce; use only the Attio contacts.Who it's for
One answer, three teams that use it
Account managers
Know an account's real spend before you call
See orders, refunds and net spend per contact and for the whole company, matched only to people you already know in Attio.
What have people at contoso.com spent and refunded in WooCommerce over the last 90 days?
Support leads
Spot accounts with a refund problem
The refund rate and the most common refund reasons show whether an account has a product or service issue worth raising.
Check the refund rate and top refund reasons for the Attio company fabrikam.com over the last 6 months.
Finance analysts
Get refund totals by currency without exports
Totals are kept per currency, so the figures are ready to use without a spreadsheet of store exports.
Total WooCommerce orders and refunds by currency for northwindtraders.com over the last 365 days, using its Attio contacts.
How it works
What PopdockAI does when you ask
You give the company domain and how far back to look, and your AI assistant pulls the store figures through the Attio contacts. It changes nothing in either system.
01
Ask
You give the company domain and how far back to look.
02
Find
It matches the company in Attio and collects its people's emails.
03
Pull
It reads each person's WooCommerce orders and refunds.
04
Report
You get per person figures, company totals, the refund rate and any flag.
What PopdockAI provides
The tools behind the answer
Ready made tools for Attio and one secure connection to your AI tool. No code, no exports.
attio-get-record-companies
attio-get-record-people
woocommerce-get-order
woocommerce-get-refund
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
Spend, refunds and refund risk for every account
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)
