Building my own tech
Now Reading
Create my own CRM

Create my own CRM

by KieranFebruary 14, 2015

Customers are the life blood of all businesses, yet, many businesses don’t seem to value them as much as they should. If a new customer contacts you via email and requests information, you should be adding those details to your CRM so that you remember to follow up with them & once the job is completed, you can always contact them about complementary services or even asking them for a testimonial.

A single customer really can have a profound impact on a small business – if you can convert that single-purchase customer into a frequent customer, then your cost of acquisition drops significantly.

As you probably know, I am huge fan of tools that don’t require any technical expertise and today I’d like to show you how you can create your own, fully customized CRM system for about £55*. That may feel like a lot to pay upfront, but, that really is the only cost you need to incur (assuming you already have web hosting). The cost of a CRM consultant is likely to be at least 100 times this cost, so it’s definitely worth it.

The tool that I’ve chosen is called AppGini, it creates a PHP & MySQL driven CRM system at the click of a button. When you open the application, you’ll be asked what you’d like to do, select “start a new project” – afterwards you should see the below screen.

Netshock AppGini

This is probably one of the most straightforward tools I’ve ever come across, so I’m not doing to dwell too long on operating the tool, but, the functionality is brilliant:

– Login and registration system
– Different membership levels (restricting access to certain areas)
– Quick application of responsive (bootstrap) themes
– Interconnected tables to show all information related to a client in a single view

The last of those points is the most interesting. Lets say you have the below tables:

Customers
CustomerID
Name
Email

Orders
OrderID
CustomerID
Product
Price

You can easily link the tables based on the CustomerID. That means when you look at the customers record in the database, it will also show all of their orders & the order details – meaning you don’t need to keep switching between screens. Brilliant! I’ve included a screenshot below and highlighted the customers orders which are visible on the customer details page.

appgini12

Not only does this tool reduce your development time and cost, but, it’s also tried and tested code by all of AppGini’s customers, meaning, you don’t need to test the code quite so thoroughly. Additionally AppGini state that they “generate secure code.” meaning that ” you don’t need to worry whether your code is vulnerable to SQL injection, XSS, brute force attacks, … etc.”

I am a huge advocate of AppGini – I hope you find it as useful as I have.

*correct at time of writing

Image used under creative commons

This article was brought to you by Netshock. Netshock aim to provide technology guides and insight to our readers

What's your reaction?
Love It
0%
Interested
0%
Meh...
0%
What?
0%
Hate It
0%
Sad
0%
About The Author
Kieran
My name is Kieran, I love to see how technology can drive business growth. I started the Netshock technology blog as a place to share my thoughts and experiences with a wider audience. I cover all sorts of topics, from marketing to development.