Thebestvaporecig Posted December 23, 2013 Posted December 23, 2013 Can anyone tell me how to print out a list of my customer information. Just basics, name, address, email and phone? Thanks!!
FIMBLE Posted December 23, 2013 Posted December 23, 2013 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
burt Posted December 23, 2013 Posted December 23, 2013 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
Thebestvaporecig Posted December 26, 2013 Author Posted December 26, 2013 Thank you both. I will give it a try!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.