Connectors

/

Mailchimp

/

Mailchimp and Shopify customer profile by email
Report
Cross-Connector

Answer a customer with their Shopify orders and Mailchimp history

For support teams who want a shopper's orders, shipments and email consent in one answer, by asking their AI assistant with an email.

Try PopdockAI free
Get a live demo
Mailchimp and Shopify customer profile by email
Pull up everything Shopify and Mailchimp know about priya@northwindtraders.com.
Priya Shah, a customer since 2023 with 9 orders totalling 1,420 USD. - Open order: 1 order not yet fulfilled, in transit - Mailchimp: unsubscribed from Newsletter, reason too frequent - Open cart: 85 USD with a checkout link - Consent: mismatch, Shopify says she accepts marketing Want the details of the open order?
Mailchimp
Sample figures. Your results come from your own account.
shopify-get-customer
shopify-get-order
shopify-get-fulfillment
mailchimp-get-list-member
mailchimp-get-campaign-email-activity
mailchimp-get-campaign-unsubscribe
mailchimp-get-cart

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Mailchimp

Mailchimp
Run it on your own Mailchimp data.

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

Try PopdockAI free

The problem

Orders in one system, email history in another

When a customer writes in, their buying history lives in Shopify and their email history in Mailchimp. Piecing together orders, shipments, subscriptions and unsubscribes takes several screens, and consent mismatches go unnoticed.

Without PopdockAI

  • Open the Shopify customer and recent orders
  • Check shipment status on unfulfilled orders
  • Search Mailchimp for status, activity and unsubscribes
  • Miss that consent differs between the two

With PopdockAI

  • The Shopify customer, orders and open shipments are read
  • Mailchimp status, activity, unsubscribes and open carts are added
  • A consent check flags any mismatch
  • Email matching only, 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.

Prompt
**Objective:** Build a single profile of the person with email `{email}`, combining what Shopify knows about them as a buyer with what Mailchimp knows about them as a subscriber, looking back `{activity-days}` days (default 90) for recent activity.

**Step 1: Find the buyer in Shopify**

Call `shopify-get-customer` with `email` = `{email}`. Note `customer-id`, `name`, `orders-count`, `total-spent`, `accepts-marketing`, `tags`, `state` and `created-at`. If more than one customer comes back, list them all and continue with each. If none comes back, record "not a Shopify customer" and continue to Step 3.

**Step 2: Recent orders in Shopify**

Call `shopify-get-order` with `customer-id` from Step 1 and `created-at.from` set to `{activity-days}` days before today. For each order note `order-number`, `created-at`, `total-price`, `financial-status` and `fulfillment-status`. For any order that is not fully fulfilled, call `shopify-get-fulfillment` with its `order-id` and note `status`, `shipment-status` and `tracking-company`.

**Step 3: Subscriber record in Mailchimp**

Call `mailchimp-get-list-member` with `email` = `{email}`. A person can be on several audiences; note `list-name`, `status`, `tags`, `rating`, `average-open-rate` and `average-click-rate` for each. Then call `mailchimp-get-campaign-email-activity` with `email-address` = `{email}` and `activity-date.from` set to the same start date as Step 2, and `mailchimp-get-campaign-unsubscribe` with `email` = `{email}`. Finally call `mailchimp-get-cart` with `customer-email` = `{email}` to find any open cart.

**Step 4: Report**

* **Buyer (Shopify):** name, customer since, orders count, total spent, tags, open orders with fulfillment state.
* **Subscriber (Mailchimp):** each audience with status and rating, recent opens and clicks by campaign, any unsubscribes with reason.
* **Open cart (Mailchimp):** cart total and `checkout-url`, if any.
* **Consent check:** say whether Shopify `accepts-marketing` agrees with the Mailchimp status. Shopify true with Mailchimp unsubscribed or cleaned, or Shopify false with Mailchimp subscribed, is a mismatch; flag it.

**Rules & Guidelines:**

* Tools named `shopify-*` are on the shopify server; tools named `mailchimp-*` are on the mailchimp server.
* Match the two systems on email only, compared case-insensitively with surrounding spaces trimmed. Do not match on name or customer id; the two systems number customers differently.
* This prompt is read-only. Do NOT call `mailchimp-update-list-member`, `mailchimp-add-list-member`, `mailchimp-update-customer`, `shopify-update-customer` or any other add or update tool on either server.

**Validation:**

* If neither system knows the email, say so plainly and stop.
* If only one system knows it, report that side and state that the person is absent from the other.

Who it's for

One answer, three teams that use it

Support agents

Answer with orders and shipments in view

See recent orders, unfulfilled shipments and email history before you reply to a customer.

Pull up Shopify orders and Mailchimp history for dana@contoso.com, including anything not shipped yet.

Email marketers

Catch consent mismatches early

Spot customers who accept marketing in Shopify but unsubscribed in Mailchimp before it becomes a complaint.

Does sam.patel@fabrikam.com have the same marketing consent in Shopify and Mailchimp?

Store managers

See open carts beside past orders

Any open cart with its checkout link sits next to order history, useful when a customer asks for help finishing a purchase.

Show me tom.reyes@northwindtraders.com in Shopify and Mailchimp, and whether he has an open cart.

How it works

What PopdockAI does when you ask

You give an email address, and your AI assistant builds the customer's story from Shopify and Mailchimp. It only reads.

01

Ask

You give an email address.

Your AI tool

02

Read

It reads the Shopify customer, recent orders and unfulfilled shipments.

shopify-get-customer
shopify-get-order
shopify-get-fulfillment

03

Add

It reads Mailchimp audiences, opens, clicks, unsubscribes and any open cart.

mailchimp-get-list-member
mailchimp-get-campaign-email-activity
mailchimp-get-campaign-unsubscribe
mailchimp-get-cart

04

Report

You get the profile with a consent check between the two systems.

Your AI tool

What PopdockAI provides

The tools behind the answer

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

get-data

shopify-get-customer

Returns Shopify customers with their account state, total spent and default address. Filter by name, email, tags, customer id, city, province, created date and total spent.
get-data

shopify-get-order

Returns Shopify orders with their financial status, fulfillment status and total. Filter by order number or name, customer, email, financial status, fulfillment status, created date and total price.
get-data

shopify-get-fulfillment

Returns Shopify fulfillments with their status, shipment status and tracking number. Filter by order, customer, tracking number, status and created date.
get-data

mailchimp-get-list-member

Returns the members (subscribers) of Mailchimp audiences, with subscription status, tags and engagement rating. Filter by email address or status to look someone up.
get-data

mailchimp-get-campaign-email-activity

Returns each member's open, click and bounce events for Mailchimp campaigns, with timestamps and the URLs they clicked.
get-data

mailchimp-get-campaign-unsubscribe

Returns the members who unsubscribed from each Mailchimp campaign, with the date and the reason they gave.
get-data

mailchimp-get-cart

Returns open (abandoned) carts from the e-commerce stores connected to Mailchimp, with the customer, cart total and checkout link.
Read only.Nothing in Mailchimp 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

The whole customer story in one answer

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