Problem/Motivation

Currently, the database table for the Mailchimp Subscription field doesn't get updated consistently (at all?).

We should do an audit of all actions a user might take that would change the __subscribe and __interest_groups values, and make sure we take that opportunity to update the database. Right now most of the actions use the Mailchimp API only.

Steps to reproduce

Try adding, editing, or updating user's subscription field while watching the database. The value for the __subscribe column is always 0.

Proposed resolution

Audit current actions in mailchimp lists and make sure we update the database at the same time as we update Mailchimp's services via API

Remaining tasks

Make sure the database is updated when:

  1. Update your user profile's subscription checkbox
  2. Add a new user from the admin
  3. Create new account, from Log In
  4. Actions taken from mailchimp, like unsubscribing

Comments

spncr created an issue. See original summary.

avpaderno’s picture

avpaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
commented
Status: Needs work » Active
aaronbauman’s picture

aaronbauman
he/him
commented
Version: 2.x-dev » 3.x-dev

This, or maybe an issue related to this, persists into 3.x and has bitten me recently on a headless site.

Drupal's API *only* serves up the possibly incorrect database value, so the frontend site does not reflect the same value as Drupal or Mailchimp.