Does Provide Backup facility?For DNN Website?

Click Here To View All Answers...

First off, Does Provide Backup facility?For DNN Website? Hoping for any response. Another quick question... Hi.

I am trying to change the position of the.

Post code.

On all the address forms from....

I have searched all over the forum for the past 4 hours to no avail....

Can any one help on this one .... Please.

Cheers Malc..

Comments (158)

Ye, however you might wanna make sure and wait for another member to confirm it as I am not sure. Better yet, why don't you e-mail the iPage guys because they can help better...

Comment #1


Thanks for your reply.....

This was the 1st thing I tried, unfortunately this only changes the form on that page. I have also changed the form on other pages in the catalog and admin too....

But when I check the invoice or the packing slip the address still shows in the old format....

This is driving me there a easier way that I am missing???????????....

Help please Malc..

Comment #2

You are right to say that this only affects the form on that page..

For invoice and packing slip, it is dependent on the address format set for your country. You can change the address format through osCommerce Admin. Just look under Locations/Taxes then Countries, and pick your country. You should be able to see an.

Address Format: (Certain Number).

Associated with your country..

If you want to know what the number means, you will have to goto phpMyAdmin and look under.


Table. I'll list the format here just for your reference:.

1. $firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country.

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

3. $firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country.

4. $firstname $lastname$cr$streets$cr$city ($postcode)$cr$country.

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

6. $firstname $lastname$cr$streets$cr$country $postcode.

If I am not wrong, format 2 should be what you are looking for..

Let me know if this helps...

Comment #3

Hi Patrick.

Thanks.... this did the trick. Darn that was mind bender.

Now on to the next prob... my client wants extra pages added and now I have to figure that one out....

The problem is the Invision search is terrible... so if you have angle on creating pages it would be muchly appreciated....

Thanks once again Malc..

Comment #4

Hi Malc,.

I am sorry but I don't really understand what you are look for..

Are you saying that you need to create a new page from scratch?..

Comment #5


Yes I am trying to create a new page from scratch.

Cheers Malc..

Comment #6

In that case, look for a contribution by the name of.

New page template.




It will help you get started in a less confusing way...

Comment #7


Thanks I will take a look at this, although I have manage to add a page using this tutorial which I found last night by accident.....

New Page Tutorial.

Cheers Malc..

Comment #8

I had the same problem with changing the order. I've figured out which files need to be changed:.


(I changed 'Post Code' to 'ZIP Code').

These are the files that need to be changed where you move the table row for the ZIP Code to go above the Country field:.




And if you have the osc_affiliates module, you can edit:.


Comment #9

Umm I'm still having a little problem with this?.

Patrick (Moonstone) posted 6 options for the address type, but when I look at my drop down I only show 5 options? Option 6 is the one I want to put in. I'm running the latest version. Any ideas why I got short changed?..

Comment #10

Hi Vic,.

I have no idea why you got short changed..

However, you can easily add a new address format using.



Simply create a new entry with the following values in the.


Table, and option 6 should be available to you:.




$firstname $lastname$cr$streets$cr$country $postcode.


$country $postcode.

Hope this helps...

Comment #11

Thanks for the assist!.

I added the new entry, no problem, but when I check the orders nothing seems to have changed? Will this only work on NEW orders or will it be retroactive?.

Again thanks for your time and patience...

Comment #12

PS: I should mention that I did go into the countries and change the address format to the new value "6", then looked at previous orders via the packing slip to see if the address changed...

Comment #13

Hi Vic,.

Unfortunately, this change will only be reflected on new orders..

However do not despair, as you can easily change the address format for previous orders simply by issuing an SQL statement. Before we do anything, remember to first backup your data..

Next, let us understand why the change did not affect previous orders. If you look into table.


, you will notice three fields by the names of.






Let's say your previous address format was set to 1. In this case, you will see 1s for all three fields. Similarly, for new orders, you will see 6s for all three fields. These actually determine how the addresses are being displayed for each of the order/invoice..

Now, let's go on to changing the address format for previous orders. Assuming you want to change the address format for ALL previous orders to 6, simply issue the following SQL statement:.

UPDATE `orders` SET `customers_address_format_id` = '6',.

`delivery_address_format_id` = '6',.

`billing_address_format_id` = '6';.

That's it!.

Hope that helps...

Comment #14

Yep, that was it.

Thanks for the assist bud! It displays fine, actually quite easy to set up once you know where to go...

Comment #15


I am trying to change the position of the.

Post code.

On all the address forms from....

I have searched all over the forum for the past 4 hours to no avail....

Can any one help on this one .... Please.

Cheers Malc..

Comment #16

I presume you are referring to the address form when creating an account..

First backup the file.


Next open this file with a text editor..

Around lines 403 - 406, search for:.


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

<td class="main"><?php echo tep_draw_input_field('postcode')'&nbsp;'(tep_not_null(ENTRY_POST_CODE_TEXT) ? '<span class="inputRequirement">'ENTRY_POST_CODE_TEXT'</span>': ''); ?></td>.


Cut this piece of code, and proceed to lines 436 - 439. Search for:.


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

<td class="main"><?php echo tep_get_country_list('country')'&nbsp;'(tep_not_null(ENTRY_COUNTRY_TEXT) ? '<span class="inputRequirement">'ENTRY_COUNTRY_TEXT'</span>': ''); ?></td>.


Paste your code.


This. That's it!.

Hope this helps.....

Comment #17

This question was taken from a support group/message board and re-posted here so others can learn from it.