Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Order status is wrong...


Guest

Recommended Posts

Posted

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?

Posted

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...?

Posted

what do you have setup for the default order status?

Posted

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?

  • 2 weeks later...
Posted

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:

Posted

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?

Posted
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?

Posted

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.

Posted

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.

Posted
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.

Posted

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?

Posted
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?

 

un-install that stuff and you will know,

Treasurer MFC

Archived

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

×
×
  • Create New...