Sort customers by creation date How do you sort your customers by the column heads -- name, date, etc.

[m3hd1]

In the OSCommerce admin there's a page that displays the customers, but I don't know how to sort that display. For example, I'd like to see the newest customers, so I'd like to sort the display by "Account Created," which is one of the headers.

 

Is there any way to do this?

 

Thanks,

 

Med

[satish]

$customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");

$customers = tep_db_fetch_array($customers_query);

$cInfo = new objectInfo($customers);

 

here U will not find date been extracted in the out of box oscommerce code.

 

So You will have to modify the code.

 

Satish

[Hotclutch]

In the OSCommerce admin there's a page that displays the customers, but I don't know how to sort that display. For example, I'd like to see the newest customers, so I'd like to sort the display by "Account Created," which is one of the headers.

 

Is there any way to do this?

 

Thanks,

 

Med

 

There is a modified customers.php in contributions that will do this.

[Jan Zonjee]

There is a modified customers.php in contributions that will do this.

Is this the one you mean: http://addons.oscommerce.com/info/223 ?

[tigergirl]

In the OSCommerce admin there's a page that displays the customers, but I don't know how to sort that display. For example, I'd like to see the newest customers, so I'd like to sort the display by "Account Created," which is one of the headers.

 

Is there any way to do this?

 

Thanks,

 

Med

I used Customer Sort Admin Module , sorts customers.php ascending/descending by date / first name / last name.

 

Worked with no problems.

[tigergirl]

Is this the one you mean: http://addons.oscommerce.com/info/223 ?

Great minds think alike!

[burt]

Gosh, one of my very old ones. I'm sure I updated it in jquery, will look for the codebase.

[Hotclutch]

Is this the one you mean: http://addons.oscommerce.com/info/223 ?

 

Actually, this one...just couldn't remember the name. :)

http://addons.oscommerce.com/info/3463

[Jan Zonjee]

Gosh, one of my very old ones.

And alas never made it into the code base in one way or another :(

[m3hd1]

And alas never made it into the code base in one way or another :(

 

That is what exactly I was looking for. Thanks a lot. A+

[m3hd1]

Is this the one you mean: http://addons.oscommerce.com/info/223 ?

 

I used: http://addons.oscommerce.com/info/223 and it does what I needed. cheers

[burt]

I did update this in jQuery. I will try to get the codebase open tomorrow.

[snowrabbit]

Is this the one you mean: http://addons.oscommerce.com/info/223 ?

 

I installed this addon and it looks nice, but whenever I click on the sort arrow, it ticks me log out.

Did anybody had the same issue? How to solve it? Thanks.

[satish]

I installed this addon and it looks nice, but whenever I click on the sort arrow, it ticks me log out.

Did anybody had the same issue? How to solve it? Thanks.

 

In the link that You click it should have the Admin 'osCAdminID' If it is not there then You will get logged out.

 

 

Satish

[snowrabbit]

In the link that You click it should have the Admin 'osCAdminID' If it is not there then You will get logged out.

 

 

Satish

 

Could you please explain a little detail how to fix it? thanks.