Mailing Address Problem

[MamaVanGron]

I have spent several hours searching through the forums and can't seem to locate the information I am needing. I know it is in here... just can't seem to find it. I need all of my address to be listed in United States format. I have changed a few files to reflect the change... but I am unable to locate all of the files to change this. The address should like like the following:

Name

Street Address

City, State

Postal Code

Country

 

If anyone could let me know all of the files that this order needs to be changed in, I would greatly appreciate it.

 

P.S. In changing some of these files I somehow got the state to switch spots on the create account page. But the box to input the data is listed at the top of the address forms. (just the box is out of order... not the writing of "state")

[usernamenone]

Just going through and answering those unanswered questions for you.

 

http://search.yahoo.com/search;_ylt=A0oGkw...mp;fr=yfp-t-501

 

http://www.google.com/search?q=change+addr...:en-US:official

 

 

 

I have spent several hours searching through the forums and can't seem to locate the information I am needing. I know it is in here... just can't seem to find it. I need all of my address to be listed in United States format. I have changed a few files to reflect the change... but I am unable to locate all of the files to change this. The address should like like the following:

Name

Street Address

City, State

Postal Code

Country

 

If anyone could let me know all of the files that this order needs to be changed in, I would greatly appreciate it.

 

P.S. In changing some of these files I somehow got the state to switch spots on the create account page. But the box to input the data is listed at the top of the address forms. (just the box is out of order... not the writing of "state")

[MamaVanGron]

Thank you for the information. I didn't think to search using "change address format". I searched for United States Address and tons of variations of that. I found several post about the change... but none told me how to do it. Thanks for your help and your time.

[usernamenone]

I can't tell by your reply if you did find the files to change.

 

 

Thank you for the information. I didn't think to search using "change address format". I searched for United States Address and tons of variations of that. I found several post about the change... but none told me how to do it. Thanks for your help and your time.

[MamaVanGron]

I can't tell by your reply if you did find the files to change.

 

 

I was able to change the Create Account section..... I still do not know where to change the address book though. Once an account is created it still shows in the wrong order when you look it up using My Account. Or when the person trys to ship something it shows it in the wrong order still. I am still researching these changes. Thank you for your help.

[usernamenone]

To move Post code after State, go to catalog/includes/modules/address_book_details.php and look for:

 

<tr>

<td class="main"><?php echo ENTRY_POST_CODE; ?></td>

<td class="main"><?php echo tep_draw_input_field('postcode', $entry['entry_postcode']) . ' ' . (tep_not_null(ENTRY_POST_CODE_TEXT) ? '<span class="inputRequirement">' . ENTRY_POST_CODE_TEXT . '</span>': ''); ?></td>

</tr>

 

 

 

Move that entire section after state so it looks like this:

<tr>

<td class="main"><?php echo ENTRY_CITY; ?></td>

<td class="main"><?php echo tep_draw_input_field('city', $entry['entry_city']) . ' ' . (tep_not_null(ENTRY_CITY_TEXT) ? '<span class="inputRequirement">' . ENTRY_CITY_TEXT . '</span>': ''); ?></td>

</tr>

<?php

