CartThrob Forums | Order Process Error

Order Process Error

Scott Harrington

Posted: 27 April 2012 01:54 AM

[ Ignore ]

Is a Really Great Dancer

Total Posts: 84

Joined 2011-03-15

Hi,

We keep receiving this error when customers from the US try and order, any ideas whats causing the problem?

Sorry, we are unable to process your order
The transaction was not registered because although the data sent to the payment gateway was formatted correctly, some information supplied was invalid. E.g. an incorrect vendor name or currency code was sent.3130 : The BillingState value is too long.

Thanks
Scott

Profile

Rob Sanchez

Posted: 30 April 2012 03:03 PM

[ Ignore ] [ # 1 ]

Administrator

Total Posts: 3541

Joined 2009-05-29

Which Sage gateway are you using, and what CartThrob version do you have? Also, maybe a snapshot of your checkout form template code?

Profile

Scott Harrington

Posted: 30 April 2012 11:49 PM

[ Ignore ] [ # 2 ]

Is a Really Great Dancer

Total Posts: 84

Joined 2011-03-15

Hi Rob and thanks for getting back to me - the Sage Payment Gateway is version ‘SagePay Server’ and the Cartthrob version is 2.0429.

We have since found out the customer was entering California as opposed to CA which seemed to have bypassed that error.

However and In addition to this, we are also having problems with the email notification templates which has started happening all of a sudden too. We now receive ” unexpected ‘)’ ” in place of the ‘Price’ , ‘Item Price’ and ‘Subtotal’ fields, below is a snippet of the template:-

<tr>
         <td width="25"><span >ID</span></td>
         <td width="290"><span >DESCRIPTION</span></td>
         <td width="80"><span >SIZE</span></td>
         <td width="30" align="center"><span >QTY</span></td>
         <td width="50" align="right"><span >PRICE</span></td>
         <td width="65" align="right"><span >ITEM TOTAL</span></td>
        </tr>
       </thead>
       <tbody>
        {exp:cartthrob:order_items order_id="{entry_id}"}
        <tr>
         <td valign="top"><span >{item:entry_id}</span></td>
         <td valign="top"><span >{item:title} {item:preorder}</span></td>
         <td valign="top"><span >{exp:cartthrob:item_options entry_id="{item:entry_id}"}{options}{if option_field == 'size-options' && option_value == '{item:size-options}'}{option_name}{/if}{/options}{/exp:cartthrob:item_options}</span></td>
         <td valign="top" align="center"><span >{item:quantity}</span></td>
         <td valign="top" align="right"><span >{exp:cartthrob:arithmetic expression="{item:price_numeric} * (1 + {order_tax_rate})"}</span></td>
         <td valign="top" align="right"><span >{exp:cartthrob:arithmetic expression="{item:price_numeric} * {item:quantity} * (1 + {order_tax_rate})"}</span></td>
        </tr>
        {/exp:cartthrob:order_items}
       </tbody>
      </table>
      <table cellspacing="0" cellpadding="0" width="100%">
       <tr>
        <td align="right">
         <table cellspacing="0" cellpadding="5">
          <tr>
           <td colspan="4">
            <img src="http://www.butterystore.co.uk/images/email-rule.gif" width="600" height="3" alt="The Buttery Store" />
           </td>
          </tr>
          <tr>
           <td width="525" valign="top" align="right"><span >Subtotal:</span></td>
           <td width="65" valign="top" align="right"><span >{exp:cartthrob:arithmetic expression="{subtotal} * (1 + {order_tax_rate})"}</span></td>
          </tr>
          <tr>
           <td valign="top" align="right"><span >Shipping ({if shipping_option == ""}Standard{if:else}{shipping_option}{/if}):</span></td>
           <td valign="top" align="right"><span >&pound;{shipping}</span></td>
          </tr>
          <tr>
           <td valign="top" align="right">&nbsp;</td>
           <td valign="top" align="right">&nbsp;</td>
          </tr>
          <tr>
           <td valign="top" align="right"><span >Total:</span></td>
           <td valign="top" align="right"><span >&pound;{cart_total}</span></td>
          </tr>
          <tr> 

Profile

Rob Sanchez

Posted: 01 May 2012 07:19 AM

[ Ignore ] [ # 3 ]

Administrator

Total Posts: 3541

Joined 2009-05-29

My guess is that {order_tax_rate} is blank for some reason. Try prepending it with a zero, so in case it is blank it will still output a number and not cause the arithmetic plugin to fail.

{exp:cartthrob:arithmetic expression="{item:price_numeric} * (1 + 0{order_tax_rate})"} 

Profile

Scott Harrington

Posted: 01 May 2012 07:30 AM

[ Ignore ] [ # 4 ]

Is a Really Great Dancer

Total Posts: 84

Joined 2011-03-15

Thankyou, I shall try this.

Profile

‹‹ Multiple orders with "Transaction in process offsite" in the payment error message using Sagepay eWay setup ››