/
/
See Shopify purchases beside the FreshBooks balance
For account managers who want a customer's orders and outstanding balance in one answer by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
What a customer bought and owes sit in different places
An account manager preparing for a call has to work out what the customer bought in Shopify and what they still owe in FreshBooks. Pulling both together by hand takes several screens, and amounts in different currencies are easy to add up wrongly.
Without PopdockAI
- Look up the customer's Shopify orders
- Find their FreshBooks invoices and payments
- Work out invoiced, paid and outstanding totals
- Add up mixed currencies by mistake
With PopdockAI
- Shopify orders are read for the look-back period
- FreshBooks invoices and payments are read for the same customer
- Totals sit side by side, with currencies kept separate
- Overdue invoices and uninvoiced paid orders are listed, read-only
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For the customer with email `{email}`, show Shopify purchase history beside FreshBooks billing and balance. FreshBooks company: `{company}`. Look back `{lookback-days}` days (default 365).
**Step 1: Shopify side**
Call `shopify-get-customer` with `email` set to `{email}` to get customer-id, orders-count and total-spent. Then call `shopify-get-order` with `customer-id` and `created-at.from` set to the start of the look-back. Keep name, total-price, financial-status and created-at.
**Step 2: FreshBooks side**
Call `freshbooks-get-client` with `email` set to `{email}` and `company` set to `{company}`. If no client matches, report that and finish with the Shopify figures only. Otherwise call `freshbooks-get-invoice` with `customer-id` set to the client id and `create-date.from` set to the start of the look-back, then `freshbooks-get-payment` with `client-id` set to the same id and `date.from` likewise.
**Step 3: Report**
A summary: Shopify orders and total, FreshBooks invoiced total, paid total, outstanding total (sum of invoice outstanding). List any invoice that is overdue or any paid Shopify order with no invoice.
**Rules & Guidelines:**
* `shopify-get-customer` and `shopify-get-order` are on the shopify server; `freshbooks-get-client`, `freshbooks-get-invoice` and `freshbooks-get-payment` are on the freshbooks server.
* Read-only. Call no write tool on either server.
**Validation:**
* Do not add amounts in different currencies; report each currency separately.
* If the Shopify customer is not found, say so and still report the FreshBooks side.Who it's for
One answer, three teams that use it
Account managers
Walk into the call knowing the balance
See what the customer bought and what is outstanding before you talk renewals or new orders.
Show what alex@contoso.com bought on Shopify this year and what she still owes in FreshBooks.
Bookkeepers
Spot paid orders never invoiced
Paid Shopify orders with no invoice are listed, so the books catch up.
Does sam@fabrikam.com have any paid Shopify orders with no FreshBooks invoice in the last 6 months?
Store owners
Know who owes you before you ship
Overdue invoices beside recent orders tell you whether to chase payment first.
Is jordan@northwindtraders.com overdue in FreshBooks while still ordering on Shopify?
How it works
What PopdockAI does when you ask
You give an email and the company, and your AI assistant puts Shopify purchases beside the FreshBooks balance. It reports one side even if the other is missing and changes nothing.
01
Ask
You give the customer email, the FreshBooks company and a look-back period.
02
Read Shopify
It reads the customer's orders in that period.
03
Read FreshBooks
It reads their invoices and payments, or reports the Shopify side alone.
04
Report
You get totals side by side, overdue invoices and uninvoiced paid orders.
What PopdockAI provides
The tools behind the answer
Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.
shopify-get-customer
shopify-get-order
freshbooks-get-client
freshbooks-get-invoice
freshbooks-get-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
Bought and owed in one summary, before the call
Related use cases
More ways to put this data to work
Match a Shopify order to its FreshBooks invoice
Ask your AI to find the FreshBooks invoice for a Shopify order. It compares total, currency and payment status, and flags cancelled orders without guessing.
Learn More
Find unbilled Shopify orders in FreshBooks
Ask your AI which paid Shopify orders have no FreshBooks invoice. It lists them with totals and whether the client exists, and creates nothing.
Learn More
Reconcile a Shopify customer with a FreshBooks client
Ask your AI to compare a Shopify customer with the FreshBooks client for the same email. It marks each detail Match or Differs and changes nothing.
Learn More
Compare Shopify products with FreshBooks items by SKU
Ask your AI to match Shopify variants and FreshBooks items by SKU. It lists items missing on either side and price differences, and fixes nothing.
Learn More
Review a Shopify customer account
Ask your AI to review a Shopify customer and it builds a one-page summary of spend, orders, refunds, failed payments, cards and store credit.
Learn More
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.