Google Checkout Level 2, Name/Address format.

[rlobianco]

Hi, I'm using the source code version of the Google Checkout Level 2 release.
When a order comes though the address format is not correct.

For example, The shipping address should look like.
Firstname Lastname
123 Main st
Anywhere, City 12345
United States

But the City is not in the correct spot. It looks like this...

Firstname Lastname
123 Main St
Anywhere, 12345
City,US

and for customer info the City is missing,  I'm only seeing.
FirstName
123 Main St
Anywhere, 12345
,United States

Is there anyway to correct this?

[Alex]

Hello,

Yes, there is a way to change this. First of all, you might probalbly know that addresses are displayed using "address format"
defined in osc table "address_format". In our contribution, the default format for the Google Order is 1, i.e.:

Code:

$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country

I assume format you need is #2. So everyhting you need to do is:

1. If you want to change existing orders address format, run this query at mysql:
   This Query will change ALL orders which have address format 1 to 2.

Code:

   UPDATE `orders` set customers_address_format_id = '2', delivery_address_format_id = '2', billing_address_format_id = '2' where
   billing_address_format_id = '1';

2. If you want future orders to be of format #2, in file /googlecheckout/classes/gOscCommunicator.php
   at lines 417, 426, 435 change the address format to 1.

Hope that helps,
Alex

[mojomuse]

hi alex, you still there ..?  desperate to make contact re implementing your level 1 GC for CRE - and this seems to be your most recent post (so apologies for using wrong thread etc) .. 

[Alex]

Hi,

Look at the reply http://forums.advancewebsoft.com/index.php?topic=11.0
at the bottom.

Best,
Alex

[mojomuse]

will do, thanks