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

[Edgar]

[FONT=Arial]Hi folks,

The issue is the client orders item(s) and confirms order. They then proceed to Paypal for checkout. Paypal does not display ordered items, only the final amount for the item(s).

The order doesn't show up in the admin area either.

I've actioned the suggestions in posts,
http://www.zen-cart.com/forum/showthread.php?t=54041
http://www.zen-cart.com/forum/showthread.php?t=53784

[/FONT][FONT=Arial]but no luck. [/FONT]
[FONT=Arial]
Any help or advice would be greatly appreciated[FONT=&quot][/FONT]!
[/FONT]
php 4.4.4
ZC 1.3.6
HTTP Server: Apache/1.3.37 on Linux

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

[Edgar]

Hi Ajeh

Thanks for the quick response.

The orders don't show up in at all orders. The last test purchase didn't generate an order ID.

The ot_total module is installed

Thanks

[Ajeh]

And if you peek in your database in phpMyAdmin and look in the orders table you see nothing new?

What version Zen Cart?

Clean or Upgraded? If an upgrade, from what version and how?

Has this ever worked?

What changed since it last worked for you? Any chnages, add-ons, etc. by you? Any changes by your hosting site?

[Edgar]

Nothing new on in the database re: orders. The site was upgraded from 1.3.5 to 1.3.6 with no major problems using the /zc_install. The orignal developer checked the setting to ensure all was well.

These would be the first round of test purchases.I also removed the tax application in paypal as per an archive thread to see if it was a conflict with PayPal. No luck.

I have yet to talk with the ISP, re: changes to any settings

[DrByte]

It "could" be a PayPal system problem. They are doing system maintenance today and tomorrow, so I suppose it's possible that there could be intermittent glitches.

There are a number of debugging steps you can follow if you enable the debug support in the PayPal module. This is outlined here:
http://www.zen-cart.com/wiki/index.php/PayPal

[Ajeh]

Did you try to Remove, Install and Reconfigure PayPal IPN since your upgrade?

Did you check the PayPal site to ensure nothing changed on your settings there? Sometimes they do change mysteriously ...

Are you using your Primary email address?

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