Invoice address

[Guest]

The contribution works great, my install went fine, and i can do the maual order with no problems

 

The only issue I have is when i try to print an invoice or a packing slip the invoice shows up as

 

Firstname Lastname

123 my street

city/suberb, Zip

state, country

 

I need it to show up like

 

Firstname Lastname

123 my street

city/suberb, State, zip

country

 

I have searched this topic but looks like I am the only one with this issue.

 

Help is Appreciated!

[radders]

You can change the address format directly in the database tables. I think the name of the table is 'address_format' or something similar

[insomniac2]

I think you would be looking for something like this for that format. This will change the default address format foraddress_format_id 1

 

I have tool the default oscommerce sql and modified it.

 

If you have already made any changes to the address_format you will have to just copy the default address_format_id 1 field into your database table

 

DROP TABLE IF EXISTS address_format;

CREATE TABLE address_format (

address_format_id int NOT NULL auto_increment,

address_format varchar(128) NOT NULL,

address_summary varchar(48) NOT NULL,

PRIMARY KEY (address_format_id)

);

 

# 1 - Default, 2 - USA, 3 - Spain, 4 - Singapore, 5 - Germany

INSERT INTO address_format VALUES (1, '$firstname $lastname$cr$streets$cr$city$ / $suburbcomma$statecomma$postcode$cr$country','city$ / $suburbcomma$statecomma$country');

INSERT INTO address_format VALUES (2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country');

INSERT INTO address_format VALUES (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country');

INSERT INTO address_format VALUES (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country');

INSERT INTO address_format VALUES (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country');

 

BACKUP!!, BACKUP!! before making any changes

 

I cannot gaurantee this is right for you .. but think it is what you want.

[Guest]

Thanks Alot this is exactly what I needed, I didn't think that the formatting was set up in the database was looking for it in the files.

 

Thanks

Again!!