/
/
See what a B2B customer orders and owes, in one review
For account managers and finance teams who want a B2B customer's Shopify orders compared with Rillet receivables, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
What a B2B customer orders and owes live apart
For a B2B customer, what they order lives in Shopify and what they owe lives in Rillet. The gaps are where trouble starts: an outstanding order with no invoice, an invoice overdue on an order Shopify shows as paid, or payment terms that differ.
Without PopdockAI
- Read terms, contacts and orders in Shopify
- Find the right customer in Rillet
- Compare invoices and credit memos with orders
- Miss the order with no invoice or the clashing terms
With PopdockAI
- Company, terms, contacts and recent orders are read from Shopify
- The Rillet customer is found by external ID, name or email
- Invoices, credit memos, contracts and ARR are compared with orders
- Gaps are flagged with a next action, 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 combined account review of the B2B customer `{company-name}` covering its Shopify buying over the last `{lookback-days}` days (default 90) and its Rillet receivables, and flag where the two systems disagree.
**Step 1: Find the company in Shopify**
Call `shopify-get-company` filtered by name `{company-name}`. If nothing matches, retry with name.contains. If more than one matches, list them and stop. Note company-id, name, external-id, orders-count, total-spent and customer-since.
Call `shopify-get-company-location` filtered by company-name and note each location's name, payment-terms-template-name and tax-exempt. Call `shopify-get-company-contact` filtered by company-id and note each contact's customer-id and customer-email.
**Step 2: Recent Shopify orders**
For each contact customer-id, call `shopify-get-order` filtered by customer-id with created-at.from set to `{lookback-days}` days ago. Note name, created-at, total-price, total-outstanding, financial-status and fulfillment-status.
**Step 3: Find the customer in Rillet**
Call `rillet-get-customers` (no filters). Match by customer-id equal to the Shopify external-id, then by name ignoring case. If neither matches, call `rillet-get-customer-emails` and match a contact email. If still nothing, report the Shopify side only and say the company has no Rillet customer.
**Step 4: Rillet receivables**
Keep only this customer-id's rows from `rillet-get-invoices` (no filters): invoice-number, invoice-date, due-date, total, amount-due, overdue. Call `rillet-get-credit-memos` and `rillet-get-contracts` filtered by customer-id. Call `rillet-get-arr-waterfall` filtered by customer-id for the latest year-month.
**Step 5: Compare**
For each Shopify order with total-outstanding above 0, find the Rillet invoice whose invoice-number equals the order name, with or without the leading #. Flag:
* orders outstanding in Shopify with no Rillet invoice
* orders whose Shopify total-outstanding differs from the Rillet amount-due
* Rillet invoices overdue on orders Shopify shows as paid
* payment terms that differ between the Shopify location and the Rillet customer
**Step 6: Report**
Shopify: company, locations and terms, orders in the period, total spent, outstanding.
Rillet: open AR, overdue AR, unapplied credits, active contracts and their end dates, current ARR.
Disagreements: the flagged items as a table.
Close with the next action if there is an obvious one, such as chasing an overdue invoice or recording a payment.
**Rules & Guidelines:**
* Shopify tools, all on the shopify server: `shopify-get-company`, `shopify-get-company-location`, `shopify-get-company-contact`, `shopify-get-order`.
* Rillet tools, all on the rillet server: `rillet-get-customers`, `rillet-get-customer-emails`, `rillet-get-invoices`, `rillet-get-credit-memos`, `rillet-get-contracts`, `rillet-get-arr-waterfall`.
* This prompt is read-only. Do not call `rillet-add-invoice-payment`, `rillet-update-customer`, `rillet-apply-credit-memo`, `shopify-update-company` or any other write tool.
**Validation:**
* If the company is not in Shopify, say so and stop.
* If amounts are in different currencies, show both and do not convert.Who it's for
One answer, three teams that use it
B2B account managers
Prepare for the call with both sides
See what the customer orders and what they owe, so the conversation covers both.
Review Contoso Ltd across Shopify and Rillet before my call this afternoon.
Accounts receivable
Find orders with no invoice
Outstanding orders with no Rillet invoice are flagged, so billing gaps are closed.
Which outstanding Shopify orders from Northwind Traders have no invoice in Rillet?
Finance managers
Catch terms that disagree
Payment terms that differ between store and ledger are called out alongside contracts and ARR.
Do Fabrikam Inc's payment terms match between Shopify and Rillet, and what is their current ARR?
How it works
What PopdockAI does when you ask
You name the company, and your AI assistant reviews it across Shopify and Rillet. It only reads both systems and keeps currencies apart.
01
Ask
You name the company.
02
Read
It reads the company, terms, contacts and recent orders in Shopify.
03
Match
It finds the Rillet customer and reads invoices, credit memos, contracts and ARR.
04
Report
You get the gaps between the two and a suggested next action.
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-company
shopify-get-company-location
shopify-get-company-contact
shopify-get-order
rillet-get-customers
rillet-get-customer-emails
rillet-get-invoices
rillet-get-credit-memos
rillet-get-contracts
rillet-get-arr-waterfall
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
Buying and balance together, with every gap flagged
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)
