Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Invoice address


Guest

Recommended Posts

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...