Community Add-Ons

Add file to this package
Top » Reports

All Customers Report
for osCommerce Online Merchant v2.2

All Customers Report v1.0 - March 22, 2005

written by Jared Call at client's suggestion
some code nicked and modified from /catalog/admin/customers.php
Released under the GNU General Public License

What this contrib does:

This contribution simply generates a list of all customers and their mailing addresses, alphabetized by last name (surname). Depending on several things, it may take several seconds to generate. The resulting data can be easily copied/pasted into spreadsheets for mailing list labels, importing into other customer management software, etc.

Disclaimer: This contrib has been designed for and tested with osCommerce 2.2 MS2. While it should easily work, perhaps with minor modifications, with other versions of osCommerce, it has not been tested as such.

If you find this contribution useful, please support the osCommerce project by becoming an osCommerce Community Sponsor. At the time of this writing, details of Community Sponsorship can be found at,111 .

Legend:  Download   Report

Expand All / Collapse All

All Customers Report V 2_1d 22 Feb 2009  

Fixed code that displays the page heading so it displays the correct one.
Removed non-standard code from mysql call.
Added newsletter option along with the code to filter by it.
Added code to enter a start/stop date.
Changed code so the report is not ran until submit is clicked. Automatically running it creates problems with sites with a large number of customers.
Made minor changes to the code for formatting and displaying an error message.

This is a full package.

The support thread is at:

SQL Query for MySQL 5 17 Jul 2007  
Version 2.1c 11 Mar 2007  
2.1b - fixes to ver 2.1a 4 Mar 2007  
More Bug Fixes 10 Jun 2006  
SQL query 15 Jan 2006  
2.1a 30 Dec 2005  
File for the french version 7 Sep 2005  
French version 8 Jul 2005  
ACR V2.0 Robert Goth 24 Jun 2005  
v1.1 Jared Call 26 Apr 2005  
All Customers Report Jared Call 22 Mar 2005  
All Customers Report Jared Call 22 Mar 2005