Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Customers Name and Address


Guest

Recommended Posts

  • 11 months later...
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?

Link to comment
Share on other sites

  • 7 months later...
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

Problem solving is a lifestyle, not an isolated activity.

Link to comment
Share on other sites

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/

Link to comment
Share on other sites

  • 1 month later...

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');

Problem solving is a lifestyle, not an isolated activity.

Link to comment
Share on other sites

  • 4 months later...
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!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...