Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

HELP: Orders Not Showing


Jezthomp

Recommended Posts

Hello, hope someone can help

 

In the admin home page, it says Orders>Pending 2 however, when i click on the pending button and it goes to orders nothing is there???

 

Whats going on.

 

The orders are not showing.

 

Not very good with mysql so hope its not a problem there?

 

Will i be able to get them to appear or are they lost?

 

Anyone help me please?

Link to comment
Share on other sites

Right am sorry for posting this, have seen that the same question has been asked many times.

 

I can see the orders in myphpadmin and when i do a search for the order no in my admin it comes up just not in the orders page as i have said.

 

So what am i doing wrong?

 

If it does involve myphpadmin would someone mind talking me through it cause as i said i am not very good when it comes to that and dont want to mess anything up.

 

Many thanks again:)

Link to comment
Share on other sites

Anyway to reply to my own post i think i have found the problem just need some help sorting it out now.

 

When i go to myphpadmin and i click on the languages down the left hand side.

 

Instead of the ussual info i just get a blank page and

: Missing parameter: db: Missing parameter: table

 

As i say dont have a clue about mysql, so can anyone help me out, uploading the language sql i assume that would work???

 

Many thanks :)

Link to comment
Share on other sites

Well sorted that and still no luck.

 

order_status looks like

 

INSERT INTO `orders_status` VALUES (1, 1, 'Pending');

INSERT INTO `orders_status` VALUES (2, 1, 'Processing');

INSERT INTO `orders_status` VALUES (5, 1, 'Canceled');

INSERT INTO `orders_status` VALUES (3, 1, 'Delivered');

INSERT INTO `orders_status` VALUES (4, 1, 'On Hold');

 

I'll keep posting to myself hopefully someone will see my pain :(

 

;)

Link to comment
Share on other sites

What is the value stored in the order status column of the orders table for hte orders that are not showing up?

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

Thankyou for your response.

 

Order_status all say 3, have just done a new order and that states 1 none of them appear.

 

This all started happening since i moved to a new host and setup my private ssl.

 

I can see old orders when i just click on orders under customers but anything new. Cannot see at all?

 

Thanks for having a look

Link to comment
Share on other sites

Dunno if this has anything to do with your problem, but I use Authorize.net. If someone attempts to pay with there CC, and the payment fails, the order never completly gets deleted.

 

It creates the order before the info is sent to Authorize.net, so that an order number can be passed, and if the payment fails, the order doesn't get deleted completly. So I find that sometimes on the front page of Admin, it shows pending orders, when in fact there aren't any.

 

Dunno if that helps.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...