Address format for Japanese...

[DrByte]

but I am wondering about uploading the new code that I have modifed?

If I upload the slightly modified file, I take it that it will just make a new entry (no. 7). If that is so, I guess it would be better to delete the old one, but how do I go about doing that?

Running the statement again will produce another entry, so you might want to simply edit the settings in phpMyadmin ... edit record #6 (you mentioned) and paste the new format over the old one.

Using your example, I created this one:

INSERT INTO address_format VALUES (NULL, '$country$cr$postcode$cr$statecomma$cr$city$cr$sub urb$cr$street$cr$firstname $lastname', '$country / $postcode');

the $cr are line-breaks and $comma are commas ... you may not want so many line-breaks as you have shown in this suggestion.


So ... you will then have "6" and "7".... how are you going to decide which one is used?
These address formats were designed based on international ISO standards for the sake of being universally accepted and valid. Granted, standards do change over time. However, these were not designed to be based on language, but rather based the standard used by the indicated country.

[Peace Freak]

Thanks Dr. Byte,

I have changed it and thanks to your help I can now experiment with the different formats as need be.

I had a hard time working out how to edit table 6 in phpMyAdmin, so for others who may need to do this, here is a brief explanation.

I am not sure if this is the best way to do it but it worked for me.

In phpMyAdmin, go the zen-cart database connected to your store. Click on the Search button in the main window. Type in ‘country’ (without the quotation marks) in the search field. Select All should be already highlighted, if it is not, click it. Then press Go.

A long list will come up, and you should see something like the following:

5 match(es) inside table zen_address_format

Click on the Browse button in the corresponding column

Find the entry you want to edit and click on the edit icon.

Edit and Save...

[Peace Freak]

Just realized that I had made a mistake with the address format, as the last name should be first... So here is the new format that I am now using:

$country$cr$postcode$cr$state $city$cr$suburb $street$cr$lastname $firstname