Nearby Customers Solution - sorting by distance

Hi @bmenasco, we don’t currently have a way to sort contacts by distance. If this is something you’d like to see in the future, feel free to post it as an Idea for our product team to look at.

Hi @bmenasco,

You could work around it in two ways: 

1. Google Sheets Formulas (comparably easy but rather manual process)
   - Follow the process of exporting editing and importing your contacts suggested by Copper as workaround: 
   https://support.copper.com/hc/en-us/articles/213584103-How-do-I-merge-or-delete-duplicates-in-bulk-
   - add a column using the Google Maps formulas after exporting
   https://www.labnol.org/google-maps-sheets-200817
    
2. Use the Copper APIs (more automated but requires a little coding) 
   - Create a custom field 
   https://support.copper.com/hc/en-us/articles/360000558631-Create-edit-and-manage-Custom-Fields
   - Search for those contacts with the empty custom field “Distance”
   https://developer.copper.com/people/list-people-search.html#list-people-in-groups-of-200
   - Loop through the contact IDs and calculate the distance with to your location with any distance API e.g.
   https://www.codexworld.com/distance-between-two-addresses-google-maps-api-php/
   - Update the contacts’ custom field accordingly
   https://developer.copper.com/people/update-a-person.html