Transfering Members to a New Product

Discussion in 'Setting-up protection' started by dhales, Sep 2, 2010.

  1. dhales

    dhales New Member

    Joined:
    Feb 22, 2009
    Messages:
    11
    Greetings,

    I already have my amember installation up and running with several products setup. I am looking to consolidate several products I setup at an earlier time into one new product which I have just created.

    Is there a way to bulk import users into a new product and remove them from their existing product subscription?

    Thanks in advance,
    Derek
    dhales, Sep 2, 2010
    #1
  2. skippybosco

    skippybosco CGI-Central Partner Staff Member

    Joined:
    Aug 22, 2006
    Messages:
    2,526
    Logged on as admin -> Manage Product -> At the very bottom of the page there is a link to "Mass Subscribe Members"
    skippybosco, Sep 2, 2010
    #2
  3. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    Skippys got you on the mass subscribe- to mass cancel, you'll need to do that in phpmyadmin.

    David
    davidm1, Sep 2, 2010
    #3
  4. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Derek,
    Also you can do this with simple MySQL query:
    update amember_payments set product_id = 3 where product_id in (1,2)
    Where 3 is new product and 1,2 are old products.
    Please make database backup before this.
    alexander, Sep 3, 2010
    #4
  5. dhales

    dhales New Member

    Joined:
    Feb 22, 2009
    Messages:
    11
    Wow, thank you for all the responses. They are much appreciated. This should do exactly what I'm in need of (especially the mysql query).

    Much appreciated, everyone.
    dhales, Sep 3, 2010
    #5

Share This Page