/
/
Answer customer account questions across WooCommerce and Intacct
For finance and support teams who want a customer's store activity and Sage Intacct balance in one view from their AI assistant.
On this page
Connector
Connect WooCommerce, pick your AI tool and paste the prompt.
The problem
Account questions that span the store and the ledger
Questions about a customer's account mean checking WooCommerce for orders and refunds and Sage Intacct for balance, overdue invoices and payments. Completed orders that were never invoiced fall through the gap between the two.
Without PopdockAI
- Look up orders and refunds in WooCommerce
- Find the customer in Sage Intacct
- Check balance, overdue invoices and payments
- Miss completed orders that were never invoiced
With PopdockAI
- Profile, orders and refunds are read for the period
- The Intacct customer is accepted only where the email agrees
- Balance, credit headroom, overdue invoices and payments are shown
- Completed orders never invoiced are called out, 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:** Give a single view of the customer with email `{customer-email}` across WooCommerce and Intacct, covering the last `{lookback-days}` days (default 90).
**Step 1: Read WooCommerce**
Call `woocommerce-get-customer` with `email` = `{customer-email}` and keep the name, `billing-company`, `billing-city`, `billing-state`, `created-date` and `paying-customer`.
Call `woocommerce-get-order` with `customer-email` = `{customer-email}` and `created-date.from` = today minus `{lookback-days}` days (default 90). Call `woocommerce-get-refund` with `customer-email` = `{customer-email}` over the same range.
**Step 2: Find the Intacct customer**
Try, in order, and stop at the first single match:
1. `intacct-get-contact` with `email` = the WooCommerce email, then `intacct-get-customer` with `customer-name` = the contact's `company-name`.
2. If the WooCommerce customer has a `billing-company` (from `woocommerce-get-customer`), `intacct-get-customer` with `customer-name` = that company.
3. `intacct-get-customer` with `customer-name` = the WooCommerce first and last name.
Treat a match as confirmed when the Intacct customer's `email` equals the WooCommerce email (ignoring case) or is empty. If it holds a different email, report it as a possible wrong match instead of using it.
If there is no match, report the WooCommerce side only, say the customer is not in Intacct, and suggest the sync-customer-to-intacct prompt.
**Step 3: Read Intacct**
Call `intacct-get-customer` with `customer-id` and keep `status`, `term`, `credit-limit`, `total-due` and `last-invoice-date`.
Call `intacct-get-invoice` with `customer-id` and `total-due.min` = 0.01 for open invoices; mark as overdue those whose `due-date` is before today.
Call `intacct-get-ar-payment` with `customer-id` and `receipt-date.from` = the start of the range.
**Step 4: Report**
* Identity: the name, company, city and state on each side, flagging any that disagree.
* Store activity: order count, order total, refund total, last order date, and orders by status.
* Ledger position: total due, credit limit and headroom, term, open and overdue invoices with amounts and days overdue, payments received in the range.
* Gaps: WooCommerce orders in the range that are not processing, completed or refunded, and completed orders with no Intacct invoice whose `reference-number` equals the order number (check against invoices read with `intacct-get-invoice` for this customer over the range).
**Rules & Guidelines:**
* `woocommerce-get-customer`, `woocommerce-get-order` and `woocommerce-get-refund` are on the woocommerce server. `intacct-get-contact`, `intacct-get-customer`, `intacct-get-invoice` and `intacct-get-ar-payment` are on the intacct server.
* This prompt is read-only. Do NOT call `woocommerce-update-customer`, `woocommerce-update-order`, `intacct-update-customer`, `intacct-create-customer` or any other write tool.
**Validation:**
* If WooCommerce has no customer or order for the email, check Intacct anyway and say the email is unknown to the store.
* If Intacct amounts are in a different currency from the store orders, show both currencies and do not add them together.Who it's for
One answer, three teams that use it
Customer support agents
Answer account questions in one go
See orders, refunds and the Intacct balance together while the customer is on the line.
Review the account for tom@contoso.com across WooCommerce and Sage Intacct.
Credit controllers
Check headroom before an order
Credit headroom and overdue invoices sit beside recent store activity.
How much credit headroom does orders@northwindtraders.com have in Intacct, and what have they ordered lately?
Accountants
Find orders never invoiced
Completed orders with no Intacct invoice are listed, so revenue is not missed.
Has every completed WooCommerce order for priya@fabrikam.com been invoiced in Intacct?
How it works
What PopdockAI does when you ask
You give the customer's email, and your AI assistant brings the store and the ledger into one view. Currencies are kept apart and nothing is changed.
01
Ask
You give the customer's email.
02
Read
It reads their WooCommerce profile, orders and refunds for the period.
03
Find
It finds them in Sage Intacct only where the email agrees and reads receivables.
04
Report
You get both sides and completed orders never invoiced.
What PopdockAI provides
The tools behind the answer
Ready made tools for WooCommerce and one secure connection to your AI tool. No code, no exports.
woocommerce-get-customer
woocommerce-get-order
woocommerce-get-refund
sage-intacct-get-contact
sage-intacct-get-customer
sage-intacct-get-invoice
sage-intacct-get-ar-payment
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
One view for every account question
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)
