pete2007 Posted February 23, 2009 Share Posted February 23, 2009 Hi, When I first access my admin section, you can see the Order and Customer Viewing which displays 6 rows of New Customers and 6 Rows of the Latest Orders, it is possible to expand the amount of you view as ideally I would like to see about 10 rows. Any help or advice would be most appreciated! Link to comment Share on other sites More sharing options...
ricksteruk2005 Posted February 23, 2009 Share Posted February 23, 2009 in admin/includes/modules/index/orders.php find this following line $orders_query = tep_db_query("select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by date_last_modified desc limit 6"); change to $orders_query = tep_db_query("select o.orders_id, o.customers_name, greatest(o.date_purchased, ifnull(o.last_modified, 0)) as date_last_modified, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by date_last_modified desc limit 10"); In admin/includes/modules/index/customers.php find the following line $customers_query = tep_db_query("select c.customers_id, c.customers_lastname, c.customers_firstname, ci.customers_info_date_account_created from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_INFO . " ci where c.customers_id = ci.customers_info_id order by ci.customers_info_date_account_created desc limit 6"); change to $customers_query = tep_db_query("select c.customers_id, c.customers_lastname, c.customers_firstname, ci.customers_info_date_account_created from " . TABLE_CUSTOMERS . " c, " . TABLE_CUSTOMERS_INFO . " ci where c.customers_id = ci.customers_info_id order by ci.customers_info_date_account_created desc limit 10"); I dont help with templates (thats what the seller is for) th search function will often help, when it dont try this in google. site:http://www.oscommerce.com/forums then your search word Link to comment Share on other sites More sharing options...
FIMBLE Posted February 23, 2009 Share Posted February 23, 2009 yes you need to edit admin / includes / modules / customers.php find line 20 at the end customers_info_date_account_created desc limit 6"); change the 6 to whatever you need it to be Line 22 with the orders.php Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
pete2007 Posted February 23, 2009 Author Share Posted February 23, 2009 Great, thank you very much :D Link to comment Share on other sites More sharing options...
pete2007 Posted December 10, 2009 Author Share Posted December 10, 2009 Hi, Do you know how I can change the date/time layout within the admin panel which is next to customers and order? Thanks in advance! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.