✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

SleekView for EDD Mailchimp: customer sync & list tables

Read directly from edd_customers and the EDD Mailchimp meta keys recording list membership and last sync. Build subscriber views, opt-in audits, and post-purchase segments without exporting to a separate dashboard.

♾️ Lifetime License available

SleekView table view for EDD Mailchimp

Mailchimp sync state isn't visible in the EDD admin

EDD Mailchimp adds customers to Mailchimp lists when they purchase, optionally tagging them with product purchases and storing the sync state in edd_customermeta or edd_ordermeta under keys like _edd_mailchimp_subscribed and _edd_mailchimp_list_id. The default EDD admin doesn't surface any of this on the Customers or Orders screen, so opt-in status and list membership stay invisible at the row level.

SleekView reads edd_customers together with edd_customermeta and joins to edd_orders so opt-in status, list id, last sync timestamp, and lifetime value become first-class columns. Marketing builds a saved view of subscribers acquired in the last quarter, support sees opt-in state inline when responding to GDPR requests, and ops triages customers whose sync failed before the next campaign sends.

Inline edits to subscription state route through EDD's CRUD layer where supported so EDD Mailchimp's subscribe and unsubscribe hooks fire. Direct meta writes are guarded by conflict detection so a stale admin row never overwrites a Mailchimp webhook update.

Workflow

How SleekView reads EDD Mailchimp data

1

Pick the base table

edd_customers for subscriber-rooted views, edd_orders for purchase-rooted views joined to opt-in state. SleekView detects EDD 3.0 automatically.
2

Compose Mailchimp columns

Add _edd_mailchimp_subscribed, list id, last sync timestamp, and any tag-related keys from the column picker. Only keys present in your data are listed.
3

Save segments and audit views

Name them ("Subscribed Q2 acquisitions", "Sync failed last 7d", "Unsubscribes by product") and gate by capability so marketing, support, and admins each see their own.
4

Edit inline or export

Update opt-in state through EDD Mailchimp's hooks, bulk-flag customers for cleanup, or export segments to CSV for ad-hoc campaign uploads.

Sample columns

A typical EDD Mailchimp subscriber view

Joins edd_customers with edd_customermeta Mailchimp keys and aggregated order totals from edd_orders.
Source: wp_edd_customers + wp_edd_customermeta + wp_edd_orders
Customer Opt-in Mailchimp list Orders LTV Last order
alex@studio.co Subscribed Main list 4 $192.00 Apr 24
ria@design.io Pending Main list 2 $96.00 Apr 24
tom@hello.dev Subscribed Beta testers 6 $248.00 Apr 23
mia@brew.coop Unsubscribed (none) 1 $48.00 Apr 23

Comparison

Default EDD Mailchimp admin vs SleekView

Default EDD Mailchimp admin

  • Opt-in status lives in edd_customermeta and isn't shown in the Customers list
  • Mailchimp list id and tags aren't joined into the EDD customer view
  • Failed syncs sit in error logs that nobody reads daily
  • No saved view for customers acquired in last quarter, subscribed, with LTV over X
  • Unsubscribes aren't easily auditable against purchase history

SleekView

  • Surface _edd_mailchimp_subscribed and list id as columns
  • Customer-rooted view with opt-in, list, LTV, order count
  • Saved view: subscribed customers acquired in last quarter
  • Audit-friendly view of unsubscribes joined to last order date
  • Export segments to CSV for upload to Mailchimp ad-hoc

Features

What SleekView gives you for EDD Mailchimp

Subscribers and customers in one view

Build a view on edd_customers with Mailchimp opt-in, list id, and lifetime spend as columns. Marketing sees subscriber and customer context together without switching to Mailchimp.

Segment by purchase plus opt-in

Combine product purchased (via edd_order_items), opt-in state, and last-order date to build segments inside WP. Saved views are reusable per campaign.

Sync failures triage

Saved view of customers whose last sync failed, with last error visible inline. Fix data, requeue, send the campaign with the actual subscriber list intact.

Audience

Who uses SleekView for EDD Mailchimp

Marketing

Build segments by product purchased, opt-in state, and LTV. Export to CSV for ad-hoc campaigns, or use saved views as the briefing for the next email.

Customer support

See opt-in status inline when responding to a GDPR request or a complaint about emails. Unsubscribe a customer through the integration's hook without leaving WP admin.

Store admins

Daily sync-failure triage view: which customers didn't sync, what the last error was, and how to fix it. Less guessing about why a campaign sent to fewer subscribers than expected.

The bigger picture

Why post-purchase segmentation needs row-level views

EDD Mailchimp is one of the most common ways a digital store keeps its marketing list in sync with its customer list. The integration works cleanly on the happy path: a customer buys, gets added to a Mailchimp list, optionally gets tagged with the product. Where it falls down is making the result usable inside WordPress.

The default EDD admin treats opt-in state as invisible meta. The default Mailchimp UI knows nothing about LTV or which EDD product a subscriber bought first. Operators end up exporting CSVs both directions to build a segment that's really just "customers who bought X, opted in to list Y, ordered more than once".

SleekView turns that into a saved view inside WordPress: subscribers and customers joined, opt-in state visible, product purchases joined through edd_order_items. Marketing builds the segment once and rebuilds it monthly with two clicks. Same database, same Mailchimp integration, dramatically less CSV juggling.

Questions

Common questions about SleekView for EDD Mailchimp

Yes. SleekView reads edd_customers and edd_customermeta on EDD 3.0 and later. On older EDD versions customer data lived in a different schema and would need a different mapping, but most stores have migrated.

 

Yes. Status changes that route through EDD Mailchimp's hooks trigger the Mailchimp API call as configured. The actual subscribe or unsubscribe goes through the plugin's existing chain, so behaviour matches manual admin actions.

 

EDD Mailchimp tags customers with products purchased if you've configured tagging. If those tags are stored in edd_customermeta, SleekView's column picker will list them. If they're stored only in Mailchimp, SleekView can't show them without a pull-back sync.

 

Yes, if EDD Mailchimp records the list id in edd_customermeta. Multiple lists per customer surface as a comma-separated cell or as a child related view, depending on how you configure the column.

 

Campaign send data lives in Mailchimp, not in WordPress, so SleekView doesn't render it directly. What it can show is subscriber state and the data EDD already stores about purchases, which is enough to segment for the next campaign.

 

Customer queries hit indexed columns on edd_customers. Aggregate columns (LTV, order count) use subqueries against edd_orders that EDD already indexes for. Keep aggregates off triage views and on detail views to keep query plans fast on large lists.

 

No. It's a view into the WordPress side of the EDD plus Mailchimp data. Mailchimp remains the source of truth for campaign sends, automations, and engagement metrics. SleekView's role is making the EDD side of the data trivial to segment and audit.

 

Yes. A customer-rooted view with email, opt-in state, list membership, and order history in one row gives you the WordPress side of a Subject Access Request in a few seconds. You still need to pull engagement data from Mailchimp separately, but the bulk of the WP-side answer is one filtered view away.

 

Pricing

More than 1000+
happy customers

Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

EUR

once

  • Unlimited websites
  • Lifetime updates
  • Lifetime support

...or get the Bundle Deal
and save €250 🎁

The Bundle (unlimited sites)

Pay once, own it forever

Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.

What’s included

  • SleekAI

  • SleekByte

  • SleekMotion

  • SleekPixel

  • SleekRank

  • SleekView