Ah well, no luck.
I updated all the zip codes using CSV import, using the entry_id field and the work address zip code. The import worked fine (gave no errors, data looks correct in DB), but the site still shows the old zip codes even though the new ones are correct in the database, and correct when you edit them one at a time in Connections.
They do still update correctly when you edit/save an individual in Connections.
The CSV has rows of data like this:
I’m mapping the first one to entry_id, the second to work address zipcode.
Is there something I’m doing wrong? Is there perhaps another field besides zip code that must be edited to cause the caches to be refreshed (perhaps something like name in the _connections data table instead of only updating something in the connections_address table)?
BTW, we do have W3 Total Cache, but I emptied all the cache, and even turned that plugin off, with the same results.
I’m so sorry to keep bugging you with this! I thought we had it licked.