I have a bunch of contacts with two addresses. Each of their addresses is a different type (home, main, billing, etc). For these contacts, the billing address is primary.

I'd like to delete the billing addresses from the system and have the remaining address for each contact be left as the primary address.

I know how to do this one-by-one, but with more than 1,000 records to do I'd like a way to automate this. I have ID numbers for every contact that needs this change. Any ideas?

  • How are your php skills? You could write a small script with the API to do that.
    – Aidan
    Dec 19 '17 at 17:53
  • do you have access to your Civicrm database? Dec 20 '17 at 9:23
  • Keep in mind that if you have front-end financial transactions, those contacts will once again have billing addresses when/if they submit any of your payment pages. Is the main problem that the billing addresses are the primary? Or that there are multiple addresses (which will happen over time in Civi)? Dec 28 '17 at 20:54
  • @elizabeth did you figure this out? looking to do the same thing
    – Yossi
    Aug 14 '18 at 19:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.