/
/
Find offices that exist in Procore but not NetSuite, and the reverse
For operations and finance admins who want Procore offices reconciled with NetSuite locations by asking their AI assistant.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
Office and location lists are compared by hand
The Procore office list and the NetSuite locations are compared line by line, and names and addresses are typed differently in each. Offices or locations get missed or wrongly paired.
Without PopdockAI
- List the offices in Procore
- List the locations in NetSuite
- Match names and addresses by eye
- Miss the site that exists in only one system
With PopdockAI
- Both lists are read for you
- Matches use name first, then city and phone
- Doubtful pairs are flagged and never merged
- Sites on one side only are listed with counts
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Reconcile the Procore offices (optionally only those in {state-code}) against the NetSuite locations, so finance and admins can see which sites exist in one system but not the other.
**Step 1: Read the offices (procore-company-admin server)**
Call `procore-get-offices`. If {state-code} is not empty, pass it as `state-code`. Pass `max-records` of 200. Keep name, city, state-code, address, zip and phone for each office.
**Step 2: Read the locations (netsuite server)**
Call `netsuite-get-location` with `max-records` of 200. Keep name, full-name, main-address-state, return-address-city and return-address-phone.
**Step 3: Match across**
For each office, look for a location whose name or full-name equals the office name, ignoring case, punctuation and words such as Office, Branch and HQ. If there is no name match, fall back to the same city plus the same phone digits. Classify each office as Matched, Possible match (say why) or Missing in NetSuite. List every location that no office matched as Missing in Procore. If {state-code} is set, only list locations whose state equals it.
**Step 4: Report**
Give a table with columns Office, City, State, NetSuite location, Status. Then a short list of unmatched locations, then counts of Matched, Possible and Missing on each side.
**Rules & Guidelines:**
* `procore-get-offices` is on the procore-company-admin server; `netsuite-get-location` is on the netsuite server.
* This is read-only. Do not call any `procore-create-*` or `procore-update-*` tool, and do not call any of the `netsuite-add-*` and `netsuite-update-*` tools.
* Never merge two offices into one location yourself. Flag the doubt instead.
**Validation:**
* If `procore-get-offices` returns nothing, say so and stop.
* If `netsuite-get-location` returns nothing, report every office as Missing in NetSuite and say the NetSuite side was empty.
* Treat a name match with a different state as a Possible match, not a Matched.Who it's for
One answer, three teams that use it
Operations managers
Know every site is in both systems
See which offices have no NetSuite location so each site can be set up in both.
Which Procore offices have no matching NetSuite location?
Finance administrators
Keep locations clean for reporting
Find NetSuite locations with no Procore office before they distort reports.
List NetSuite locations that no Procore office matches, for Texas only.
IT and systems admins
Check master data after a merger
Compare the office and location lists in one pass and review the doubtful pairs.
Reconcile Procore offices with NetSuite locations and show me the possible matches with reasons.
How it works
What PopdockAI does when you ask
You can limit the check by state and your AI assistant reads and compares both lists. It only reads, and it never merges two offices into one location.
Ask
You optionally give a state code to limit the check.
Read
It reads the Procore offices and the NetSuite locations.
Match
It matches by name, then by city and phone, and marks each office matched, possible or missing.
Report
You get a table of offices, the unmatched locations, and counts for each side.
What PopdockAI provides
The tools behind the answer
Ready made tools for Procore and one secure connection to your AI tool. No code, no exports.
procore-get-offices
netsuite-get-location
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
One list of the sites that only one system knows
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)
