• Stop being a LURKER - join our dealer community and get involved. Sign up and start a conversation.

Reply to thread

It's more complicated than this. The data is stored across many tables. The customer list you are referring to is a flattened version of what is derived from around 10 tables.


They were will many unique keys, and the crm is also at the mercy of the dms and their keys. So you have to understand the whole system. Think of all the associated tables also, appointments, ROs, sales, leads etc. You have to handle those as well.


The reason no one does this as a service is it totally sucks, dealership aren't willing to pay what it actually costs to fix it and the definition of clean/done is very blurry.


You also have to establish a foward looking way of preventing duplicates. That means managing people and hiw they use your systems. That's on the dealership to implement and maintain.