Researching options for membership system

I'm going to be helping a non-profit youth organisation to modernise their IT systems, which includes moving their current 50,000-entry membership database (names/addresses/emails) from an old Access database into something that will simplify administration and enable concurrent use, etc, simplify mail merges and e-mail blasts etc. There are 150 staff, but whilst most of these will not need access to the member databases, I think we're still looking at around 25 staff who will, including the 4 IT staff.

Something that might help here is that they've recently been moved over to Office 365 (not sure which licence). There is an educational theme throughout the organisation's work, but I'm not sure whether they qualify for Education licenses. I will learn this at our first meeting.

The above does involve the personal details of children, so this will need to be a consideration.

Before the meeting, I just want to research a few options that might be available to them, therefore I would appreciate if you could suggest some options for what format their new database might take. The way I see it, here are some possible options...

# Putting them all as contacts in Office 365 (cut-down option for zero cost)
# Outlook Customer Manager (if they have Office 365 Business Premium)
# Getting something built in Microsoft Dynamic 365
# Buying an Azure SQL instance, and writing some sort of web-based front-end for it
# Buying a fully-featured cloud solution like yourmembership.com

What are your thoughts on the above? And are there any other options?

I realise that a lot of the above depends on what else they have in their domain that can be utilised, but until the first meeting I'm not sure. But for argument's sake, let's just say that they have very little in terms of current infrastructure. Of course I'm not asking for you to spec a solution, I'm just asking what are the good/popular solutions for this sort of thing currently, as I have limited experience in this specific area.

Thanks
meirionwylltSenior Desktop EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David FavorLinux/LXD/WordPress/Hosting SavantCommented:
Information is to sparse to guess, as your question covers to many areas.

Maybe start by describing what membership means.

Huge difference between members who require some sort of login system to access some sort of data... and... members who receive bulk email about events periodically.
Brandon LyonSenior Frontend DeveloperCommented:
It's also going to depend on what exactly the data is used for.

Phone calls? Integration with PBX? Skype?
Ecommerce integration for shipping and order tracking?
Email blasts could mean info should be accessible via API or it could mean exportable via CSV, or something else?
yo_beeDirector of Information TechnologyCommented:
From my POV you are also adding layers of new technology that will require knowledge and expertise to manage, administer and support.  This is something to consider for your client.
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

meirionwylltSenior Desktop EngineerAuthor Commented:
Hi, thanks for your responses. I'll try to clarify some of the points as I have now received some more information...

No, the members will not require a login to access any data

Membership is that the organisation receives their details, including which school they attend, and then sends a welcome pack upon joining, and sends bulk emails out periodically. Membership has previously been done through schools, but the organisation is now keen to look at being able to join by filling out a form on a website, and being to set up recurring PayPal payments from there as well - with Standing Order and cheque being an option too.

No, there will not be a need for integration with PBX or Skype.

By 'email blasts' I just mean that they'd need some type of Mailchimp style system where you have a bunch of email addresses in lists, and that you can write nice looking emails and track unsubscriptions etc.

Thanks
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
I think you've actually designed your entire system in your last comment.

1) For membership + payment management, setup a WordPress site.

2) Use something like Content Restrict Pro for simple membership management or one of many other Membership plugins.

3) Use MailChimp or something similar to send your bulk email.
meirionwylltSenior Desktop EngineerAuthor Commented:
Sorry I was away over the holiday period.

Thanks, I must admit I hadn't thought of the Wordpress+Plugin approach. Great idea. Although something for me to consider here is that many of these don't have a newsletter functionality built in, and but offer integration with Mailchimp. And the amount of members involved here would require $375 a month extra in Mailchimp fees (unless I can find one that integrates with Office 365). Also the hosting fees, and as yo_bee said above, the system would require a bit more maintenance with it being self-hosted. But it might still work out a decent price. I'd make some calcs.

Just so that I can cover all bases, I'd also like to see what my options are within Office 365 as well, seeing as they've invested in this recently. Do you know if there's any way I can make use of the O365 ecosystem to help with this solution?

Thanks.
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
I use MailGun for 1000s of sites.

First 10K message/month for each MailGun account are free. After that per message prices are dirt cheap.

Also MailGun is the only truthful relay service I've found to date.

What I mean is you can tap into Webhooks for each message to receive the "truth" about all state changes on a per message basis.

Other services, like MailChimp, don't provide raw SMTP banner logs, so you never really know what's going on in the bowels of these systems.
meirionwylltSenior Desktop EngineerAuthor Commented:
I now know that the Office 365 licence they have is E3. So before I wrap up this question, are there any thoughts on if I could use the existing Office 365 infrastructure in any way to help with this solution to improve it or to save costs?

Thanks,
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
To guess at costs, compare costs of whatever email volume you imagine you'll be sending... compare between 365 + MailGun + whatever other services you may be considering.

Tip: I was just working on a system using https://smtp.com as the mail relay service.

There are zero debugging facilities.

The first time you have to debug some complex problem + can simply scan your Webhooks MailGun logs + instantly find the answer... well... it's a very good day when debugging mail problems is fast.

Compared with most relay services... they all work the same... till they don't + you have to debug the problem...

This is where systems like MailGun shine, because you have 100% of every SMTP response code ever generated for 100% of connections.
meirionwylltSenior Desktop EngineerAuthor Commented:
No I see the benefits of MailGun, but this can only be a part of my solution, as I will need some membersip management system (possibly able to accept payments) so it's to help with this that I was asking about Office 365.

Any suggestions?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.