UK Address Format

[Hiroboy]

My site has been up and running for a couple of months now, but I find the addresses are in the wrong format.

This mean I can't simply copy and paste them for labels etc

 

The Post Code is in the wrong place, not at the bottom of the address

 

I get this :

 

Jon Doe

1 Way Street

KT12 3FG

Maidstone

Kent

United Kingdom

 

when it should be :

 

Jon Doe

1 Way Street

aidstone

Kent

KT12 3FG

United Kingdom

 

Is it possible to change this format without upsetting the database ?

 

Thanks in advance

Steve

[loosefigures]

I would also like to know this - or is there way way that they can just enter it in block format?

[Guest]

take a look at

http://www.oscommerce.com/community/contri...+address+format

 

this can be added but it does appear to mean a clean installation.

 

Regs

Andy

[radders]

It is easy to change the date format. Each country in your admin has a default date format assigned to it (1-5 I think). Some of them are incorrect. These can be changed in Admin->Locations/Taxes

The date formats themselves can be edited using phpmyadmin in the table called something like 'address_format'

[Hiroboy]

Any have any ideas on this address format problems ?

[wildchief]

Any have any ideas on this address format problems ?

 

If you have not done much configuration or if you have and don't mind starting again you could use this U.K version of OS Commerce

 

http://www.oscommerce.com/community/contributions,2816

 

thats what i did

[AlanR]

Any have any ideas on this address format problems ?

See: http://www.oscommerce.com/forums/index.php?showtopic=206900

[Guest]

there is a simple fix to this problem.

 

browse your address_format table in your shop database

 

edit address_format_id no. 4

 

in the address_format field, replace all with "$firstname $lastname$cr$streets$cr$city$cr$postcode$cr$country"

 

Save changes and logout.

 

Then go to your oscommerce admin and go to Localization/Taxe --> Countries --> United Kingdom

 

Edit and change address format to 4.

 

Any new addresses entered when checking out and in new orders will now be displayed in the correct format for UK addresses.

 

Note that I simply changed address format 4 and you can do the same to any other address format number.

 

Hope this works for you too!

[mylittlereddress]

Thanks for the simple fix. Worked brilliantly.

 

If anyone is interested in Having the format

Name

Street

Town/City

County, Postcode

Country

 

Change the above to

 

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

 

Hope it helps someone!

[etzeppy]

there is a simple fix to this problem.

 

browse your address_format table in your shop database

 

edit address_format_id no. 4

 

in the address_format field, replace all with "$firstname $lastname$cr$streets$cr$city$cr$postcode$cr$country"

 

Save changes and logout.

 

Then go to your oscommerce admin and go to Localization/Taxe --> Countries --> United Kingdom

 

Edit and change address format to 4.

 

Any new addresses entered when checking out and in new orders will now be displayed in the correct format for UK addresses.

 

Note that I simply changed address format 4 and you can do the same to any other address format number.

 

Hope this works for you too!

 

You can also add to the tabel as needed. I found that many of formats are incorrect. I just created a database record in address_format for each address format I needed. It's not too difficult.

[colinp]

Hi are you editing the sql in phpmyadmin? im a bit confused how you have made this change?

 

ive clicked on address_format then i get 3 more choices , 1 of which is address_format_id - but from here i dont know what to do???

[♥14steve14]

Go the whole hog and search the add ons for UK Oscommerce. Its there somewhere. it includes most of the files to alter oscommerce to english from US.

 

Failing that have a look in the "How do i" sticky at the from of this forum.

[♥geoffreywalton]

There are a couple of useful threads in my profile under "UK Your Site".

 

HTH

 

G