SagePay MALFORMED error - billing state required

curtisbollington
Topic Author
Offline

13 years 10 months ago #75247 by curtisbollington

SagePay MALFORMED error - billing state required was created by curtisbollington

We have a customer in the US trying to make a payment on our site www.v-kit.com , but gets the following error:

"This transaction attempt had failed. Please use the Proceed button to go back to the web store from which you were purchasing. The details of the failure are given below:
MALFORMED
3147: The BillingState field is required."

We've done a bit of research, and it might be something to do with the US State codes, instead of selecting 'Arkansas' they should select 'AR'.

Is this correct? If not, can you help? And if so, how do I configure this?

I wouldn't have thought it mattered, as the state codes are listed with the state names, so surely there must be some cross-referencing?

One other thing I've noticed is that in my version of HikaShop (Professional) the State codes for the USA show two-letter codes under the column 'Code 3 letters'. Is that correct, and does it make any difference to anything?

Thanks, Curtis

Please Log in or Create an account to join the conversation.

Xavier
Offline

13 years 10 months ago #75308 by Xavier

Replied by Xavier on topic Re: SagePay MALFORMED error - billing state required

Hi,

Can you try to edit the file "plugins/hikashoppayment/sagepay/sagepay.php" in the function "onAfterOrderConfirm()" replace the lines:

Code:

		if(@$order->cart->billing_address->address_country->zone_code_3=='US'){
			$postData['BillingState'] = @$order->cart->billing_address->address_state->zone_code_3;
		}
		if(@$order->cart->shipping_address->address_country->zone_code_3=='US'){
			$postData['DeliveryState'] = @$order->cart->shipping_address->address_state->zone_code_3;
		}

By:

Code:

		if(@$order->cart->billing_address->address_country->zone_code_2=='US'){
			$postData['BillingState'] = @$order->cart->billing_address->address_state->zone_code_2;
		}
		if(@$order->cart->shipping_address->address_country->zone_code_2=='US'){
			$postData['DeliveryState'] = @$order->cart->shipping_address->address_state->zone_code_2;
		}

Thanks to give us a feedback.

Please Log in or Create an account to join the conversation.

curtisbollington
Topic Author
Offline

13 years 10 months ago #75331 by curtisbollington

Replied by curtisbollington on topic Re: SagePay MALFORMED error - billing state required

OK, I've done that by simply changing the '3' to '2', where it's displayed. There was no intelligence behind this, I simply did as instructed, as I know nothing about coding. I'll let you know the outcome.
I've attached a screen grab of the USA state zones, which shows the 2-letter codes in the 3-letter column, is that as it should be (this is the default as supplied with HikaShop). If it's not correct, does this mean that the changes I've made to the code won't work? Just curious.
Thanks
Curtis

Please Log in or Create an account to join the conversation.

Xavier
Offline

13 years 10 months ago #75333 by Xavier

Replied by Xavier on topic Re: SagePay MALFORMED error - billing state required

Yes you're right, can you try this:

Code:

		if(@$order->cart->billing_address->address_country->zone_code_3=='USA'){
			$postData['BillingState'] = @$order->cart->billing_address->address_state->zone_code_3;
		}
		if(@$order->cart->shipping_address->address_country->zone_code_3=='USA'){
			$postData['DeliveryState'] = @$order->cart->shipping_address->address_state->zone_code_3;
		}

Please Log in or Create an account to join the conversation.

curtisbollington
Topic Author
Offline

13 years 10 months ago #75377 by curtisbollington

Replied by curtisbollington on topic Re: SagePay MALFORMED error - billing state required

We've tested that, and it seems to work fine. Thanks a lot for all your help.
Curtis

Please Log in or Create an account to join the conversation.

Time to create page: 0.190 seconds