Mismatched integration value and ISO code Error

[KMartin]

We are just setting up WooCommerce and sent a test transaction. We received a "mismatched integration value and ISO code for field" error when trying to process temporary contact TC-1123. Can you tell me what field caused this error, so we can fix it. Also please look at all the custom question information that is coming over - how do we prevent this from happening?

I have given you 7 day access. Our Org ID is 00DA00000009ZiZ

I have screen prints but I tried to upload and am getting the following error "Upload failed due to your usergroup's upload quota. This file will require 172.2 KB but you only have 3.5 KB of 976.6 KB remaining." Not sure how to resolve this or how to get the screen prints to you.

[CnP.Support.AM]

Good day @KMartin

We reviewed and found that you have enabled the Country state picklist in Salesforce and you have set the INTEGRATION VALUE to be the full name. You are seeing the two letters code at Temp contact state (TX) but the actual value in the database is the full name.

You can resolve this by changing each of the states in Data Management which you configured State and Country Picklists, choose United States to edit, and then edit the states) and change it to the TWO letters code.



Hope this will resolve the issue. Please check and let us know if we can be of any further assistance.

[KMartin]

I have updated all the states to fix the integration value to 2 letter codes. I went into our Event and sent a test transaction and I am still receiving an error (error below.... your forum will not allow me to attach pictures). Our C&P settings are set to "Use State/Province abbreviation (e.g. California = CA)". I'm not sure why it still will not process correctly. Temporary Contact ID - TC1177, TC1178, TC1179, TC1180

I have granted access for 7 days. Our Org ID is 00DA00000009ZiZ

Visualforce Error

System.DmlException: Insert failed. First exception on row 0; first error: FIELD_INTEGRITY_EXCEPTION, There's a problem with this state, even though it may appear correct. Please select a state from the list of valid states.: [MailingState]
Error is in expression '{!SaveItem}' in component <apex:commandButton> in page cnp_paas_evt:eventtemporarycontact: (CnP_PaaS_EVT)



An unexpected error has occurred. Your solution provider has been notified. (CnP_PaaS_EVT)

[CnP.Support.AM]

Good day @KMartin

The issue is, you have updated the INTEGRATION VALUE to be the TWO letters but if you notice the temp contacts are having full state name which is causing the issue:



Hope you see the issue.

[KMartin]

I do see the issue, but I do not know how to resolve the issue. The form fields in Event Manager will not allow to change to state code. Please help.

[KMartin]

Disregard. Since the events manager continues to process with full state name (even though it is marked as State Code in C&P Settings), I went ahead and reset all the integration values back to full state name.

The only future issue we will see are transactions processed through WooCommerce. Unfortunately WooCommerce uses state codes instead of full names. Therefore I will have to temporarily change the integration value back to the state code to process the temp contacts then return it back to full state name once this is completed.

It will not be a pleasant process, but at least it's a work around. Maybe one of these days WooCommerce, Salesforce and Click & Pledge will play nice together.