Hmm... I need to find out myself. I don't know what is the answer to that question. I'll do some investigation and get back to you if I bump into an answer. You should email the people at iContact as they probably can answer it..
Take a look at.
This can be added but it does appear to mean a clean installation..
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'..
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.
Thats what I did..
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!..
Thanks for the simple fix. Worked brilliantly..
If anyone is interested in Having the format.
Change the above to.
$firstname $lastname$cr$streets$cr$city$cr$state, $postcode$cr$country.
Hope it helps someone!..
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...
Hi are you editing the sql in phpmyadmin? I'm 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???..
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...
There are a couple of useful threads in my profile under "UK Your Site"..