/
/
Find BigCommerce customers with no Intacct customer record
For operations teams who want new store customers to exist in the ERP before the first invoice, just by asking their AI assistant.
On this page
Connector
Connect BigCommerce, pick your AI tool and paste the prompt.
The problem
Missing ERP customers surface only when an invoice fails
New BigCommerce customers are not created in Intacct until an invoice fails, and by then nobody knows who is missing. Checking by hand means matching store names against Intacct customers, where company spellings rarely agree.
Without PopdockAI
- Export new customers from BigCommerce
- Search Intacct by company or name
- Guess whether near matches are the same customer
- Find the gap when an invoice fails
With PopdockAI
- New customers are read, capped at 50
- Intacct is searched for each company or name
- Near matches are set aside as possible duplicates with their ID
- Missing customers get order count and spend, 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:** Find BigCommerce customers created in the last `{lookback-days}` days (default 30) that have no matching Intacct customer, ordered by how much they have bought.
**Step 1: Read the new customers from BigCommerce**
Call `bigcommerce-get-customer` (bigcommerce server) with `date-created.from` set to the start of the window. If more than 50 come back, work on the first 50 and say the list was capped. Keep `id`, `name`, `company`, `email` and `date-created`.
**Step 2: Check each one in Intacct**
For each customer call `intacct-get-customer` (intacct server) with `customer-name.contains` set to the `company` if present, otherwise the `name`. Treat the customer as present when a returned `customer-name` equals that value case-insensitively; treat it as absent when nothing comes back or nothing equals it. Report near matches separately as possible duplicates with their `customer-id`.
**Step 3: Add spend for the missing ones**
For each absent customer call `bigcommerce-get-order` (bigcommerce server) with `customer-id` set to the BigCommerce id and total the order count and `total-including-tax`.
**Step 4: Report**
Show the counts checked, present, possible duplicates and missing, then a table of the missing customers with name, company, email, created date, order count and spend, highest spend first.
**Rules & Guidelines:**
* `bigcommerce-get-customer` and `bigcommerce-get-order` are on the bigcommerce server. `intacct-get-customer` is on the intacct server.
* This prompt only reads. It does not create the missing customers. Never call any `bigcommerce-customer-add`, `bigcommerce-customer-update`, `bigcommerce-customer-delete`, `bigcommerce-product-add`, `bigcommerce-product-update` or other bigcommerce add, update or delete tool, and never call `intacct-create-customer`, `intacct-update-customer`, `intacct-create-vendor`, `intacct-create-order-entry-document`, `intacct-update-order-entry-document` or any other Intacct create or update tool.
**Validation:**
* If no customers were created in the window, say so and stop.
* Customers with no company and a common name are ambiguous; mark them as unverified rather than missing.
Who it's for
One answer, three teams that use it
Order operations
Set up customers before invoicing
Missing customers ranked by spend tell you who to create in Intacct first.
Which BigCommerce customers from the last 14 days have no Intacct customer?
Accounts receivable
Avoid duplicate customer records
Near matches are shown with their Intacct ID, so you link to the existing record instead of creating another.
Show BigCommerce customers this month that might be duplicates of existing Intacct customers.
Finance managers
Size the setup backlog
The count and spend of missing customers show how much store revenue has no ERP account yet.
How much have new BigCommerce customers without an Intacct record spent in the last 60 days?
How it works
What PopdockAI does when you ask
You say how far back to look and your AI assistant checks new BigCommerce customers against Intacct. Common names with no company are marked unverified, not missing.
01
Ask
You say how many days back to look.
02
Read
It reads new BigCommerce customers, capped at 50.
03
Check
It searches Intacct for each company or name and sets near matches aside as possible duplicates.
04
Report
It adds order count and spend for the missing ones and lists them, ranked by spend.
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-customer
sage-intacct-get-customer
bigcommerce-get-order
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
Store customers with no Intacct record, ranked by spend
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)
