/
/
Find paid BigCommerce orders that were never invoiced
For finance teams who want to catch BigCommerce orders missing a FreshBooks invoice, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Paid orders sit for weeks without an invoice
Orders get paid in BigCommerce, but nobody checks FreshBooks to see whether an invoice was raised. Spotting them means matching order totals and emails against the invoice list by hand, so revenue is earned but never billed.
Without PopdockAI
- Export paid orders from BigCommerce
- Search FreshBooks for each customer
- Match invoices by amount and date by eye
- Leave unbilled orders for weeks
With PopdockAI
- Orders since your start date are read
- Each billing email is checked for a FreshBooks client and matching invoice
- Unbilled orders are grouped by whether the client exists, with count and value
- Uncertain matches go to a review list, and nothing is created
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** List BigCommerce orders created since `{date-from}` that are paid or shipped but have no FreshBooks invoice, so they can be billed.
**Step 1: Read the orders**
Call `bigcommerce-get-order` (bigcommerce server) with `date-created.from` set to `{date-from}` and `payment-status` set to `{payment-status}` (default: paid). Keep `id`, `billing-email`, `billing-first-name`, `billing-last-name`, `total-including-tax`, `currency-code` and `date-created`.
**Step 2: Check FreshBooks**
For each distinct `billing-email` call `freshbooks-get-client` (freshbooks server) with `email` set to it. When a client exists, call `freshbooks-get-invoice` (freshbooks server) with `customer-id` set to the client `id` and `create-date.from` set to `{date-from}`. An order counts as billed if an invoice has `po-number` equal to the order `id`, or the same `amount` and `currency-code`.
**Step 3: Report**
A table of unbilled orders: order id, date, email, total, and whether the customer already exists as a FreshBooks client (yes or no). Group them into "client exists" and "client missing". Finish with the count and total value.
**Rules & Guidelines:**
* `bigcommerce-get-order` is on the bigcommerce server. `freshbooks-get-client` and `freshbooks-get-invoice` are on the freshbooks server.
* Read-only. Never create clients or invoices from this prompt. Name the `invoice-bigcommerce-order` prompt as the next step.
**Validation:**
* If no orders match, say so and stop.
* An order whose invoice match is uncertain goes in a separate "needs review" list, not in the unbilled list.Who it's for
One answer, three teams that use it
Bookkeepers
Bill everything you have been paid for
Unbilled orders with id, date, email and total are ready to work through.
Which paid BigCommerce orders since 1 October have no FreshBooks invoice?
Small business owners
Know how much is unbilled
A count and total value show how much revenue is missing from the books.
What is the total value of BigCommerce orders this month with no FreshBooks invoice?
Accountants
Review doubtful matches
Uncertain matches are kept apart, so you check them instead of trusting a guess.
Show BigCommerce orders since 1 August where the FreshBooks invoice match needs review.
How it works
What PopdockAI does when you ask
You give a start date and your AI assistant checks BigCommerce orders for a matching FreshBooks invoice. It only reads, so you decide what to bill.
01
Ask
You give a start date and optionally a payment status.
02
Read
It reads the BigCommerce orders since that date.
03
Check
It looks for each customer and a matching invoice in FreshBooks.
04
Report
You get unbilled orders grouped by client exists or missing, with a count and total.
What PopdockAI provides
The tools behind the answer
Ready made tools for BigCommerce and one secure connection to your AI tool. No code, no exports.
bigcommerce-get-order
freshbooks-get-client
freshbooks-get-invoice
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
Every paid order that still needs an invoice
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)
