How can i mass update leads based on zip?

[gerald29]

I have a list of zip codes and the corresponding users that they need to be assigned to. Is there a way to assign all the leads that are in these zips to the user at once? I can run a report that pulls all the leads in a range of zips, but i cant mass update from it. Thanks.

[crmsiva]

Hi

1. Search the leads by the zip code
2. Select the search result
3. Select the user to be assigned to in Mass Update panel
4. Now click update.

If you want to do this without Mass Update, you need to update directly in DB.

[gerald29]

Yes but i have hundreds of zip codes to do
i know i can do this in mysql, but i am looking for a cleaner, faster way.

[Angel]

You might want to consider creating a PHP script that retrieves the range of zip codes from the database, then iterates through them to update the related leads.

If you have a CSV listing of the zip code range, that would simplify the process as you could import it into its own table then iterate through that list.

You might be able to do this with a cursor as well, but I don't know for sure on MySQL. I've only used cursors on MSSQL.

[gerald29]

argh, frustrating. i wish we could mass update items based off reports...

[Angel]

Sorry man.