Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

TOP URGENT - Orders in Admin not showing


marcheloo

Recommended Posts

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

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

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.

 

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

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

  • 4 weeks later...
  • 3 months later...
Orders not showing in admin???

 

i had the same problem, real easy fix.... 

 

just download the orders.php fix at:

Orders.php fix

 

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

  • 1 year later...
  • 4 months later...
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

  • 3 weeks later...

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

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

  • 3 months later...

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...