Orders not showing up in Paypal or ZC admin (PayPal IPN module)

Ajeh:

When you say the order does not show in your Zen Cart Admin ...

If you type in the orders_id on the search for order id:

Can you now see it?

If so, go to the Modules ... Order Totals ...

Is the Total ot_total installed?

If it is not installed, then the Order will not list on the display of Orders in the Admin ...

Kim, I have similar problem, the order do not show up in zc admin, but when I type order id on the search, the orders do show up, it just do not list there normally. and also, when coustomer login the order history is empty.

the Total ot_total is installed.

Do you know what possible went wrong? I use v1.3.7.

thank you!

When orders do not display in the Admin ... Customers ... Orders ... list but then do show if you type in the Orders # ... check the settings in:
Modules ... Order Totals ...

Do you have the Totals installed?

Without that, they will not show ...

NOTE: this will fix NEW orders not OLD orders ...

OLD orders could be fixed but would take a little manual work in the database tables ...

doubletiger:

Kim, I have similar problem, the order do not show up in zc admin, but when I type order id on the search, the orders do show up, it just do not list there normally. and also, when coustomer login the order history is empty.

Additionally, the updated PayPal patch posted Feb 8 (and updated again on 15th) addresses some problems related to order-status not being set properly in isolated cases.

1. You should install the most recent patch files from this thread:
   http://www.zen-cart.com/forum/showthread.php?t=56216

2. Then, turn ON the PayPal Express Checkout module. If it's already "on", then click Edit and save. If it was NOT already "on", then you can remove it again if you're not using it. Simply turning it on or editing its settings should apply some embedded fixes to the PayPal infrastructure.
   The other files in the patch will help deal with the order-status updates being set.

3. You could further update "old" records by entering the following in the Admin->Tools->SQL Patch screen:

update orders set orders_status = 1 where orders_status=0;

This will set all the "missing" orders to "Pending" status. You can then manually update them appropriately.

Hi all,

Not to put a damper on these things but I have begun to get the same results as all of the previous posters.

I am using the latest version of zenCart, PayPal IPN, and followed the trouble shooting information in this entire thread.

What happens is when a customer selects the option to pay via credit card the order total is transferred but no data about the order. It does not appear in the database either under orders_products, but the transaction is stored under orders.

The log data shows one piece of information that may be helpful.

Nov 09 2007 13:19 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us. 

Any clue as to why this may be happening ?

Thank you

You said you're using "the latest version of Zen Cart".
Does that mean you're using "v1.3.7" or "v1.3.7.1" ?
Which PayPal Patch have you installed, if any?

I believe 1.3.7.1 - My admin module states "Your version of Zen Cart™ appears to be current"

I had installed the PayPal patch PPEC-137-patches-June17 when I was using 1.3.7

I have also enabled PayPal Express, but get the same results as with the IPN module. Only the price but no other transaction data is passed through to Paypal or stored in the database.

Thank you for the quick reply.

After looking at the screen, been working on this to long, I have verified that this store is using 1.3.7 which is what the link at the bottom of the admin pages tells me. Since I have already installed the patches, this is still an issue. I'll keep working on it.

I installed a fresh copy of 1.3.7.1 with no mods and setup my PayPal Express Checkout information. When i went through the order process, again there was no information on the order, just the total.

This leads me to believe that this is a paypal issue, is anyone else experiencing any similar issues?

Thank you

What addons/contributions do you have installed?
Can you post your PayPal debug logs?
http://www.zen-cart.com/forum/showthread.php?t=61199

The logs are located here, I posted one for expressCheckout and one for IPN. http://www.bostec.com/paypal_Logs.zip

The client is currently using the Environment Handling Fee module. Version 1.01 and the Auction Site attributes that goes with that module, version 1.06.

Thank you.

Paypal posted that they were having delays with the IPN today. But I do not know if that would still be affecting sites.

http://www.pdncommunity.com/blog?blog.id=mts_updates

The ipn log you shared is a transaction refund ... but the problem you were reporting seemed to be geared towards purchases, and not refunds.
Do you have logs from purchase transactions?

FYI ... there are often up to 8 log files with a given transaction. You only included one besides the ipn file.

I apologize for that,

I just grabbed two log files.

These are the files for an IPN and an ExpressCheckout.

I verified with IPNcheck.php and the curl check php file that my server is happy with Paypal. Everything checks out ok.

New logs http://www.bostec.com/paypal_log.zip

Thank you

I have to leave work, but I will log on in a couple of hours to see if those logs helped you out. I did not see any errors or warnings, but I do not look at paypal logs that often. My fresh install does not work either, is there something I may have configured wrong on PayPal?

Thank you,

Max

I'm not seeing anything useful in those logs.

I believe these IPN logs are more complete. http://www.bostec.com/ppLogs2.zip

Thank you again.

Unfortunately that's not a valid zip file, or is somehow corrupt.

Hello,

I apologize, but the last files did become corrupted some how. These IPN logs are not corrupt. http://www.bostec.com/payPal_logs2.zip

What tables can I look at in the database besides the orders table?

Thank you.

It seems the process of actually inserting the order record is failing. This is typically caused by changes to the order.php class or failure to load external scripts that are required by addons in the site that are not loaded during the IPN processing routines.

To turn on extra debug logging ...

create a new file:
/includes/extra_datafiles/ipn_debug_on.php

with this content:```

Hello Doc,

Thank you for your patience, it has been a hectic week so far at work. I have turned on the extra debugging features, and have posted the new logs here, http://www.bostec.com/payPal_logs3.zip

I looked at the orders.php and it was last modified as of 4/30/2007, that is when the store went live.

Thank you again for your help so far. I will see if I can track down any external scripts, though I do not believe there are any, as I do not get any javascript errors, but I will keep digging.