[Resolved] Make mailing list chronological

[njohn]

Can items in mailing list be sorted chronologically?

[bsmither]

Yes, but we may need to know a bit more.

Is this the Mailing List administration page? If so, a quick edit to the file:

/admin/sources/customers.subscribers.inc.php

Line 126, Was:
$subscribers = $GLOBALS['db']->select('CubeCart_newsletter_subscriber', false, $where, array('email' => 'ASC'), $per_page, $page);

Now:
$subscribers = $GLOBALS['db']->select('CubeCart_newsletter_subscriber', false, $where, array('subscriber_id' => 'ASC'), $per_page, $page);

We can also add sorters to the column headers.

[njohn]

Did it but still alphabetic

BTW where are emails listed - in db? where

[Dirty Butter]

CubeCart_newsletter_subscriber

Sorting by subscriber_id should have worked. Did you clear all caches?

[bsmither]

In admin, Store Settings, Advanced, enable debug mode and enter your IP address (www.whatismyip.com). CubeCart will show the SQL queries used to gather and populate pages at the bottom of the page.

Then view Email List. One of the last SQL queries should be something like:
[18] SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_newsletter_subscriber` ORDER BY `subscriber_id` ASC LIMIT 20 OFFSET 0; -- (0 sec) [NOT CACHED]

[njohn]

Thank you VERY MUCH - that did it!!