/
/
See a shopper's orders and email relationship in one view
For support teams who want Shopify orders and Constant Contact subscription status for a shopper, by asking their AI assistant.
On this page
Connector
Connect Constant Contact, pick your AI tool and paste the prompt.
The problem
Shopify and Constant Contact disagree on consent
When a shopper writes in you want their Shopify orders next to their Constant Contact status and recent email activity. Checking both, and spotting that one system says they accept marketing while the other says they unsubscribed, takes several screens.
Without PopdockAI
- Look up the shopper and orders in Shopify
- Search Constant Contact for lists and activity
- Compare consent settings by eye
- Miss the mismatch until a complaint arrives
With PopdockAI
- Orders, spend and marketing consent come from Shopify
- Lists, tags, opens, clicks and bounces come from Constant Contact
- Consent, name and phone mismatches are called out
- Email is the only join, and nothing changes
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a single profile for the shopper with email address `{email}`, combining their Shopify purchase history with their Constant Contact subscription and email engagement over the last `{lookback-days}` days (default 90).
**Step 1: Find the shopper in Shopify**
Call `shopify-get-customer` with `email` set to `{email}`. If nothing comes back, retry with `email.contains` set to `{email}` and keep only rows whose email equals it ignoring case. If more than one customer matches, list them (name, customer-id, created-at) and stop. If none matches, note "not a Shopify customer" and continue to Step 3.
**Step 2: Their Shopify orders**
Call `shopify-get-order` with `customer-id` from Step 1 and `created-at.from` set to `{lookback-days}` days before today. Capture order-number, created-at, total-price, financial-status and fulfillment-status. Take orders-count, total-spent, accepts-marketing and last-order-name from the Step 1 customer record.
**Step 3: Find the same person in Constant Contact**
Call `constant-contact-get-contact` with `email-address` set to `{email}` (same ignore-case retry with `email-address.contains` as Step 1). If no contact exists, report "not in Constant Contact" and skip to Step 5.
**Step 4: Their lists and engagement**
Using contact-id from Step 3, call `constant-contact-get-contact-list-member` for their list memberships and `constant-contact-get-contact-activity` with `created-date.from` set to `{lookback-days}` days before today. Count opens, clicks and bounces by activity-type and note the most recent campaign-activity-name.
**Step 5: Report**
* **Shopify:** customer-id, orders-count, total-spent, accepts-marketing, then a table of orders in the window (order-number, date, total, financial and fulfillment status).
* **Constant Contact:** contact-id, permission-to-send, tags, list names, then opens / clicks / bounces in the window and the last campaign they engaged with.
* **Mismatches:** call out accepts-marketing true in Shopify but unsubscribed in Constant Contact (or the reverse), and name or phone differences between the two records.
**Rules & Guidelines:**
* `shopify-get-customer` and `shopify-get-order` are on the shopify server. `constant-contact-get-contact`, `constant-contact-get-contact-list-member` and `constant-contact-get-contact-activity` are on the constant-contact server.
* Email address is the only join key. Never match on name alone.
* This prompt is read-only. Do NOT call `constant-contact-update-contact`, `constant-contact-add-contact`, `shopify-update-customer` or any other tool whose name starts with shopify-add-, shopify-update-, constant-contact-add-, constant-contact-update- or constant-contact-resend-.
**Validation:**
* If the shopper is in neither system, say so and stop.
* If a tool from one server is not available, report that the shopify or constant-contact MCP server is not connected rather than reporting the shopper as missing from it.Who it's for
One answer, three teams that use it
Customer support agents
Answer shoppers with full context
Recent orders with payment and fulfillment status sit next to their email history.
Sam.patel@fabrikam.com is asking about an order. Show his Shopify orders and Constant Contact status.
Email marketers
Catch consent conflicts early
See when Shopify and Constant Contact disagree on consent before it becomes a complaint.
Does Shopify say priya@contoso.com accepts marketing while Constant Contact says she unsubscribed?
Store owners
Know your best customers by email too
Total spent and engagement together show who to thank and who has gone quiet.
How much has dana@northwindtraders.com spent in Shopify, and does she open our emails?
How it works
What PopdockAI does when you ask
You give an email address and your AI assistant builds one shopper profile from Shopify and Constant Contact. It only reads.
01
Ask
You give an email address, and optionally a look-back period.
02
Shop
It reads the Shopify customer's orders, spend and marketing consent.
03
It reads the Constant Contact contact's lists, tags, opens, clicks and bounces.
04
Report
You get one profile with mismatches called out, and nothing changed.
What PopdockAI provides
The tools behind the answer
Ready made tools for Constant Contact and one secure connection to your AI tool. No code, no exports.
shopify-get-customer
shopify-get-order
constant-contact-get-contact
constant-contact-get-contact-list-member
constant-contact-get-contact-activity
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
Purchases and email relationship in one view
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)
