Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Order status is wrong...


Guest

Recommended Posts

I've got a small problem... my order status does not correctly reflect what the order really is. I can change the actual order to "Shipped" and it shows as "Pending" on the Orders page. I've recently installed the PayPal IPN contribution. Any ideas?

Link to comment
Share on other sites

Hmm... I've checked everything I can think of. For some reason /admin/orders.php does not show what the order really is. Can anybody tell me why this line in /admin/orders.php

<td class="dataTableContent" align="right"><?php echo $orders['orders_status_name']; ?></td>

would be inconsistant with the actual order details...?

Link to comment
Share on other sites

you may have missed a step in the installation or put something in the wrong place. go back thru it and you should probably find your error.

 

did it work prior to the installation?

Link to comment
Share on other sites

  • 2 weeks later...

K... I'm back. I actually moved this entire site over to a new server, reinstalled oscommerce and all the contributions that were on it. The problem remained. Here's a twist though... When I reinstalled paypal IPN I forgot to get the updated version (the one with the fixed paypal.php). Then, when I updated the paypal.php the "Pending" issue turned into a "Cancelled" issue. Everything that was Pending, is now Cancelled. I cannot figure out why this is happening. :huh:

Link to comment
Share on other sites

I have come to find out that the orders page is in fact showing what is in the database. The problem lies within the database not updating correctly, or getting overwritten (I guess)... Any help please. Is there a particular page that you would need to see?

Link to comment
Share on other sites

I have come to find out that the orders page is in fact showing what is in the database. The problem lies within the database not updating correctly, or getting overwritten (I guess)... Any help please. Is there a particular page that you would need to see?

This may be no more than a stab in the dark, but have you compared the numbers assigned to the statuses in the database with the order in which they appear in the admin panel?

Link to comment
Share on other sites

Hmm..? It appears they do...

 

Admin>Localization>Order Status:

 

Pending (default)

Processing

Shipped

On Hold

Canceled

Waiting on E-Check

Waiting on Money Order

 

Databse (with order_status_id):

 

Pending (1)

Processing (2)

Canceled (5)

Shipped (3)

On Hold (4)

Waiting on E-Check (6)

Waiting on Money Order (7)

 

Thanks.

Link to comment
Share on other sites

Alright... I could really use some help here. Now the order statuses are mysteriously switching to '0' in the database and thus are not showing up in the admin at all.

Link to comment
Share on other sites

Alright... I could really use some help here. Now the order statuses are mysteriously switching to '0' in the database and thus are not showing up in the admin at all.

If you have any suspect code, you might want to post it for review.

Link to comment
Share on other sites

Hmm...? I'm not sure. My suspicions are that the PayPal IPN contribution has something to do with it. Can you tell me which files are writting to the database?

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...