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

[doubletiger]

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!

[Ajeh]

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

[DrByte]

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.

[TheMusician]

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.
[SCR]Nov 09 2007 13:19 -- IPN NOTICE :: Could not find matched txn_id record in DB. Therefore is new to us. [/SCR]

Any clue as to why this may be happening ?

Thank you

[DrByte]

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?

[TheMusician]

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.

[TheMusician]

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.

[TheMusician]

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

[DrByte]

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

[TheMusician]

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.