• Home
  • Blog
  • How to clean your simPRO Customer Database
Hari Iyer | SyncEzy

Hari Iyer | SyncEzy

  • Reading Icon 3 Min Read
  • Reading Icon Aug 19, 2018

Let’s face it your customer database isn’t clean !

In all our years of working with simPRO users we’ve noticed them all. There’s just way too many to list here but I’ll try to make a list, think of what ticks off for you.:

You could have

  • duplicates,duplicates,duplicates,
  • misspelligns
  • wrong email addresses @gamil.com
  • Incorrect CaPItalisATIONS
  • incor rect Spaci n g s
  • Not having the full address (34, Sydney
  • Suburb not entered in the Suburb field
  • Entire Address entered in the street address area
  • Post Code missing
  • Phone number not entered in correct place
  • Phone / mobile not entered in the correct format (Critical for SMS and other phone / Voip services)
  • Mobile entered as phone number and viceversa
  • Two emails entered in the single email address column ([email protected][email protected])
  • Customer Profile not entered / Not segmented
  • Customer Group not entered / Not segmented
  • And heaps more like this For example companies named differently School, Limited, Ltd etc.

Is this is something that gives you jitters every time you want to run a marketing campaign or send a mass mail out to customers ? Imagine that you have some jobs coming up in a certain area of town and you want to pitch your customers in that area of town to get more work well having a clean database can help with that.

What about an announcement or a special promotion that you want to announce.

Let’s look at a little known export / import feature in simPRO and how you can use it to clean up your simPRO database in the all powerful MS Excel !

To do the same individually in simPRO would take days if not weeks.

So instead of spending hours before every big marketing push here’s how you can clean up your database efficiently in a matter of minutes and hours not days and weeks.

Step 1) Export the simPRO customer list to EXCEL

So instead of spending hours before every big marketing push here’s how you can clean up your database efficiently in a matter of minutes and hours not days and weeks.


Step 2) Edit the list in Excel like a super ninja !

Cleanup the list like shown in this video: Become an excel super ninja !

Step 2) Upload this cleaned up csv file back into simPRO !

You have done a great job, Give yourself a pat on your back and grab that double cream frappuchino or Gin and Tonic, whatever’s your poison ! You deserve it after all this hard work.

If you need help doing this or have special requirements reach out to us, we can do this and lots of other API black magic with simPRO  ????


Hari Iyer | SyncEzy
Hari Iyer | SyncEzy

Hari Iyer is the Founder and CEO of SyncEzy, a pioneering company at the forefront of data integration and automation solutions. With a deep understanding of the power oHari’s relentless pursuit of excellence and his commitment to delivering tangible results have earned SyncEzy a loyal global clientele. He is not only a successful entrepreneur but also an active contributor to the technology community, sharing his insights through thought leadership articles, speaking engagements, and mentorship programs. Hari’s ability to navigate the complexities of remote work serves as an inspiration for leaders, highlighting the importance of flexibility, work-life balance, and a results-oriented approach in today’s evolving work landscape.

If technology and a passion for solving complex business challenges, Hari has emerged as a visionary leader in the industry. Under his guidance, SyncEzy has gained widespread recognition for its deep integration solutions that seamlessly connect software applications, eliminate data silos, and enhance operational efficiency.

When not working Hari is trying to be a better father, and reading Tech news, playing FPS games and not exercising as he should.