if (ACCOUNT_STATE == 'true') {

?>

<tr>

<td class="main"><?php echo ENTRY_STATE; ?></td>

<td class="main">

<?php

if ($process == true) {

if ($entry_state_has_zones == true) {

$zones_array = array();

$zones_query = tep_db_query("select zone_name from " . TABLE_ZONES . " where zone_country_id = '" . tep_db_input($country) . "' order by zone_name");

while ($zones_values = tep_db_fetch_array($zones_query)) {

$zones_array[] = array('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);

}

echo tep_draw_pull_down_menu('state', $zones_array);

} else {

echo tep_draw_input_field('state');

}

} else {

echo tep_draw_input_field('state', tep_get_zone_name($entry['entry_country_id'], $entry['entry_zone_id'], $entry['entry_state']));

}

 

if (tep_not_null(ENTRY_STATE_TEXT)) echo ' <span class="inputRequirement">' . ENTRY_STATE_TEXT;

?></td>

</tr>

<?php

}

?>

 

<tr>

<td class="main"><?php echo ENTRY_POST_CODE; ?></td>

<td class="main"><?php echo tep_draw_input_field('postcode', $entry['entry_postcode']) . ' ' . (tep_not_null(ENTRY_POST_CODE_TEXT) ? '<span class="inputRequirement">' . ENTRY_POST_CODE_TEXT . '</span>': ''); ?></td>

</tr>

 

Do the same for these files also:

 

catalog/includes/modules/address_book_details.php

catalog/includes/modules/checkout_new_address.php

catalog/create_account.php

 

 

I was able to change the Create Account section..... I still do not know where to change the address book though. Once an account is created it still shows in the wrong order when you look it up using My Account. Or when the person trys to ship something it shows it in the wrong order still. I am still researching these changes. Thank you for your help.

[MamaVanGron]

Thank you Lola... I will try that out right now. I also just found this (through another post)

 

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

 

Thank you for all your help! I will post again when changes are complete to mark this as a success.

[MamaVanGron]

Ok.... I have changed the files as you have stated and how the link stated....

 

these are the files I have altered the zip code position in

 

catalog/create_account.php

catalog/includes/modules/address_book_details.php

catalog/includes/modules/checkout_new_address.php

 

 

Doing these changes has resulted in the input screens being changed. But, when the customer views the info on the address book page it is shown in the wrong order. What file do I need to change for that to show properly?

 

Thank you for all your help.... I hope I include enough info in this for anyone who looks at this for help later.

[usernamenone]

There is a sql update you can run through phpmyadmin

 

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

[MamaVanGron]

There is a sql update you can run through phpmyadmin

 

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

 

 

Thanks. I was afraid that would be the answer. I already checked out that contribution... I don't understand any of it. Until last night I didn't know what SQL was..... still dont totally understand it. I tried to change it in there... but after 4 hours of trying last night.... I can't figure it out. I was hoping there was an easier way. Guess not. I will play around with my sql thingy more. (I'm not a computer buff... obviously)

 

Thanks for all your help.

 

PS you wouldn't happen to know where I could change the Font size of the welcome guest thing? I have found TONS of info on moving it or deleting it... but nothing on how to change the font.

[usernamenone]

check this out:

 

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

 

Then to run the sql query you log into phpmyadmin and make sure you are open to the database for your catalog. I have several databases set up but you probably only have 1

 

Looking up and to the left you will locate some links. The center link says SQL, click and a window will open up. You will paste the code:

 

UPDATE `address_format` SET `address_format` = '$firstname $lastname$cr$streets$cr$city $state $postcode$cr$country' WHERE `address_format_id` =1 LIMIT 1 ;

 

 

You will then get a message that it was successful and then close the window.

 

It is advised to create a backups folder and place it in admin folder on your server and then log into admin and create a backup before you attempt to modify you database.

 

Result:

First Last

Street

City State Postcode

Country

 

 

 

Thanks. I was afraid that would be the answer. I already checked out that contribution... I don't understand any of it. Until last night I didn't know what SQL was..... still dont totally understand it. I tried to change it in there... but after 4 hours of trying last night.... I can't figure it out. I was hoping there was an easier way. Guess not. I will play around with my sql thingy more. (I'm not a computer buff... obviously)

 

Thanks for all your help.

 

PS you wouldn't happen to know where I could change the Font size of the welcome guest thing? I have found TONS of info on moving it or deleting it... but nothing on how to change the font.

[MamaVanGron]

Ok... I finally figured out how to change the FONT in welcome guest login line.

 

For anyone like me who couldnt find it... here goes.

 

In Stylesheet.css

 

To change the font in "welcome"

 

TD.main, P.main {

font-family: Verdana, Arial, sans-serif;

font-size: 11px;

line-height: 1.5;

}

 

To change the font of the word "Guest"

SPAN.greetUser {

font-family: Verdana, Arial, sans-serif;

font-size: 12px;

color: #333333;

font-weight: bold;

}

 

 

Hope this helps someone!