Products     Magento Extension     PCI-Shopping-Carts     Templates       CRELoaded     WordPress Modules     osCommerce Modules       osCommerce Addons       osCommerce Features       osCommerce Management       Payment Modules     CRELoaded Modules       CRE Loaded Addons       CRE Loaded Features       CRE Loaded Management       Payment Modules       CRELoaded Services
Free Stuff
Customization
Templates
Compare Products
You have no items to compare.
Affiliate Info
Affiliate Program FAQ
Affiliate Log In
Recent Orders
Hot Keywords: Order Notification, Order Search, Coupon, Flash Board, Compare, Floating Message, Tracking, Moneris, RSS, Visitor Filter

  Customer List Improved

The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website.
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
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.
   Posted on: 09/05/2008     See contribution details Request Installation with Paid service