DoESLiverpool / somebody-should

A place to document practices on the wiki and collect issues/suggestions/to-do items for the physical space at DoES Liverpool
32 stars 11 forks source link

Find a cheaper basic CRM system #1478

Open johnmckerrell opened 4 years ago

johnmckerrell commented 4 years ago

We currently pay about £70/month for a CRM system that handles creating tickets for enquiries to hello@ or organisers@. It basically ensures that all the organisers can see and respond to all the messages that come in.

When we just had it forwarding, it was too easy for people to forget to reply-all, and then for someone to be off for a few days and miss important emails.

We don't need anything fancy, but we do need the ability to make sure everyone gets all replies (although if we don't find anything simple soon it's not worth continuing to pay £70).

MatthewCroughan commented 4 years ago

From your description, I do not see why this could not be used in a similar to way as you might use Jira to create tickets. It is essentially an open source trello, no doubt there is an API you can use to create issues on the board which could act like tickets. https://github.com/plankanban/planka

johnmckerrell commented 4 years ago

For the record, the emails/conversations would need to be private but if this tool would work with a private repo then that might work.

MatthewCroughan commented 4 years ago

Yeah, it's entirely self hosted so there are no limitations on privacy. When I say issues, I do not mean github issues, I just mean the general concept of issues. This tool would not interface with github in any way as far as I know.

johnmckerrell commented 4 years ago

TBH I'm really wondering if it's possible to do it with exim linked to a database. Needs something along the lines of:

  1. email arrives at hello@does - this could simply be forwarded to newticket@support.does...
  2. ticket is created with some sort of ID 3, a set of email addresses are assigned to ticket, as well as all email addresses on the original email (To & CC) 4, email contents are sent to everybody assigned to ticket who has not already received it, with a reply-to of @support.does...

Then further replies are handled with:

  1. Email comes in to @support.does...
  2. Essentially GOTO 3 above but we'd only add any people who weren't already assigned

One troublesome thing would be requiring some sort of unsubscribe mechanism, which might require a website, although I guess you could perhaps do it by email.

Also you wouldn't want ticket IDs to be guessable. You could perhaps just ignore emails to a ticketid if the person wasn't already connected to the ticket but often an existing person will want to add someone in. You could then allow this specific behaviour, but it's too easy to spoof email addresses so you could just add yourself to any ticket by spoofing an email from an existing organiser.

Would also have to consider spam too, and would likely need to send emails out through AWS's SMTP servers to make sure our email wasn't flagged as spam.

johnmckerrell commented 4 years ago

I've just gone through the list on this page: https://alternative.me/supportbee

Zendesk at $5/agent/month is reasonably cheap. Zoho has 3 agents free then additional £10/month each https://www.zoho.com/desk/pricing.html

Few self hosted options:

JessWade commented 3 years ago

Techloyce.com also providing the same services with very reasonable pricing. Their certified Zoho Consultants provide specialist consulting knowledge in Zoho applications, allowing you to improve business efficiency and get the most out of your technology investments by utilizing the Zoho app suite. By engaging with you and understanding your business requirements, we can help you match your company goals with the newest technology and streamline your business operations with Zoho automation. Our consultation service also aids in the success of CRM systems at all levels.

amcewen commented 2 years ago

I haven't dug into them, but there's been a similar discussion on the CoTech forum which seems to like Zammad