Customers Name and Address

[Guest]

My customers name and addresses are not showing up in the "sold to" or "ship to" fields of my invoices or packing slips. Any ideas? Thanks.

[Guest]

My customers name and addresses are not showing up in the "sold to" or "ship to" fields of my invoices or packing slips. Any ideas? Thanks.

<{POST_SNAPBACK}>

 

Anyone? Please.

[Guest]

My customers name and addresses are not showing up in the "sold to" or "ship to" fields of my invoices or packing slips. Any ideas? Thanks.

 

This is the very same problem I am having. Did anyone ever figure it out?

[Seren2]

My customers name and addresses are not showing up in the "sold to" or "ship to" fields of my invoices or packing slips. Any ideas? Thanks.

Did you ever get an answer to this? I'm having the same issue. I posted my question as well

[eXpired]

It seem to have something to do with the address book and it's primary addresses. (Adress not being set as primary address in the database and therefore isn't included into the order->invoice/packingslip) I'm having the same problem and working on a solution/work around for it at the moment.

 

I've done some research, and this contribution seem to fix some of the problem, but adds some other errors.

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

[Seren2]

The problem was an empty address_format table. My install didn't come with the table or the data, causing billing address and shipping address to not display. I begged a copy of the table from a former employer.

DROP TABLE IF EXISTS `address_format`;
CREATE TABLE IF NOT EXISTS `address_format` (
 `address_format_id` int(11) NOT NULL auto_increment,
 `address_format` varchar(128) NOT NULL default '',
 `address_summary` varchar(48) NOT NULL default '',
 PRIMARY KEY  (`address_format_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

INSERT INTO `address_format` (`address_format_id`, `address_format`, `address_summary`) VALUES 
(1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country'),
(2, '$firstname $lastname$cr$streets$cr$city, $state    $postcode$cr$country', '$city, $state / $country'),
(3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country'),
(4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country'),
(5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country');

[Guest]

The problem was an empty address_format table. My install didn't come with the table or the data, causing billing address and shipping address to not display. I begged a copy of the table from a former employer.

DROP TABLE IF EXISTS `address_format`;
CREATE TABLE IF NOT EXISTS `address_format` (
 `address_format_id` int(11) NOT NULL auto_increment,
 `address_format` varchar(128) NOT NULL default '',
 `address_summary` varchar(48) NOT NULL default '',
 PRIMARY KEY  (`address_format_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

INSERT INTO `address_format` (`address_format_id`, `address_format`, `address_summary`) VALUES 
(1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country', '$city / $country'),
(2, '$firstname $lastname$cr$streets$cr$city, $state    $postcode$cr$country', '$city, $state / $country'),
(3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country', '$state / $country'),
(4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country'),
(5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country', '$city / $country');

 

This fixed the problem for me. Thanks!