changing when subscription is charged

Discussion in 'Payments processing' started by seasons1, Aug 29, 2008.

  1. seasons1

    seasons1 aMember Pro Customer

    Joined:
    Apr 25, 2008
    Messages:
    21
    I would like to have all our subscriptions charged on the 1st of the month. I know where to do this, but last month when we started our membership, I didn't choose a start date and left the default. I have a product called monthly subscription. It says that changing the start date will not effect users. I want to change it so everyone is charged on the first of the month.
    :confused:
    Our members are going to want their product on the first, no matter what day they signed up. So when I put in the new product for Sept., will I have to mass subscribe everyone, I'm a little confused.

    Thanks for any help! Theresa
  2. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    What payment system are you using? If using one like paypal- then you wont be able to change the start date- thats in the paypal system already.

    David
  3. seasons1

    seasons1 aMember Pro Customer

    Joined:
    Apr 25, 2008
    Messages:
    21
    Hi David, no we use authorize... ? I'm wondering if I'm thinking this through correctly.
    This is the first month that we started... All members are going to want access to the product on the first of the month, it's a quilt block membership.

    The monthly membership is a product in itself, then I can make folders for each blcok that members who were active in the monthly membership get access to. If I change the monthly membership product now to charge on the 1st, the members who signed up before would still be charged on the day they first signed up? There is no way to change them to now be charged on the first?
    So basically I would be having some members have access to the product before they were charged? Is this the only way to do this?

    I'm sorry if this is confusing! I'm trying to think of the best way to set up current members who signed up late having the September block available, but making sure we get their charge on the first instead of at the end of the month. It's already set to recur..

    Thanks, theresa
  4. seasons1

    seasons1 aMember Pro Customer

    Joined:
    Apr 25, 2008
    Messages:
    21
    changing charge date

    Does anyone know if I change the recurring billing date to the first of every month on an existing subscription, if it will charge the existing customers?

    So if I went in today and put in a fixed date of 09/01/2008, it would automatically charge our existing customers tomorrow? If so, I would just change the date on the subscription monthly to charge the next month? Not everyone signed up on the first but they need their product on the first.

    Thanks for any advice on how to do this, Theresa
  5. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    I havent tried that.

    If you try it, please let us know what happens!

    David
  6. jimjwright

    jimjwright New Member

    Joined:
    Sep 12, 2007
    Messages:
    162
    Hello,

    Rebilling of existing customers is based on there existing payment records and when the payment for the subscription is set to expire. I would think changing the product record to set the fixed subscription start date would only effect new customers. The reason being your only changing the product record in the database. This does not go and adjust the payment records of all existing customers.

    Again rebilling decisions are based soley on when an existing payment record (in particular the expire_date of the payment record) expires. Modifying your product will only affect the product record which will be used to create payment records for new subscriptions only.

    Jimmy
  7. seasons1

    seasons1 aMember Pro Customer

    Joined:
    Apr 25, 2008
    Messages:
    21
    thank you..!

    Ok, I see, I thought that was the case, but didn't think to go in and see if I could change the subscription start date on the member, I was only looking at the product. I'm assuming I can do that for each member, which would be a lot of work, but would get it on the right track. I appreciate your answer! thanks, Theresa
  8. jbround39

    jbround39 aMember Pro Customer

    Joined:
    Mar 20, 2008
    Messages:
    61
    You could do this with a single sql command since you are using authorize.net.
    With authorize.net, it renews their payment on the expiration date, so what you could do if you want to set all existing non-cancelled members to renew on september 1 is:

    UPDATE amember_payments SET expire_date='2008-09-01' WHERE product_id=(amember product number you want to change) AND completed=1 and expire_date>now()

    If all you use is authorize.net (and not paypal) that will set all of your current members to expire on September 1, and presuming you have autorenew set properly, amember will process renewals at midnight server time on September 1.

    You probably should back up your database before doing this because it is irreversible.

Share This Page