marcheloo Posted December 15, 2004 Share Posted December 15, 2004 Dear All, I have a very big problem. When customers place oders and I login to Admin page, I can see the number of pending orders in the main menu, however when I go to Order page I see nothing and show 0 order(s). I placed many test orders but still can not show orders in Admin page. What should I do ? Regards, Marcheloo Link to comment Share on other sites More sharing options...
peterr Posted December 16, 2004 Share Posted December 16, 2004 Hi, We had a similar situation on an osCommerce site recently. Have you checked the database tables at all ? We found all the order information in the database, but it would not display in admin, because the 'status code' was invalid. Do a browse of one of the order tables and check the order_status column (I think that was the name of the column, .... memory not too good). Peter Link to comment Share on other sites More sharing options...
marcheloo Posted December 16, 2004 Author Share Posted December 16, 2004 I checked it. The order_status is OK , like 1 for Pending orders. Should I change anything ? Link to comment Share on other sites More sharing options...
peterr Posted December 17, 2004 Share Posted December 17, 2004 Hi, I checked it.The order_status is OK , like 1 for Pending orders. Should I change anything ? <{POST_SNAPBACK}> If a value of '1' is what you use for Pending, then no, don't change it. Can you browse/view the order details in the database ? Peter Link to comment Share on other sites More sharing options...
marcheloo Posted December 17, 2004 Author Share Posted December 17, 2004 Yes, I can browse the orders in Database. It's so strange issue. Please helppppppppppppppppppppppp Link to comment Share on other sites More sharing options...
peterr Posted December 17, 2004 Share Posted December 17, 2004 Hi, Can you see the orders when you go admin/customer/order ? Peter Link to comment Share on other sites More sharing options...
marcheloo Posted December 17, 2004 Author Share Posted December 17, 2004 No I can not. (Shows Zero order) When I enter the Order Number manually and search for it, it shows. However, it does not show in a list. May the problem with orders.php or other php files ? Link to comment Share on other sites More sharing options...
marcheloo Posted December 17, 2004 Author Share Posted December 17, 2004 Any update ? Link to comment Share on other sites More sharing options...
peterr Posted December 17, 2004 Share Posted December 17, 2004 Hi, For an order that you cannot 'see' in admin, go to the database (phpMyAdmin) and check the value of the column " orders_status" in the tabale ORDERS. Peter Link to comment Share on other sites More sharing options...
Guest Posted December 18, 2004 Share Posted December 18, 2004 And then what? I'm having the same problem (see here). For some reason my order status is being set to '0'... which doesn't exist. Link to comment Share on other sites More sharing options...
peterr Posted December 18, 2004 Share Posted December 18, 2004 Hi, And then what? I'm having the same problem (see here). For some reason my order status is being set to '0'... which doesn't exist. <{POST_SNAPBACK}> It only happened on another site when the order was being changed from 'pending' to 'processing', and in the comments box, a link (url) was added, so watch what you put in the comments box, that's all I can say. Peter Link to comment Share on other sites More sharing options...
marcheloo Posted December 18, 2004 Author Share Posted December 18, 2004 The order_status value is 1 for orders, I can browse the orders with phpMyAdmin. Any idea ? Link to comment Share on other sites More sharing options...
peterr Posted December 18, 2004 Share Posted December 18, 2004 Hi, The order_status value is 1 for orders, I can browse the orders with phpMyAdmin. Any idea ? <{POST_SNAPBACK}> Any code changes lately at all, new contributions, files uploaded, what has changed since the oder _did_ show up in admin ? Peter Link to comment Share on other sites More sharing options...
marcheloo Posted December 18, 2004 Author Share Posted December 18, 2004 Dear Peter, Truley, I am using Persian langauage of OsCommerce. Everything is working fine in other parts. Even, I copied the original files of OsCommerce and the problem did not solve. Do you know what files I should exactly copy for orders showing in admin ? Link to comment Share on other sites More sharing options...
wads24 Posted January 13, 2005 Share Posted January 13, 2005 Orders not showing in admin??? i had the same problem, real easy fix.... just download the orders.php fix at: Orders.php fix Link to comment Share on other sites More sharing options...
Guest Posted April 24, 2005 Share Posted April 24, 2005 Orders not showing in admin??? i had the same problem, real easy fix.... just download the orders.php fix at: Orders.php fix <{POST_SNAPBACK}> To bad :( I dl the orders.php and replaced the old one but still there is no showing of orders in admin. Oders table is ok, with status 1. Can anyone help me ? Thanx Svante Link to comment Share on other sites More sharing options...
pracing Posted November 22, 2006 Share Posted November 22, 2006 I have this issue and searched everywhere. Help please? I'm sure its an eay fix. Link to comment Share on other sites More sharing options...
Guest Posted April 17, 2007 Share Posted April 17, 2007 I have this issue and searched everywhere. Help please? I'm sure its an eay fix. I've just had a problem with orders not showing - realised that when i ZERO'ED the orders from the database i deleted all the entries from the ORDERS_STATUS table as well. Solution was to re-insert all that data. DROP TABLE IF EXISTS `orders_status`; CREATE TABLE `orders_status` ( `orders_status_id` int(11) NOT NULL default '0', `language_id` int(11) NOT NULL default '1', `orders_status_name` varchar(32) NOT NULL default '', PRIMARY KEY (`orders_status_id`,`language_id`), KEY `idx_orders_status_name` (`orders_status_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `orders_status` -- INSERT INTO `orders_status` VALUES (1, 1, 'Pending'); INSERT INTO `orders_status` VALUES (2, 1, 'Processing'); INSERT INTO `orders_status` VALUES (3, 1, 'Despatched'); It's a silly mistake to make and a bugger of one to spot and correct ... so make sure you didn't delete the ORDER_STATUS information by mistake. :thumbsup: Link to comment Share on other sites More sharing options...
blad Posted May 8, 2007 Share Posted May 8, 2007 There is another problem that might be preventing you from displaying All Orders in the admin section. Around line 367 of admin/orders.php there's a check to see which query should be built based on the order status you selected in the dropdown box. If you select All Orders, its meant to build a query selecting all orders, regardless of status ie., status=x is not in the SQL. On our site, selecting "All Orders" displayed nothing. Reason? With All Orders selects, $HTTP_GET_VARS is equal to a null string "", BUT that doesn't mean it's not set! So... the code was happily looking for order status = "" which didn't exist. The solution is to <i>also</i> check whether 'status' is a null string to see which query to build, and if it is, go to the else to build a query that actually gets all order regardless of status. Was: } elseif (isset($HTTP_GET_VARS['status'])) { Now: // If status not set (only possible when you first go into the screen and never afterwards) AND status is not a null string. } elseif (isset($HTTP_GET_VARS['status']) && $HTTP_GET_VARS['status'] !="") { I'm not sure whether this was fixed on more recent versions of oscommerce, but it was a problem in our older unpdated MS2. Justin Link to comment Share on other sites More sharing options...
Guest Posted May 8, 2007 Share Posted May 8, 2007 I'm not sure whether this was fixed on more recent versions of oscommerce, but it was a problem in our older unpdated MS2. yes it's been fixed. Link to comment Share on other sites More sharing options...
Celebrimbor Posted August 29, 2007 Share Posted August 29, 2007 My orders on admim only appear if done via Credit card or cash delivery. When the checkout is done via Paypal, the order dont appear on admin section. Need Help Tx in advance.. Rafael OScommerce Rocks! Link to comment Share on other sites More sharing options...
atreyu75 Posted August 29, 2007 Share Posted August 29, 2007 Same problem here! Please somebody help thanx "Dreams are the pilar of reality, stop dreaming and you'll exist no more" Link to comment Share on other sites More sharing options...
shadow007 Posted August 29, 2007 Share Posted August 29, 2007 I have met the same problems before. I made an OSC website and at that time, Localization -> Orders Status,all the status was deleted. You may check whether the status on your website is saved. You may also check the phpmyadmin Table orders_status_history. Check the related order data in that table. pay attention to order_total. I hope these will help you. Everyone is changing the world. Everyone is a world. For everyone needs my help, PM or email if I amn't online. Link to comment Share on other sites More sharing options...
Celebrimbor Posted August 29, 2007 Share Posted August 29, 2007 I have met the same problems before. I made an OSC website and at that time, Localization -> Orders Status,all the status was deleted. You may check whether the status on your website is saved.You may also check the phpmyadmin Table orders_status_history. Check the related order data in that table. pay attention to order_total. I hope these will help you. This doesnt helps.. Awaiting... OScommerce Rocks! Link to comment Share on other sites More sharing options...
shadow007 Posted August 29, 2007 Share Posted August 29, 2007 Could I test payment on your website? And please set paypal to sandbox test mode. Everyone is changing the world. Everyone is a world. For everyone needs my help, PM or email if I amn't online. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.