Customer Database

Home Forums General Trade Forum Customer Database

Viewing 15 posts - 1 through 15 (of 42 total)
  • Author
    Posts
  • #5253
    Martin
    Participant

    I guess a good number of you keep some sort of customer database ?For the large businesses it is a vital thing and you could not manage without such a tool. But for those smaller outfits I would stress its importance and I would like to point out the enormous benefits of doing so in future.

    In my case I record every single customer invoice raised, giving details not only of names and addresses but work done, machine make, model and in some cases serial number or date code. Also included is the reason for the job (i.e. Not spinning or leaking, whatever) and a detailed report as to the faults found and what was repaired. Listing part numbers, prices etc.

    This I have done daily now for 11 years, accruing over 15,000 records. Whilst it is a fag sometimes to enter the info, the benefits are tremendous, including:-

    1). Instant recall of specific customers previous record.
    2). Look back to search for similar problems encountered and how they were resolved.
    3). Ability to analyse more effective stock control etc.
    4). Duplicated information contained on Laptop Computer and carried with me on the van.

    plus many other benefits too numerous to mention.

    No fancy software in my case (no need) just Windows MS Works Database, simple to set-up and priceless to use!

    Martin

    #110116
    kwatt
    Keymaster

    I cannot tell you how much we rely on our database/call management system, it is absolutely vital in running a modern service company. So much so that without it we would be dead in the water, literally.

    I’ve had a few occasions where the server has toppled over in the past few years and, on each occasion, we almost couldn’t even book a call!

    Being able to track your customers and pull up details of a customer on a whim is essential IMHO giving you a potted history of the customer and your dealings with them and apart from that the right tool for the job can save shedloads of cash and time. Also, customers now expect you to have this information which I can fully accept.

    We have looked at several systems, web based, MS Access based and others but as yet, we’ve yet to find one with the communications required and the speed needed to take calls straight off the phone, fax or email without any hinderance. Web based is not the way to go with call management IMO for this industry, locally stored data is. But more on all this once Dave and I finish and actually find a suitable system to use that we would be happy recommending.

    Martin’s solution is fine if you have the time and way-with-all with a PC to use it but for most of us we need a solution dumped on us that just works and is already tailored to our industry. But believe me, the right system as Martin rightly says, saves just so much time and hassle you wouldn’t understand how you managed without a call logging system.

    K.

    #110117
    Penguin45
    Participant

    I know K doesn’t like it (and HOW!), but we’ve kept ALL customer data on Lotus Organiser for 11 years now – even the OUTS, NO ACCESSES, nasty dog, awkward kitchens, Mrs Mad’s, RTFM’s etc. Oh, and the bad debts as well. We can generally track down a repeat customer before they’ve finished introducing themselves, and tell them the life story of the relevant appliance down to model and serial number (and probably their inside leg measurement as well). I also tend to record any Manufacturers service notes as well.

    It’s all info and it’s all crucial.

    The number of independants up here who don’t even log model numbers is astounding! How do they deal with recalls or even order spares?

    I’m going to stop; it’s depressing.

    Penguin.

    #110118
    kwatt
    Keymaster

    Exactly Penguin, irrespective of the system used (I won’t go there okay ;)) the logging and retention of all this data is absolutely critical to me and to Dave as well I know. It’s why we’re putting so much effort into finding a system that is cost effective (read cheap) that anyone can use but has the capability needed specifically for whitegoods servicing purposes.

    It has to be simple and easy to use, as well as fast for call logging off the phone etc. and offer expansion into other areas as required as well as the volume of information and clients (network and them what pay) as possible. I have a few nifty ideas on that.

    But if there’s enough interest in dragging our asses into the 21st century then I’m sure we could get a deal on some software. We just have to make sure it’s the right software for the task.

    K.

    #110119
    Martin
    Participant

    Re: Customer Database

    Steady Boys!

    I started this thread to draw ideas, not blood.

    I must say at this stage that penguins database seems all encompassing to a finite degree. (It must take ages to log such info and fascinating reading!)

    My simpler MS Works information also keeps me one step ahead, in the unlikely event of a complaint/recall. When my phone rings (I have caller display) I can type in the phone number, just to see if anything comes up before they have chance to talk! And yes, I realise that modern database software does that automatically, Sky TV were first up with that idea some 14 years ago!

    Martin

    #110120
    kwatt
    Keymaster

    No Martin there’s no blood to be drawn, I just fail to comprehend how any service company in this day and age can survive without some IT, and many seem to do so.

    As for CLID etc, there’s more to that than you probably know about and tricks you can do with it. 😉

    K.

    #110121
    Tinhips
    Participant

    Re: Customer Database

    A word of caution on Data collection.
    Register with the Data Protection Agency, no matter how small you are,because as soon as you use the information outside of a personal record you break the law.
    Even personal comments added to the record can be an infringment.
    This now also includes paper records.
    Just a reminder.

    #110122
    sparkey
    Participant

    Re: Customer Database

    Tinhips wrote

    Register with the Data Protection Agency, no matter how small you are,because as soon as you use the information outside of a personal record you break the law

    I recently received a scam letter supposedly from Data Protection Agency asking for a large sum of money to register a “legal requirement”, being of a suspicious nature I rang D.P.A who told me that as an independent service engineer I did not have to register, of course check with them if you are a larger organisation as the rules may be different in that case.

    #110123
    Martin
    Participant

    Re: Customer Database

    Tinhips wrote:A word of caution on Data collection.
    Register with the Data Protection Agency, no matter how small you are,because as soon as you use the information outside of a personal record you break the law.

    This is true but come on guys they are personal records thats all!

    sparkey wrote:I recently received a scam letter supposedly from Data Protection Agency asking for a large sum of money to register a “legal requirement”, being of a suspicious nature I rang D.P.A who told me that as an independent service engineer I did not have to register, of course check with them if you are a larger organisation as the rules may be different in that case.

    I get this same Data Protection rubbish every year and shred it with all the other junk mail. It’s yet another scam to take money from you under the guise of conforming to our already overburdening nanny state.(IMO)

    At this rate we will soon have to retain our ‘Post It’ notes for government inspection!

    Martin

    #110124
    Dave_Conway
    Participant

    Re: Customer Database

    I have added a new download regarding the DATA protection act. It’s basically a guide for small businnesses, not the whole act as this is huge and mainly not applicable. It’s in the pdf section. Or you can download it here:

    http://www.informationcommissioner.gov. … 20V1.2.pdf

    From memory when our old registration expired last year, the law has changed. If as mentioned the information is used purely for personal records and does not contain information regarding religious beliefs, ethnic status or suchlike, or is used for marketing purposes it is now no longer neccassary to register, but it’s worth checking.

    Dave.

    #110125
    johnmac11
    Participant

    Re: Customer Database

    Hi Guys,

    Been following this post with interest since I have not registered under this act. A few years ago I checked if I was required to register and was told that I did not have to. I have got records of all my customers on my server and even have records of prospective customers who I have never been to ( they have registered their product with the manufacturer and their database updates mine daily.) So after reading the previous posts I thought I better cover my backside and check If I should register under the act and was told again that I do not need to.The evidence is here:

    http://forms.informationcommissioner.go … ml#Account

    In short if you keep records for staff administration and if you keep records of your customers on computer you do not need to automaticaly register as long as your data is within the guidelines of the above link.

    Comments????


    John

    #110126
    Dave_Conway
    Participant

    Re: Customer Database

    johnmac11 wrote:Comments????

    Yep, that’s basically the same as they told me last year. I didn’t need to re-register either.

    Dave.

    #110127
    Martin
    Participant

    Re: Customer Database

    johnmac11 wrote:
    Comments????

    Thanks for that link johnmac11. It bears out my feelings over this whole issue.

    Martin

    #110128
    Martin
    Participant

    Re: Customer Database

    Last weekend I was having trouble backing up my Customer Database due to the fact my CD re-writer was playing up for some reason. Now I have been having problems recently transfering the data via these CD Roms to my Laptop. Very slow reading the disc, dirty tracks and all that tosh you’ve heard of before I’m sure. 😕

    Well I thumbing through the weekend paper when I read about “Memory Sticks”…………Eureka!..that will solve my problems for sure! 💡

    Brilliant, super tiny, clever little 128mb device now hangs from my keyfob ready to backup all I ask of it….Why the hell didn’t I figure that out earlier?…Oh I know…I’m an old git trying to keep up I guess 😕

    Thanks PC World!

    Martin

    #110129
    Furhan
    Participant

    Re: Customer Database

    Has anyone developed/purchased a good database system to record jobs/customer info?

    I made a basic access database to record jobs and make basic vat monthly statements for account customers. I am (slowly) working on a more advanced database system which will allow me to assign jobs to account customers or public, track job history and display the history on screen with a simple search and a few other features. I did have a nice app based on website entry which had a backend Access database and a front end ASP website for storing job info, customer info, there was a section for customers to login and view progress on jobs. I used it a few years ago with one of my account customers, it was quite useful but I had to customise it quite a bit. I left for months and managed to lose all of my code and the company who made the application closed down 🙁

Viewing 15 posts - 1 through 15 (of 42 total)
  • You must be logged in to reply to this topic.