/
/
See where WooCommerce and Constant Contact customer details disagree
For marketers and support teams who want customer details compared between WooCommerce and Constant Contact, without formatting noise, by their AI assistant.
On this page
Connector
Connect WooCommerce, pick your AI tool and paste the prompt.
The problem
Customer details that disagree between store and email
The same customer can have one phone number and company in WooCommerce and another in Constant Contact. Spotting differences means comparing records field by field, and formatting noise hides the real conflicts.
Without PopdockAI
- Export customers and contacts
- Compare names, phones and companies field by field
- Ignore formatting differences by eye
- Miss the real conflicts in the noise
With PopdockAI
- Customers and contacts are matched by email only
- Case, phone punctuation and state names are normalized
- Blanks are reported as gaps, not conflicts
- Conflicts and gaps are tabled, 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.
**Objective:** Report where a WooCommerce customer and the matching Constant Contact contact disagree on name, phone, company or state, for the customer `{email}` if given, otherwise for customers created in the last `{lookback-days}` days (default 90).
**Step 1: Read the WooCommerce side**
If `{email}` is given, call `woocommerce-get-customer` with `email` = `{email}`. Otherwise call it with `created-date.from` = today minus the lookback, `max-records` 200. Keep `email`, `first-name`, `last-name`, `billing-phone`, `billing-company`, `billing-state`, `billing-country`.
**Step 2: Read the Constant Contact side**
For each customer, call `constant-contact-get-contact` with `email-address` = their email. Keep `first-name`, `last-name`, `phone-number`, `company-name`, `state`, `country`. A customer with no contact goes in a "not in Constant Contact" list and is not compared.
**Step 3: Compare**
Compare first name, last name, phone, company and state. Before comparing, normalise: trim and ignore case for text; strip spaces, dashes, dots and brackets from phone numbers and ignore a leading country code; treat a two-letter state code and the full state name as the same (for example `CA` and `California`). Treat a value that is blank on one side and present on the other as "missing in" that system, not as a conflict.
**Step 4: Report**
* Counts: compared, matching, with conflicts, with gaps only, not in Constant Contact
* A table of conflicts: email, field, WooCommerce value, Constant Contact value
* A table of gaps: email, field, which system is missing it
* Do not decide which side is right. Note that WooCommerce holds billing details the shopper typed at checkout, which are usually more recent.
**Rules & Guidelines:**
* Tools whose names start with woocommerce- are on the woocommerce MCP server; tools whose names start with constant-contact- are on the constant-contact MCP server. If a tool from either server is missing, stop and tell the user that both servers must be connected.
* Match records by email address only: WooCommerce `email` / `customer-email` against Constant Contact `email-address`. Trim and lower-case both sides before comparing. Never match on name alone.
* This prompt is read-only. Do NOT call any write tool on either server. On Constant Contact that is `constant-contact-add-contact`, `constant-contact-update-contact`, `constant-contact-add-contact-note`, `constant-contact-add-contact-list`, `constant-contact-update-contact-list`, `constant-contact-add-contact-tag`, `constant-contact-update-contact-tag`, `constant-contact-add-campaign`, `constant-contact-update-campaign`, `constant-contact-resend-campaign-to-non-openers`. On WooCommerce that is `woocommerce-add-coupon`, `woocommerce-update-coupon`, `woocommerce-add-order`, `woocommerce-update-order`, `woocommerce-add-order-note`, `woocommerce-add-refund`, `woocommerce-add-customer`, `woocommerce-update-customer`, `woocommerce-add-product`, `woocommerce-update-product`, `woocommerce-update-product-variation`, `woocommerce-send-order-details`.
* To fix a contact afterwards, the user can run the `update-contact-details` prompt on the constant-contact server or `update-customer-details` on the woocommerce server.
**Validation:**
* If `{email}` is given and is not a WooCommerce customer, say so and stop.
* If nothing differs, say so in one line.Who it's for
One answer, three teams that use it
Email marketers
Keep contact details accurate
See where names, phones and companies disagree, so personalised emails use the right details.
Compare WooCommerce customers from the last 30 days with Constant Contact and show conflicts.
CRM administrators
Plan a data clean up
Tables of conflicts and gaps show exactly what to fix and where.
Where do WooCommerce and Constant Contact disagree on phone or company for customers this quarter?
Customer service agents
Check one customer's details
Compare a single shopper across both systems before updating their record.
Compare jordan@fabrikam.com in WooCommerce and Constant Contact.
How it works
What PopdockAI does when you ask
You give one email or a lookback period, and your AI assistant compares the records field by field. It only reports and never decides which side is right.
01
Ask
You give one email, or a lookback period.
02
Read
It reads WooCommerce customers and their Constant Contact contacts by email.
03
Compare
It normalizes case, phone punctuation and state names before comparing.
04
Report
You get conflicts and gaps, with nothing changed.
What PopdockAI provides
The tools behind the answer
Ready made tools for WooCommerce and one secure connection to your AI tool. No code, no exports.
woocommerce-get-customer
constant-contact-get-contact
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
Real conflicts without the formatting noise
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)
