All German Addresses Incomplete

[SamyT]

I have just realised thanks to a German customer that the state/region part of an address never shows as part of German orders. When I go into order editor, I can see Thüringen in the state box, but on the invoice or just on the order page in general, only the other parts of the address show up. I always thought German addresses looked a tad minimal, now I know why!

 

The same customer has also made me realise any state with this character in it - ü - does not let them move forward with their order on the page where they enter their details. This can be avoided by changing it to a U however it doesn't matter anyway if it's in the state box because it won't show up on their order!

 

Does anyone know how to fix this?

 

ADDED

 

I just checked another German order where "Hessen" is in the state box and also not showing in their address emailed to us or on the invoice/packing slip, it simply disappears.

[SamyT]

Just further to this, I checked an entirely different oscommerce website and a German order on that site, same thing. The option they choose in the state part of the address does not appear in the order email or on the invoice or packing slip.

[burt]

make sure that the address format used for germany is including the state. phpmyadmin - address tables

[burt]

yeah, thats the problem. Germany uses address_format_id 5.

 

5 is $firstname $lastname$cr$streets$cr$postcode $city$cr$country

 

So you need to change it to add $state

 

Eg;

 

$firstname $lastname$cr$streets$cr$state$cr$postcode $city$cr$country

 

Which would output like so

 

Joe Bloggs

123 Any Street

Hessen

ab12345

Berlin

Germany

[SamyT]

Thank you for the response, is this edited in phpmyadmin? I've never had to edit something like this in the past.

 

yeah, thats the problem. Germany uses address_format_id 5.

 

5 is $firstname $lastname$cr$streets$cr$postcode $city$cr$country

 

So you need to change it to add $state

 

Eg;

 

$firstname $lastname$cr$streets$cr$state$cr$postcode $city$cr$country

 

Which would output like so

 

Joe Bloggs

123 Any Street

Hessen

ab12345

Berlin

Germany

[SamyT]

I found it and changed it, thank you so much, I appreciate the fast response!