Home Forums Newsletter Plugin Support Autoresponder (set all current subscribers to completed)

  • This topic has 2 replies, 2 voices, and was last updated 3 years ago by misc.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #276511
    misc
    Participant

    We’ve imported a large list from a different mailing system. We want to set up an autoresponder when people subscribe to send them the “top tips” email, but in testing when there are already people in the list and you enable the autoresponder, all the current list members get blasted immediately. How can we set all the current ones as completed so that only new signups trigger the autoresponder?

    Thanks in advance.

    #276553
    Stefano
    Keymaster

    Hi, you should use a different list to be assigned to new subscribers.

    #278373
    misc
    Participant

    Not ideal, to have multiple lists.

    Instead, here’s what we did:
    1) set the autoresponder to have a delay of, say, 2 hours.
    2) Enable it, which dropped all the existing peeps into the funnel.
    3) In phpMyAdmin, ran an UPDATE query to set all rows in the table wp_newsletter_autoresponder_steps to step=1 and status=1. (Status of 1 is Completed as far as the autoresponder is concerned; Step 1 was technically unnecessary, but it felt complete, since these people in fact all did get the email originally.)
    4) After verifying that no current user was in the autoresponder funnel any more, set the autoresponder back to no delay/immediate delivery.

    Seems to have worked.

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.