/
/
Find ShipStation purchase orders that were never billed in FreshBooks
For finance teams who want ShipStation purchase orders checked against FreshBooks vendors and bills, just by asking their AI assistant.
On this page
Connector
Connect FreshBooks, pick your AI tool and paste the prompt.
The problem
Purchase orders go unbilled until the supplier chases
Purchase orders raised in ShipStation are easy to forget to bill. Nobody notices an order with no vendor or bill in FreshBooks until the supplier asks for payment.
Without PopdockAI
- List purchase orders in ShipStation
- Search FreshBooks for each supplier
- Check each vendor's bills
- Payables go unrecorded
With PopdockAI
- Purchase orders and suppliers are read
- Each supplier is matched to a FreshBooks vendor
- Bills are checked by order or reference number
- Ambiguous matches marked, nothing created
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For purchase orders in ShipStation with status `{po-status}` (default all statuses), check whether the supplier exists as a FreshBooks vendor and whether a bill has been entered for the order.
**Step 1: Read purchase orders (ShipStation server)**
Call `shipstation-get-purchase-order`, setting status to `{po-status}` when it is not empty. Keep `order-number`, `reference-number`, `supplier-name`, `supplier-id`, `order-date` and `expected-delivery-date`. If you need the supplier's contact email, call `shipstation-get-supplier` and match on supplier-id.
**Step 2: Find the vendor (FreshBooks server)**
For each distinct supplier-name call `freshbooks-get-vendor` with vendor-name set to the supplier-name; if nothing comes back, retry with vendor-name.contains. Take the vendor `id`.
**Step 3: Find the bill (FreshBooks server)**
For each vendor found, call `freshbooks-get-bill` with vendor-id set to that id. A bill matches a purchase order when its bill-number equals the order-number or reference-number.
**Step 4: Report**
A table with one row per purchase order: order-number, supplier, vendor found (yes or no), bill found (yes or no), bill status and outstanding amount. Group the rows into: no vendor in FreshBooks, vendor but no bill, billed.
**Rules & Guidelines:**
* `shipstation-get-purchase-order` and `shipstation-get-supplier` are on the shipstation server; `freshbooks-get-vendor` and `freshbooks-get-bill` are on the freshbooks server.
* Read-only. Do not call `freshbooks-add-vendor`, `freshbooks-add-bill` or any other freshbooks write tool.
**Validation:**
* If several vendors match one supplier name, list them and mark that row as ambiguous rather than picking one.
* If no purchase orders come back, say so and stop.Who it's for
One answer, three teams that use it
Accounts payable
Enter every bill on time
See purchase orders with a vendor but no bill, so you can enter them before month end.
Which ShipStation purchase orders have a FreshBooks vendor but no bill?
Purchasing managers
Check suppliers are set up
Orders whose supplier has no FreshBooks vendor are grouped for set up.
Which ShipStation suppliers are not set up as vendors in FreshBooks?
Controllers
Close the month with complete payables
See billed, unbilled and missing-vendor orders with outstanding amounts in one report.
Check all received ShipStation purchase orders against FreshBooks bills.
How it works
What PopdockAI does when you ask
You choose a purchase order status and your AI assistant checks each order against FreshBooks vendors and bills. It reports only.
01
Ask
You give a purchase order status, or check all of them.
02
Read
It pulls the ShipStation purchase orders and their suppliers.
03
Match
It finds each supplier as a FreshBooks vendor, then looks for a bill with the order or reference number.
04
Report
It groups orders into no vendor, vendor but no bill, and billed.
What PopdockAI provides
The tools behind the answer
Ready made tools for FreshBooks and one secure connection to your AI tool. No code, no exports.
freshbooks-get-vendor
freshbooks-get-bill
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
Find unrecorded payables before they are missed
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)
