Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Printing customer information


Thebestvaporecig

Recommended Posts

Posted

Hi David,

there is no native support for the printing of customers, only via an add on will this be possible, I had a very quick look and can find this one http://addons.oscommerce.com/info/3045 it would need to be updated though for the latest version first.

There may well be more recent add ons you could use there I missed.

Nic

Sometimes you're the dog and sometimes the lamp post

[/url]

My Contributions

Posted

Use phpmyadmin. I -think- something like this might get you the data you need, untested:

 

select CONCAT(c.customers_firstname, ' ', c.customers_lastname) as Name, 
c.customers_email_address as Email,
CONCAT(entry_street_address, ' ', entry_suburb, ' ', entry_city, ' ', entry_state, ' ', entry_postcode, ' ', (select countries_name from countries where countries_id = entry_country_id)) as Address
from customers c 
join address_book a 
on c.customers_id = a.customers_id 
and c.customers_default_address_id = a.address_book_id 
order by c.customers_id DESC

Archived

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

×
×
  • Create New...