Migration from Ubercart

5 replies [Last post]
ukcolumn
Offline
Joined: 07/05/2011
Status: 
Answered

Hi there,

Can't see this having been asked before, but apologies if it has.

We sell subscriptions to our newspaper currently using Ubercart. We want to change that process, and how we manage the subscriptions, and Membership Suite seems to do the job for us in testing at least.

The issue I face is how to migrate active subscriptions. I could start with a fresh user database and import users from the current production database, but I didn't see a way to set a membership expiry date. Is that correct?

Any suggestions, warnings or gotcha's much appreciated.

Cheers,

Mike.

Leighton Whiting
Offline
Joined: 06/02/2009
Mike, One major gotcha is

Mike,

One major gotcha is recurring payments. Are any of your current subscriptions set up using Recurring Payments (maybe through PayPal, for example)? If so, then it is a lot more complex, since PayPal doesn't let you change the notification url in the middle of a 'subscription'.

If there are no active recurring payments, and you simply need to set an expiration date for the current subscriptions, this is possible using User Import (for which Membership Suite provides integration). So you would need to export the user info and their expiration dates to a CSV.

To get a more tailored solution, you could simply write a small module that will import the current subscriptions into ms_membership database. That would probably be the best way, if you don't mind doing some coding.

Sincerely,
Leighton Whiting

ukcolumn
Offline
Joined: 07/05/2011
Thanks, Leighton, None of the

Thanks, Leighton,

None of the present subscriptions are using recurring payments at present.

Don't mind doing a little coding, and this may be what I do. Time is the main issue, so I'll test the User Import option first, I think.

To clarify - with User Import you're saying that I can build a CSV file with fields from my current production database, including an expiration date column, and import that into my fresh test database. The User Import/Membership Suite integration will be happy with that, and renewal emails will be sent for people to renew their memberships at the right time?

Cheers,

Mike.

Leighton Whiting
Offline
Joined: 06/02/2009
Mike, That's right, but this

Mike,

That's right, but this will also create new user accounts in the process, not sure if you are moving to a new site database or are on the old site with the existing customers still.

Sincerely,
Leighton Whiting

ukcolumn
Offline
Joined: 07/05/2011
OK, thanks. Just looking

OK, thanks.

Just looking through your code. Am I right in saying the only functions I need to worry about/replicate if I go down the module route, are ms_membership_insert_membership and ms_membership_change_roles?

If that's correct, can I assume that for ms_membership_insert_membership, oid can remain 0, since there is no order associated with the membership?

Cheers,

Mike.

Leighton Whiting
Offline
Joined: 06/02/2009
Yes, you can just leave the

Yes, you can just leave the order id blank, since it doesn't have one associated with it.

And you are correct about the functions.

Sincerely,
Leighton Whiting

Twitter Feed