Connectors

/

Attio

/

Attio account WooCommerce revenue and refund review
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Attio account WooCommerce revenue and refund review
Review store revenue and refunds for the Attio company with domain northwindtraders.com over the last 180 days.
Northwind Traders spent 12,480 USD across 14 orders, with 1,560 USD refunded, a 12.5 percent refund rate, so the account is flagged. - Dana Whitfield: 9 orders, 8,200 USD, 1 refund - Sam Patel: 5 orders, 4,280 USD, 2 refunds - Top refund reason: Damaged in transit - Inactive buyers: 1 contact with no orders Want the refund details per order?
Attio
Sample figures. Your results come from your own account.
attio-get-record-companies
attio-get-record-people
woocommerce-get-order
woocommerce-get-refund

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Attio

Attio
Run it on your own Attio data.

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

Try PopdockAI free

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.

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

Your AI tool

02

Find

It matches the company in Attio and collects its people's emails.

attio-get-record-companies
attio-get-record-people

03

Pull

It reads each person's WooCommerce orders and refunds.

woocommerce-get-order
woocommerce-get-refund

04

Report

You get per person figures, company totals, the refund rate and any flag.

Your AI tool

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.

get-data

attio-get-record-companies

Returns companies from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

attio-get-record-people

Returns people from Attio CRM. Read-only; filter by the fields the tool offers.
get-data

woocommerce-get-order

Returns WooCommerce orders with status, totals, discounts, shipping, payment method and paid date. Filter by status, customer email or id, order number, created date range, total range or billing last name.
get-data

woocommerce-get-refund

Returns WooCommerce refunds with amount, reason, who made them and whether the gateway returned the money. Filter by order, customer, amount range and date range.
Read only.Nothing in Attio 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

Spend, refunds and refund risk for every account

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