Customer List Improved v1.0
This file is intended as a replacement for 'customers.php' in your osCommerce admin/ directory.
It provides more customer details and a cleaner interface than the default file included with osCommerce 2.2 MS2.
Installation instructions included.
Legend: 
Download

Report
This version has the added ability of sorting the Newsletter Subscribers by their status "Subscribed" or "Unsubscribed". It is further sorted by their account creation date. Showing you the newest subscribers first.
This is a full package!
Look for //DL Begin //DL End if you'd like to manually change.
Please replace line 795 with:
$customers_query_raw = "select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, c.customers_telephone, c.customers_dob, ci.customers_info_date_of_last_logon as last_logon, ci.customers_info_number_of_logons as num_logons, ci.customers_info_date_account_created as date_account_created, a.entry_city as city, a.entry_state as state_alt, z.zone_name as state, ctry.countries_iso_code_2 as country,c.customers_newsletter, a.entry_country_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id left join " . TABLE_CUSTOMERS_INFO . " ci on c.customers_id = ci.customers_info_id left join " . TABLE_COUNTRIES . " ctry on a.entry_country_id = ctry.countries_id left join " . TABLE_ZONES . " z on a.entry_zone_id = z.zone_id " . $search . " order by " . $db_orderby . " " . $sort;
Completely cleaned "customer notes" out
Moved all words to language file ( None etc.)
Added icons instead of text links ( Edit, Delete, Orders)
Removed div block with buttons as they do the same
action as icons
Thats all I think
This is the compete package build on version 1.4.2 including a dutch translation
Made some small adjustments:
1/ removed the call for c.customer_notes (as I do not have this installed - caused a 1054 error)
2/ changed the line that asks if you're sure to delete customer as this was put in the english language in admin/customer.php. It shows now in english and dutch
NOTE: ALWAYS BACK UP YOUR FILES BEFORE USING ANY CONTRIBUTION!! USING THIS CONTRIBUTION IS AT YOUR OWN RISK!!
I CANNOT BE HELD RESPONSIBLE FOR ANY DAMAGE THAT MAY OCUR BY USE OF THIS CONTRIBUTION!!
I have the username contribution and country / state selection contribution installed and merged it with the customer.php.
Here's the Danish translation of the package.
Both of the customer.php files has been changed to danish.
This is the full package.
It's just a small fix. Remove extra <tr> in line.
It must be:
<td class="dataTableContent" align="center"><?php echo
not
<tr><td class="dataTableContent" align="center"><?php echo
I've added a field to show whether the customers are subscribed to the newsletter at a glance. Hope someone else finds this helpful.
I've also included a preview image.
Fixed selection of State in the Country/State/City column. Hopefully this will fix an issue with the state always showing up as 'None'.
The previous README had a missing letter which would have prevented it from working. Thanks to BADDOG for PM'ing me with the correction!
This is an update to the README file only to reflect the need to add customers_notes field to the customer table in your SQL database.
This is a great contrib so thought it was well worth finishing the job and refining a little.
This version from 1.3. (1.3b zip file is corrupt if there ever was one).
This version includes the extras required for the customers.php file, for the Admin Notes contribution. http://www.oscommerce.com/community/contributions,2599
Fixed missing class tags, fonts and sizes all wrong.
Shortened and removed excess Header ro info
Added indicator if client as notes
Moved clients note to far right column along with the buttons that are only used occasionally.
Removed the Delete and Email link from far left column, dangerous and unnessery and not enough room for these in page width.
Other cosmetic changes.
Note there is a preview image with this zip. The image shows some extra contrib's that I have not included in this contrib.
Namely: Add New Client, Send New Password and Client Account Balance.
Great Contrib all credit goes to original authors.
This is a great contrib so thought it was well worth finishing the job and refining a little.
This version from 1.3. (1.3b zip file is corrupt if there ever was one).
This version includes the extras required for the customers.php file, for the Admin Notes contribution. http://www.oscommerce.com/community/contributions,2599
Fixed missing class tags, fonts and sizes all wrong.
Shortened and removed excess Header ro info
Added indicator if client as notes
Moved clients note to far right column along with the buttons that are only used occasionally.
Removed the Delete and Email link from far left column, dangerous and unnessery and not enough room for these in page width.
Other cosmetic changes.
Note there is a preview image with this zip. The image shows some extra contrib's that I have not included in this contrib.
Namely: Add New Client, Send New Password and Client Account Balance.
Great Contrib all credit goes to original authors.
All files in one zip.
Fixed errors on line 253/254
link rel .... href="customers_1_2_3_4_5/stylesheet.css
script .... src="customers_1_2_3_4_5/general.js
should be:
link rel .... href="includes/stylesheet.css
script .... src="includes/general.js
small fix to version 1.3
It gives parse error
just a sily mistake at line 848
Small Update, a truncateted string of Admin Notes will be displayed at customers.php.
To change the lenght of this truncated string look for
substr($customers['notes'], "", "20"
and change 20 to your own.
This is a great contribution, this one is to work with the "admin notes V2.2 "contribution from "Popthetop" changes only in customers.php
All credits to the creators of those nice contribution.
The original package was missing the images for the admin directory. This package includes:
arrow_down.png
arrow_up.png
add these images to your catalog/admin/images directory.
also added screenshot. Excellent contribution, thanks to the original upoader. :-)
Customer List Improved v1.0
This file is intended as a replacement for 'customers.php' in your osCommerce admin/ directory.
It provides more customer details and a cleaner interface than the default file included with osCommerce 2.2 MS2.
Installation instructions included.