/
/
Add missing materials order suppliers to Rillet, verified
For finance teams who ask their AI assistant to find Procore materials purchase order vendors that Rillet lacks and create them after review.
On this page
Connector
Connect Procore, pick your AI tool and paste the prompt.
The problem
New suppliers block the bill until someone keys them in
A supplier on a materials order has to exist in Rillet before a bill can be booked, so someone retypes it. A near-duplicate spelling then creates a second vendor, and bills start going to the wrong record.
Without PopdockAI
- List the vendors on the project's materials orders
- Search Rillet for each name and spelling
- Create the missing vendors by hand
- Merge duplicates created by different spellings
With PopdockAI
- Order vendors are compared with Rillet, ignoring case and endings
- Close matches are shown as possible duplicates and never created
- Nothing is written until you confirm the list
- Rillet is read again to confirm each new vendor appears
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For project `{project-name}`, find vendors on its Procore materials purchase orders that have no vendor in Rillet, show them, and after the user confirms create each one in Rillet. If `{vendor-name}` is given (optional), only consider that vendor.
**Step 1: Read the PO vendors (Procore resource management)**
Call `procore-get-materials-mgmt-purchase-orders-vendors` with `project-name.contains` set to `{project-name}`. Keep the distinct `vendor` values, narrowed to `{vendor-name}` if given. If more than one project name comes back, list them and stop. If nothing comes back, say so and stop.
**Step 2: Find the gaps (Rillet)**
Call `rillet-get-vendors` once. Match each Procore vendor to a Rillet vendor `name` (ignore case, punctuation and endings such as Inc and LLC). A vendor with a close but not exact match is not a gap: list it as a possible duplicate with both spellings and exclude it from creation.
**Step 3: Confirm before writing**
Show a table of the vendors that would be created (name exactly as it appears in Procore) and the possible duplicates left out. Ask the user to confirm. Do not call any write tool until they say yes, and if they name a subset, create only that subset.
**Step 4: Create and verify (Rillet)**
For each confirmed vendor call `rillet-add-vendor` with `name` set to the Procore vendor name and no other fields; the Procore purchase order list carries only a vendor name. If the call is rejected for a missing required field, report the vendor and the error, do not invent values, and continue with the next vendor. Afterwards call `rillet-get-vendors` again and confirm each new vendor appears.
**Step 5: Report**
Vendors created (with the new Rillet vendor id), vendors that failed with the reason, possible duplicates left out, and vendors already present. Note that address, email, payment terms and tax details must be completed in Rillet.
**Rules & Guidelines:**
* `procore-get-materials-mgmt-purchase-orders-vendors` is on the Procore resource management server. `rillet-get-vendors` and `rillet-add-vendor` are on the Rillet server.
* `rillet-add-vendor` is the only tool that may write, and only after confirmation. Do not call `rillet-update-vendor`, any other Rillet add, update or apply tool, or any Procore create, update or delete tool.
* Never create a vendor that is already in Rillet or is a possible duplicate.
**Validation:**
* If nothing is missing, say so and write nothing.
* If the user does not confirm, write nothing and say so.
* If `rillet-get-vendors` returns nothing, ask the user to confirm that the Rillet vendor list really is empty before creating anything.Who it's for
One answer, three teams that use it
Accounts payable
Get suppliers ready for bills
Create the missing vendors for a project's materials orders in one pass, so bills are not rejected for an unknown supplier.
Find vendors on Fabrikam Depot materials purchase orders that are missing from Rillet and add them.
Procurement coordinators
Check before first order bills arrive
See which order suppliers are new to Rillet and which look like existing vendors under another spelling.
List the Contoso Warehouse materials order vendors that have no Rillet vendor, but do not create any yet.
Finance systems owners
Keep the vendor list clean
Possible duplicates are left out and shown with both spellings, so the ledger does not collect near-copies.
Add only Northwind Fasteners from the Northwind Plaza materials orders to Rillet if it is missing.
How it works
What PopdockAI does when you ask
You name the project and your AI assistant finds the gaps. Vendors are created only after you confirm, with the name Procore holds and no invented fields.
Ask
You name the project and optionally a single vendor.
Check
It reads the order vendors, compares them with Rillet and sets close matches aside.
Confirm
You see what would be created and the possible duplicates left out, and say yes.
Create
It creates each vendor by name, re-reads Rillet to verify and reports what is left to fill in.
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-materials-mgmt-purchase-orders-vendors
rillet-get-vendors
rillet-add-vendor
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
Suppliers ready to bill, without duplicate vendors
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)
