How to export users with Subscription status

Hi @cpsecpuser I believe this is a Woocommerce feature and not a feature of our Plugin.

We store this information on the order. Verify that the customer has accepted marketing at checkout. This can be found in the Custom Fields section below the order details.

The mailchimp_woocommerce_is_subscribed meta field contains:

• 1 = Subscribed
• 0 = Not subscribed/Transactional
• Empty/null = Status not set

Here is how you can export –

Method 1: Using WooCommerce User Export Plugins

1. Install a user export plugin like “Export Users to CSV” or “WP All Export”
2. When configuring the export, include these fields:
   • User email
   • User ID
   • mailchimp_woocommerce_is_subscribed (meta field)
   • mailchimp_woocommerce_tags (if using tags)
   • User registration date
   • Last order date

Method 2: Custom Database Query

If you’re comfortable with database queries, you can run this SQL query in phpMyAdmin or similar:

SELECT 
    u.ID,
    u.user_email,
    u.user_registered,
    COALESCE(m1.meta_value, 'not_set') as mailchimp_subscribed,
    COALESCE(m2.meta_value, '') as mailchimp_tags
FROM wp_users u
LEFT JOIN wp_usermeta m1 ON u.ID = m1.user_id AND m1.meta_key = 'mailchimp_woocommerce_is_subscribed'
LEFT JOIN wp_usermeta m2 ON u.ID = m2.user_id AND m2.meta_key = 'mailchimp_woocommerce_tags'
ORDER BY u.user_email;

Method 4: Using WP-CLI (Advanced)

If you have WP-CLI access:

wp user list --fields=ID,user_email,user_registered --meta_key=mailchimp_woocommerce_is_subscribed --format=csv > users_mailchimp_status.csv

Let me know if this helps!

You are not alone with this request. We are looking to make updates and include this in our wiki, thanks so much!

If you’re happy with this integration, please consider leaving a 5-star review. Your feedback helps other WooCommerce customers find this integration and helps support future development.