Addon installation PayPal/Order Issues

[dschwieg]

Hi,

I'm working with a company that has ZenCart 1.3.8a installed on a Linux server. Recently they requested a few add ons to be added to the site, Simple SEO URL and Recover Cart. I installed both add ons per the instructions and they both worked (well SEO had issues with adding items to the cart with sizes so we disabled it)

Since then ZenCart has been missing orders, not all of them just a few and I don't see a pattern to the ones missed. In trying to fix the problem I have removed the Recover Cart add on and turned on the PayPal IPN logging, this was about 1 week ago. Since then there have been 2 more missed orders. I can see in the PayPal log that it was sent we also got the notification of payment from PayPal. What I don't see is the response log from PayPal saying it was a success, the ones that did process do work. There isn't a record of the order in the Orders list either. Any guidance in what we should be looking at next?

As a side note, if the user is a new user to the site it is saving that information...

Thanks for any help!
Dave

[DrByte]

I would be surprised if the Recover Cart addon has any negative impact on PayPal functionality.

However, the various so-called SEO addons have been known to cause problems with IPN functioning. Merely turning them off doesn't always solve the problem. Sometimes it's necessary to remove the .htaccess alterations as well.

[dschwieg]

Thank you for the advice, I will reset that access to see if it solves the problem.

Thanks,
Dave

[dschwieg]

I would be surprised if the Recover Cart addon has any negative impact on PayPal functionality.

However, the various so-called SEO addons have been known to cause problems with IPN functioning. Merely turning them off doesn't always solve the problem. Sometimes it's necessary to remove the .htaccess alterations as well.

DrByte,

We had the "no order" issue happen again after I reverted the .htaccess change. Is there some sql I can run to possiblly see the orders that are not showing up?

Do you or anyone have any ideas what would be causing this sporatic issue?

Thanks for any help you can give,
Dave

[dschwieg]

I just checked the orders table and it is not in there and I do have the log in the paypal\logs directory.

Thanks again,
Dave

[DrByte]

I do have the log in the paypal\logs directory.

... and you're not sharing that info because ...?

[dschwieg]

Sorry, I have cleaned and personal/private info

the ... points to the actual urls

Feb 20 2009 10:36 -- Keys for submission: Array
(
[charset] => iso-8859-1
[lc] => US
[page_style] => Primary
[custom] => zenid=XXXXXXX4dc5b48a6ffd0cfd34faab2
[business] => [email protected]
[return] => .../storefront/index.php?main_page=checkout_process&referer=paypal
[cancel_return] => .../storefront/index.php?main_page=checkout_payment
[shopping_url] => .../storefront/index.php?main_page=shopping_cart
[notify_url] => .../storefront/ipn_main_handler.php
[redirect_cmd] => _xclick
[rm] => 2
[bn] => zencart
[mrb] => R-XXXX2H795591R
[pal] => XXXXXXBKKGPLQ
[first_name] => FName
[last_name] => LName
[address1] => 111 Main St
[city] => City
[state] => ST
[zip] => 11111
[country] => US
[email] => email######################
[H_PhoneNumber] => 111111
[night_phone_a] => 111
[night_phone_b] => 111
[night_phone_c] => 1111
[day_phone_a] => 111
[day_phone_b] => 111
[day_phone_c] => 1111
[no_shipping] => 1
[upload] => 1
[currency_code] => USD
[cmd] => _ext-enter
[item_name] => www. ... .com Purchase
[item_number] => Store Receipt
[amount] => 120.00
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00


Feb 20 2009 10:37 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

[DrByte]

Feb 20 2009 10:36 -- Keys for submission: Array
(
[charset] => iso-8859-1
[lc] => US
[page_style] => Primary
[custom] => zenid=XXXXXXX4dc5b48a6ffd0cfd34faab2
[business] => [email protected]
[return] => .../storefront/index.php?main_page=checkout_process&referer=paypal
[cancel_return] => .../storefront/index.php?main_page=checkout_payment
[shopping_url] => .../storefront/index.php?main_page=shopping_cart
[notify_url] => .../storefront/ipn_main_handler.php
[redirect_cmd] => _xclick
[rm] => 2
[bn] => zencart
[mrb] => R-XXXX2H795591R
[pal] => XXXXXXBKKGPLQ
[first_name] => FName
[last_name] => LName
[address1] => 111 Main St
[city] => City
[state] => ST
[zip] => 11111
[country] => US
[email] => email######################
[H_PhoneNumber] => 111111
[night_phone_a] => 111
[night_phone_b] => 111
[night_phone_c] => 1111
[day_phone_a] => 111
[day_phone_b] => 111
[day_phone_c] => 1111
[no_shipping] => 1
[upload] => 1
[currency_code] => USD
[cmd] => _ext-enter
[item_name] => www. ... .com Purchase
[item_number] => Store Receipt
[amount] => 120.00
[shipping] => 0.00
[tax] => 0.00
[tax_cart] => 0.00

*That* particular log file can be ignored. It's ONLY a log of info sent TO PayPal. You'd only use it if the data on the PayPal side wasn't recording the same as what you expected it to. 99.9999% of people will NEVER need that file. So, ignore all the ones that start with "Keys for submission:"

Feb 20 2009 10:37 -- IPN PROCESSING INITIATED.
*** Originating IP: 66.211.170.66 notify.paypal.com

*That* file should contain about 20x more information than that. If it doesn't, then your server is triggering some sort of error before it can even complete processing.
Either that, or you're not using log FILES, and you're using emails instead. Don't use the emails, because they come one-at-a-time and get mixed up in their order. Use "log to file", and post the complete file (yes, you can hide your URL and private info, but don't doctor it up too much or it makes it useless).

[dschwieg]

Yes those were the full log files. Is there another place to look for the errors? Also, does it not save the order until PayPal returns, seems like it would be in a pending status or something...

I have other IPN Info logs that worked and do have 20x the lines in them. Looks like when it works I get the following files with these headers (in this order), Keys for submission, IPN PROCESSING INITIATED, IPN INFO - POST VARS..., and then PDT Returned Data Array.

Thanks again!!!
Dave

[DrByte]

I have no idea why *some* of your orders aren't working, and I'm afraid that whatever happened when you were changing and editing files to install something, or whatever, has created a mess that needs specific investigation by someone who has the time and skill to fix it.

While you are working on finding someone to do that, you can try out the "paypal push orders" addon to trick the system into accepting the orders that are apparently "missing". But NOTE: I always cringe when someone goes and uses this addon because unless they actually "fix" the root cause of their problems, they're only applying a bandage and run the risk of leaving data in an unsynchronized state, and can be bad when auditing your transaction records, etc. As with any "problem", one should always fix the *root* cause, not merely apply bandages. [end of disclaimer/warning]

Maybe going back to your system backups and comparing all your site files to look for things that are broken might be of value.