AdminAreas and Authorize.net

[Bob Waycott]

Hey guys,

I am wondering where we pulled the list of AdminArea names & values from. We just had an order come in from Spain that could not be successfully processed via Authorize.net. Authorize declined the transaction multiple times, showing the following reason:

Transaction Status: Declined (Authorization with the card issuer was successful but the transaction was declined due to an address or ZIP code mismatch with the address on file with the card issuing bank based on the settings in the Merchant Interface.)

Address Verification Status: Address Info not available for Cardholder (U)

I've looked around, and the only thing I'm able to come up with is that Satchmo has sent Authorize.net the following value for the customer's state:

"Autonomous Region of Madrid"

Where did we come up with this name in the AdminArea fixtures? From what I see at the following two links, the established English name is "Madrid." This isn't the first time I have had to manually modify state/province names in the AdminArea model.

http://en.wikipedia.org/wiki/Provinces_of_Spain

http://en.wikipedia.org/wiki/Autonomous_communities_of_Spain

I also notice there's a listing for "Autonomous Region of Navarre" -- the links above show two differing names for this province.

Anyone know if there's a way of getting a definitive list of state/province names that are accepted by payment processors?

Thanks,

Bob

[Bob Waycott]

Interestingly enough, if I pull up the list of Spain's provinces here:

http://www.commondatahub.com/live/geography/state_province_region/iso_3166_2_state_codes

I am returned 52 results.

Wikipedia says there are 50 provinces.

Satchmo has 19.