Home › Forums › General Trade Forum › Customer Database
- This topic has 41 replies, 17 voices, and was last updated 22 years ago by
Martin.
-
AuthorPosts
-
March 21, 2004 at 10:27 am #5253
Martin
ParticipantI 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
March 21, 2004 at 1:29 pm #110116kwatt
KeymasterI 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.
March 21, 2004 at 11:56 pm #110117Penguin45
ParticipantI 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.
March 22, 2004 at 12:10 am #110118kwatt
KeymasterExactly 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.
March 22, 2004 at 8:15 am #110119Martin
ParticipantRe: 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
March 22, 2004 at 9:07 am #110120kwatt
KeymasterNo 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.
March 22, 2004 at 11:00 pm #110121Tinhips
ParticipantRe: 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.March 22, 2004 at 11:50 pm #110122sparkey
ParticipantRe: 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.
March 23, 2004 at 8:16 am #110123Martin
ParticipantRe: 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
March 23, 2004 at 8:59 am #110124Dave_Conway
ParticipantRe: 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.
March 24, 2004 at 7:48 pm #110125johnmac11
ParticipantRe: 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????
JohnMarch 24, 2004 at 8:32 pm #110126Dave_Conway
ParticipantRe: 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.
March 25, 2004 at 8:39 am #110127Martin
ParticipantRe: Customer Database
johnmac11 wrote:
Comments????Thanks for that link johnmac11. It bears out my feelings over this whole issue.
Martin
June 15, 2004 at 8:45 am #110128Martin
ParticipantRe: 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
July 1, 2004 at 2:48 pm #110129Furhan
ParticipantRe: 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 🙁
-
AuthorPosts
- You must be logged in to reply to this topic.
