Community Add-Ons

this is not a complete file.

add customer addresses from the admin side

in admin/customers.php

ADD

case 'addaddress':


$sql_data_array = array('customers_id' => $HTTP_GET_VARS['cID']);
tep_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array);

$get_address_id = tep_db_query("SELECT address_book_id FROM address_book WHERE customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "' ORDER BY address_book_id DESC LIMIT 1");

$address_id = tep_db_fetch_array($get_address_id);
$new_address_id = $address_id['address_book_id'];

tep_redirect(tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action','add_id')) . 'cID=' . $HTTP_GET_VARS['cID'] . '&action=edit&add_id=' . $new_address_id));

break;


BEFORE LINE

case 'update':

$customers_id = tep_db_prepare_input($HTTP_GET_VARS['cID']);

$customers_firstname = tep_db_prepare_input($HTTP_POST_VARS['customers_firstname']);


CHANGE LINE

<td class="formAreaTitle"><?php echo CATEGORY_ADDRESS; ?></td>

TO

<td class="formAreaTitle"><?php echo '' . CATEGORY_ADDRESS . '&nbsp;&nbsp;&nbsp;<a href="' . tep_href_link(FILENAME_CUSTOMERS, tep_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&amp;action=addaddress') . '">Add an address</a>'; ?></td>

this is not a complete file.

to change customer default address from the admin side

in admin/customers.php

ADD


if(isset($HTTP_POST_VARS['setdefault'])) $sql_data_array['customers_default_address_id'] = $default_address_id;

ABOVE THE LINE

if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $customers_gender;




AND ADD

<tr>

<td class="main" align="right"><input type="checkbox" name="setdefault" value="set"></td>

<td class="main">Set as a default address</td>

</tr>


BELOW THE LINE

<tr>

<td class="main"><?php echo ENTRY_COUNTRY; ?></td>

<td class="main"><?php

if ($error == true) {

if ($entry_country_error == true) {

echo tep_draw_pull_down_menu('entry_country_id', tep_get_countries(), $cInfo->entry_country_id) . '&nbsp;' .

ENTRY_COUNTRY_ERROR;

} else {

echo tep_get_country_name($cInfo->entry_country_id) . tep_draw_hidden_field('entry_country_id');

}

} else {

echo tep_draw_pull_down_menu('entry_country_id', tep_get_countries(), $cInfo->entry_country_id);

}

?></td>

</tr>

v1.6 18 jan 2009
call me old fashion but i missed the buttons next to the customer list
( the truth is the icons in the beginning of the list are very small on a 30inch widescreeen)

there are back in place if you turn it on in configuration of your store

use 7zip to unzip this file

FULL PACKAGE!

Now included languages:
danish
dutch
english
spanish
french
italian - italiano

Here's the Danish translation of the package.

Both of the customer.php files has been changed to danish.

This is the full package.

Fixed minor bug that broke sorting when register_globals=off

Support at: http://forums.oscommerce.com/index.php?showtopic=321793

Full version upload

Customers List Improved v1.5.2
Based on v1.5.1 with the following changes:
Rebuilt tables for correct structure
Many changes for HTML DTD conformance
Date of birth column in list is now displayed only if store configuration uses it
Regrouped contents of edit page for consistency
Company name (if used) is now part of the Address group
Address selector moved inside Address box
Icons for support of other contributions are only displayed if those modules are installed
- Admin Create Account #5388
- Manual Order Maker #4829
- Admin Change Customer Passwords #4469
Added 'Sort by newsletter subscription status' from v1.4.3
Functions tep_address_label() and tep_get_address_format_id do not exist in admin/includes/functions/general.php
so they are conditionally included in this version. (They are from the shop's version of general.php)
Fixed several typographical errors in the English language file
Added French language file (copied from earlier version with my feeble attempts to fill in the missing values.
Corrections are welcomed.)

Support at: http://forums.oscommerce.com/index.php?showtopic=321793

Full package upload

This contribution shows the customer's information in a different and more detailed manner, and has the ability to order the customer's list by different columns.

In this version 1.5.1 the functionality added to use the contributions :
- Admin Change Customer Passwords
- Manual Order Maker
- Account create in admin
- sexy admin
Also added a screenshot of the contribution

Full Package

This contribution shows the customer's information in a different and more detailed manner, and has the hability to order the customer's list by different columns.

In this version 1.5 is is added the functionality to manage all the different addresses from the customer, this is done by adding the code from the "Admin edit any customer address" #6323 contribution.

Full Package

This version is based v1.4_1_3: 2007-06-4 by Qihun

Version française:
Listing clients:
NOMS / PRENOMS / ADRESSE MAIL / NUM TEL / DATE DE CREATION COMPTE CLIENT / DATE DERNIER LOG / NOMBRE DE LOG / ID CLIENTS / NOMBRE DE CRITIQUE /CODE PAYS, VILLE / ACTION=> Editer, commandes, supprimer

Les actions sont géré juste par de petite icones, L'adresse mail est directement cliquable et aussi et surtout on peut classer avec le dernier compte client crée.
Voir le screenshot à l'intérieur.

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.