Connectors

/

Shopify

/

Shopify and Rillet B2B account review
Report
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Shopify and Rillet B2B account review
Review Fabrikam Inc across Shopify and Rillet before my call tomorrow.
Fabrikam Inc owes 8,420.00 in Rillet, and 2 issues need attention. - Missing invoice: order #1047 has no Rillet invoice - Overdue but paid: #1038 shows paid in Shopify, overdue in Rillet - Terms: Net 30 in Shopify, Net 45 in Rillet - ARR: 64,000.00 Suggested next step: check how payment for #1038 was applied in Rillet.
Shopify
Sample figures. Your results come from your own account.
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

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Shopify

Shopify
Run it on your own Shopify data.

Connect Shopify, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Read

It reads the company, terms, contacts and recent orders in Shopify.

shopify-get-company
shopify-get-company-location
shopify-get-company-contact
shopify-get-order

03

Match

It finds the Rillet customer and reads invoices, credit memos, contracts and ARR.

rillet-get-customers
rillet-get-customer-emails
rillet-get-invoices
rillet-get-credit-memos
rillet-get-contracts
rillet-get-arr-waterfall

04

Report

You get the gaps between the two and a suggested next action.

Your AI tool

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.

get-data

shopify-get-company

Returns Shopify B2B companies with their order count and total spent. Filter by name, company id, external id, customer since date, order count and total spent.
get-data

shopify-get-company-location

Returns the locations of Shopify B2B companies with their shipping address and total spent. Filter by company, location name, external id, city, province and country.
get-data

shopify-get-company-contact

Returns the contacts of Shopify B2B companies. Filter by company, contact name, email, job title and whether they are the main contact.
get-data

shopify-get-order

Returns Shopify orders with their financial status, fulfillment status and total. Filter by order number or name, customer, email, financial status, fulfillment status, created date and total price.
get-data

rillet-get-customers

Returns customers (name, address, payment terms, invoicing settings) from Rillet.
get-data

rillet-get-customer-emails

Returns customer email addresses with their type and the customer's location from Rillet.
get-data

rillet-get-invoices

Returns customer invoices (number, customer, dates, status, totals, amount due) from Rillet.
get-data

rillet-get-credit-memos

Returns customer credit memos (number, customer, invoice, totals) from Rillet.
get-data

rillet-get-contracts

Returns customer contracts (term, status, total value, invoicing) from Rillet.
get-data

rillet-get-arr-waterfall

Returns annual recurring revenue by customer and month from Rillet.
Read only.Nothing in Shopify Changes

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.

How Popdock AI secures your data

The outcome

Buying and balance together, with every gap flagged

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation