Connectors

/

DonorPerfect

/

Match a DonorPerfect donor to a NetSuite customer
Report
Cross-Connector

Match a donor to the right NetSuite customer

For teams who keep DonorPerfect and NetSuite in step and want one donor checked against its customer record by asking their AI assistant.

Try PopdockAI free
Get a live demo
Match a DonorPerfect donor to a NetSuite customer
Match DonorPerfect donor 10482 to a NetSuite customer and show me how closely the two records agree.
Strong match: donor 10482 is NetSuite customer Northwind Traders, matched on email. - Name: Match (Northwind Traders) - Email: Match (accounts@northwindtraders.com) - Phone: Differs (DonorPerfect 555-0142, NetSuite 555-0187) - Customer ID 2210, balance 1,350.00 Want me to check another donor?
DonorPerfect
Sample figures. Your results come from your own account.
donorperfect-get-donor
donorperfect-get-address
netsuite-get-customer

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

DonorPerfect

DonorPerfect
Run it on your own DonorPerfect data.

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

Try PopdockAI free

The problem

Matching on a name settles on the wrong record

Matching a donor to an accounting customer means opening both systems and comparing names, emails and phones by hand. When the only link is a name, it is easy to settle on the wrong NetSuite customer.

Without PopdockAI

  • Open the donor in DonorPerfect
  • Search NetSuite by name
  • Compare email and phone by eye
  • Pick a customer without knowing how sure you are

With PopdockAI

  • The donor is read with email, phone and address
  • NetSuite is searched by email, then name
  • Fields are compared side by side with a confidence rating
  • Several candidates are listed, never picked, nothing 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:** Match DonorPerfect donor `{donor-id}` to a NetSuite customer and report agreement on name, email and contact details.

**Step 1: Read the donor (DonorPerfect)**

Call `donorperfect-get-donor` with `donor-id` = `{donor-id}`. Then call `donorperfect-get-address` with the same `donor-id` to get email, phone and address. If the donor is not found, say so and stop.

**Step 2: Find the customer (NetSuite)**

Call `netsuite-get-customer` with `email` set to the donor's email. If nothing matches, call it again with `name` set to the organization name or "first-name last-name". If the match is by name only, mark it as a weak match.
If more than one customer matches, list them all and do not pick one.

**Step 3: Report**

Show a table with donor value, customer value and Match / Differs for: name, email, phone (`phone-number` on the customer), plus the customer `internal-id` and `balance`. State the match confidence: strong (email), weak (name only) or none.

**Rules & Guidelines:**

* `donorperfect-get-donor` and `donorperfect-get-address` are on the donorperfect server; `netsuite-get-customer` is on the netsuite server.
* Read-only. Do not call any `donorperfect-save-*` tool, `donorperfect-set-flag`, or any `netsuite-add-*` or `netsuite-update-*` tool. Never change either system.

**Validation:**

* If the donor has no email, say the email match was skipped and use name only.
* Compare emails case-insensitively and phones by digits only.
* If NetSuite returns nothing, report the donor as present in DonorPerfect and absent from NetSuite.

Who it's for

One answer, three teams that use it

Data analysts

Know how good a match is

Strong, weak or none, with every field compared.

Match DonorPerfect donor 22019 to NetSuite and tell me how confident the match is.

Finance operations

Find the right customer before billing

See the customer ID and balance once the match is confirmed.

Which NetSuite customer is DonorPerfect donor 15530, and what is their balance?

Donor database managers

Spot records that disagree

Field differences show what to tidy in either system.

Compare name, email and phone for donor 30871 with their NetSuite customer.

How it works

What PopdockAI does when you ask

You give a donor ID and your AI assistant finds the matching NetSuite customer and rates the match. It only reads.

01

Ask

You give a DonorPerfect donor ID.

Your AI tool

02

Read

It reads the donor with their email, phone and address.

donorperfect-get-donor
donorperfect-get-address

03

Match

It looks for the NetSuite customer by email, then by name, and lists every candidate if there are several.

netsuite-get-customer

04

Report

It compares each field, shows the customer ID and balance, and rates the match strong, weak or none.

Your AI tool

What PopdockAI provides

The tools behind the answer

Ready made tools for DonorPerfect and one secure connection to your AI tool. No code, no exports.

get-data

donorperfect-get-donor

Returns donor records from DonorPerfect: names, salutations, contact details, donor type and status, and the codes used to segment them. The starting point for almost any DonorPerfect question.
get-data

donorperfect-get-address

Returns the additional address records held against donors in DonorPerfect, including address type, seasonal date ranges and which address is currently in use.
get-data

netsuite-get-customer

Returns NetSuite customers read from the NetSuite connector, with the fields people use most. Read-only.
Read only.Nothing in DonorPerfect 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

Each donor tied to the right customer, or 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